单选题

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?（）

发布日期：2020-04-10

Execute the query and view Active Session History (ASH) for information about the query.

Enable SQL trace for the query.

Create a database operation, execute the query, and use the DBMS_SQL_MONITOR. REPORT_SQL_MONITOR function to view the report.

Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.

题王网让考试变得更简单

扫码关注题王，更多免费功能准备上线！

此试题出现在

其他考试

热门试题热门资讯相关试题

[多选题]活动图表示（）等各个活动的流程。

[问答题]简述南极的法律地位。

[单选题]初中文言文中经常出现一词多义的现象，为此教师布置了一项作业，让大家归纳总结“穷”的意义，下列作业中有错误的是（）。

[判断题]《铁路旅客运输规程》站台票当日内有效。

[判断题]在没有打开PBGT切换的情况下，BSC话务统计中不会出现更好小区切换的统计。

[单选题]在与治理层沟通计划的审计范围和时间安排时，下列各项中，注册会计师通常认为不宜沟通的是（　）

[判断题]隔热壁内部结露，主要是由于车内外水蒸气的压力差和隔热壁的渗透性造成的。

[单选题]在计算机系统中能够实现对数据库资源进行统一管理和控制的是（）。

[单选题]完善社会组织监管制度，要建立健全（）的社会组织管理体系。

[单选题]社会学习理论是（）的理论。

暂无相关推荐~

[单选题]A new report process containing a complex query is written, with high impact on ...

[填空题]____

[名词解释题]junctional complex

[问答题]定义一个复数类Complex，重载运算符“＋”，“—”，使之能用于复数的加，减运算，运算符重载函数作为Complex类的成员函数。编程序，分别求出两个复数之和，...

[单选题]Using the report wizard you create a tabular report to display all the columns i...

[单选题]Which report style would you use to create a report listing each department and ...

[单选题]This report ______.

[单选题]What does the output on this report indicate？（） RMAN> report need backup； ...

[单选题]You need to recommend a process for monitoring the servers. The process must mee...

[多选题]Process EIGRP 1 is redistributing routes from process OSPF 2. Which two of the f...