题目内容

You upgraded from a previous Oracle database version to Oracle Database version to Oracle Database12c. Your database supports a mixed workload. During the day, lots of insert, update, and deleteoperations are performed. At night, Extract, Transform, Load (ETL) and batch reporting jobs are run. The ETL jobs perform certain database operations using two or more concurrent sessions.After the upgrade, you notice that the performance of ETL jobs has degraded. To ascertain the cause ofperformance degradation, you want to collect basic statistics such as the level of parallelism, totaldatabase time, and the number of I/O requests for the ETL jobs. How do you accomplish this?()

A. Examine the Active Session History (ASH) reports for the time period of the ETL or batch reporting runs.
B. Enable SQL tracing for the queries in the ETL and batch reporting queries and gather diagnostic data from the trace file.
C. Enable real-time SQL monitoring for ETL jobs and gather diagnostic data from the V$SQL_MONITOR view.
D. Enable real-time database operation monitoring using the DBMS_SQL_MONITOBEGIN_OPERATION function, and then use the DBMS_SQL_MONITOREPORT_SQL_MONITOR function to view the required information.

查看答案
更多问题

氨区的大门(),厂里面内部人员有工作时与化学运行氨区值班人员联系,经化学运行班长许可,并在化学运行氨区值班人员带领下开锁后进入。氨区大门进出后应随时关闭,出来上锁。

以下哪类机关不能查询个人存款()。

A. 公安机关
B. 税务机关
C. 人民法院
D. 工商行政管理机关
E. 审计机关

If the relief valve on a diesel engine cylinder lifts, the cause could be due to ()

A. liquid in the cylinder
B. low compression in the cylinder
C. high exhaust temperature
D. poor fuel penetratio

每个人都生活在自己的主观世界之中,并决定人的行为,这种观点的提出者是()

A. 马斯洛
B. 班杜拉
C. 罗杰斯
D. 斯腾伯格

答案查题题库