Oracle Apps DBA

 => Check the number of Huge Pages configured on the server  [oracle@sitdb ~]$ grep -i huge /etc/sysctl.conf vm.nr_hugepages=3495 [oracle@sitdb ~]$ [root@sitdb ~]# grep HugePages /proc/meminfo AnonHugePages:         0 kB ShmemHugePages:        0 kB HugePages_Total:    3495 HugePages_Free:      169 HugePages_Rsvd:        4 HugePages_Surp:        0 [root@sitdb ~]# Which means there are 3495 Huge Pages configured on the server and each page is of size 2 MB or 2048 KB. This will consume 3495 * 2048 KB of RAM memory or 6990 MB of RAM  => The parameter USE_LARGE_PAGES in the database if set to ONLY then the SGA's of all databases and ASM in the server put together should be maximum of 6990 MB. If the SGA exceeds this number for example if SGA is set to 13G then database would not start as the huge pages are not available on the server.  In this scenario, to i...

Blocking session details from GVLock: set lines 1000 select l1.sid || ' inst#'|| l1.INST_ID||' is blocking ' || l2.sid|| ' inst#'||l2.inst_id from gv$lock l1 , gv$lock l2 where l1.block > 0 and l2.request > 0 and l1.id1=l2.id1 and l1.id2=l2.id2; Blocking session details from GVSession: set lines 200 pages 100 col blocking_session for a15 select    blocking_session,    sid,    serial#,    wait_class,    seconds_in_wait from    gv$session where    blocking_session is not NULL order by    blocking_session / Blocking session details from GVSession and GVLock: set lines 2000 pages 100 col blocking_session for a15 col program for a40 col username for a15 col event for a40 col module for a40 col action for a40 col owner for a40 col object_name for a40 col osuser for a40 col logon_time for a40 SELECT b.inst_id,        CASE WHEN A.request != 0 THEN '-> '||a.sid|| ' (BLOCKED)' ELSE TO_CHAR...

########################################################## Environment       ########################################################## APEX Version : 22.1.0 ORDS Version : 21.4.3.117.0405 TOMCAT Version : 9.0.65 Database Version : Oracle Database 12.1.0.2 (Used existing EBS database @ OCI) Operating System : Oracle Linux 7 ########################################################## Install APEX         ########################################################## => Remove existing APEX installation from CDB cd $ORACLE_HOME/apex sqlplus / as sysdba @apxremov_con.sql => Download APEX Software and Copy to database Server as oracle user. unzip  apex_22.1.zip => https://download.oracle.com/otn_software/apex/apex_22.1.zip [oracle@ebsdevdb apex]$ pwd /u01/app/oracle/product/apex [oracle@ebsdevdb apex]$ ls -ltr total 235384 -rw-r--r-- 1 oracle oinstall 241017674 Jul 25 11:16 apex_22.1.zip drwxr-xr-x 2 oracle oinstall...