Oracle Dataguard queries check
We will check data guard status in SQL Plus in this article in many ways. Check 1: Check for LAG from V$DATAGUARD_STATS View. Check 2: It is also possible to… Read more »
Tag: Oracle 11g
Oracle Multimedia (ORDIM) Clean Up in Oracle Database 11.2-12.2
Oracle Multimedia (ORDIM) clean up in Oracle Database 11.2-12.2 is not complicated especially as the removal script checks for the usage of the option first. Oracle Multimedia (ORDIM) Clean Up… Read more »
SQL Plan Management and Auto Capture
SQL Plan Management (SPM) is an Oracle database feature that allows you to establish a set of SQL execution plans that will be used even if the database is subject… Read more »