Oracle
1Z0-063 · Question #19
Examine the commands executed to monitor database operations: $> conn sys/oracle@prod as sysdba SQL> VAR eid NUMBER SQL>EXEC :eid :=…
The correct answer is C. Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to E. All subsequent statements in the session will be treated as one database operation and will be. See the full explanation below for the reasoning.
Question
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?
Options
- ADatabase operations will be monitored only when they consume a significant amount of resource.
- BDatabase operations for all sessions will be monitored.
- CDatabase operations will be monitored only if the STATISTICS_LEVEL parameter is set to
- DOnly DML and DDL statements will be monitored for the session.
- EAll subsequent statements in the session will be treated as one database operation and will be
How the community answered
(45 responses)- A9% (4)
- B2% (1)
- C73% (33)
- D16% (7)
Community Discussion
No community discussion yet for this question.