Finding and Monitoring SQLs in Execution

 Dictionary view V$SQL_MONITOR is used to find out SQLs currently in execution and a little history of SQLs executed in the recent past. There are several columns in this view that can be useful in different scenarios. Most common use it to find out the elapsed time, CPU time etc. For parallel executions, each parallel slave would appear in this view with column PX_QCSID showing SID of the query coordinator session (session that executed the SQL). For example, if an SQL is executing with 8 parallel servers, there would be 9 rows in this view (WHERE sql_id = <SQL_ID> AND STATUS = ‘EXECUTION’).

ORA-65093: multitenant container database not set up properly

RMAN-00571: ======================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =========== RMAN-00571: ======================================================== RMAN-03002: failure of Duplicate Db command at 06/20/2024 08:01:54 RMAN-05501: aborting duplication of target database RMAN-03015: error occurred in stored script Memory Script RMAN-06136: Oracle error from auxiliary database: ORA-65093: multitenant container database not set up properly