Oracle Database 12c: Advanced Administration — Question 170

Examine the commands executed to monitor database operations:

SQL> VAR eid NUMBER -
SQL>EXEC :eid := DBMS_SQL_MONITOR.BEGlN_OPERATION('batch_job,FORCED_TRACKING=>'Y');
Which two statements are true?

Answer options

• 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.

Correct answer: C, E

Explanation

Option C is correct because it specifies the necessary conditions for monitoring database operations, which include the STATISTICS_LEVEL and CONTROL_MANAGEMENT_PACK_ACCESS settings. Option E is also true, as it states that all subsequent commands will be treated as one operation under the monitoring context. The other options are incorrect since they either misrepresent the monitoring criteria or do not capture the scope of operations being monitored.