试题详情
- 单项选择题 A new report process containing a complex query is written, with high impact on the database. You wantto collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests. For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and theCONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING. What should you do to accomplish this task?（）
A、Execute the query and view Active Session History (ASH) for information about the query.
B、Enable SQL trace for the query.
C、Create a database operation, execute the query, and use the DBMS_SQL_MONITOR. REPORT_SQL_MONITOR function to view the report.
D、Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.
- C
关注下方微信公众号，在线模考后查看
热门试题
- View the E
- Given： What is
- Which of
- Your SPFILE&en
- 可以使用（）伪列来访问序列。
- In which scenario wo
- You are u
- You plan
- Compressed bac
- Which taskQ
- On your Oracle 12c
- Given： What is
- Examine the command
- Which feature/
- Identify three benef
- Given: Whatistheres
- Examine the&en
- Observethestructureo
- Given: Whatistheres
- 关于PL/SQL块的说法正确的是（）