Scenario: If current Archivelog mountpoint is full then we want to change the Archivelog destination in the database. It can...
RAC
Cluster Verification Utility (CVU) ... Oracle Enterprise Manager ... SQL*Plus ... Server Control (SRVCTL) ... Database Configuration Assistant ... Fleet...
Oracle ASH report introduced in Oracle 10g release 2. ASH collects samples of active sessions every second (waiting for non-idle...
If you flush the shared pool, all the statements in cursor will be flushed. Sometimes it is required to flush...