=> Check the number of Huge Pages configured on the server [oracle@sitdb ~]$ grep -i huge /etc/sysctl.conf vm.nr_hugepages=3495 [oracle...
Read the full lessonAugust 25, 2022 · dba · oracle · queries · scripts
Queries on Locks and Blocks
Blocking session details from GVLock: set lines 1000 select l1.sid || ' inst#'|| l1.INST_ID||' is blocking ' || l2.sid|| ...
Read the full lessonAugust 09, 2022 · apache · apex · ords · tomcat
APEX, ORDS and TOMCAT Setup
########################################################## Environment ########################################################## APE...
Read the full lesson
Subscribe to:
Posts (Atom)
-
By Gowthami | apps-dba.com | Oracle Administration Series A common issue after Oracle Database 19c patching is a Pluggable Database (PDB) o...
-
By Gowthami | apps-dba.com | Oracle Performance Series Oracle Parallel Query (PQ) allows a single SQL statement to be executed by multiple ...
-
By Gowthami | apps-dba.com | Oracle Exadata Series If you work with Oracle Exadata, one of the most transformative features you will encou...
Oracle DBA Lesson 32D — Choosing a Point-in-Time Recovery
Point-in-time recovery deliberately returns the database to an earlier consistent state. Choose the boundary from the incident and the ...
