Examine the commands executed to monitor database operations:
$> conn sys/oracle@prod as sysdba SQL> VAR eid NUMBER
SQL>EXEC :eid := DBMS_SQL_MONITOR.BEGlN_OPERATION(‘batch_job’,FORCED_TRACKING=>’Y’);
Which two statements are true?
A.
Database operations will be monitored only when they consume a significant amount of resource.
B.
Database operations for all sessions will be monitored.
C.
Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + TUNING.
D.
Only DML and DDL statements will be monitored for the session.
E.
All subsequent statements in the session will be treated as one database operation and will be monitored.
Explanation:
C&E
CE