niusouti.com

多选题Examine the commands executed to monitor database operations: $> conn sys oracle/oracle@prod as sysdba SQL > VAR eid NUMBER SQL > EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION (‘batch_job’ , FORCED_TRACKING => ‘Y’); Which two statements are true?()ADat

题目
多选题
Examine the commands executed to monitor database operations: $> conn sys oracle/oracle@prod as sysdba SQL > VAR eid NUMBER SQL > EXEC: eid := DBMS_SQL_MONITOR.BEGIN_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.


相似考题
参考答案和解析
正确答案: C,E
解析: 暂无解析