You upgraded from a previous Oracle database version to Oracle Database version to
Oracle Database 12c. Your database supports a mixed workload. During the day, lots of
insert, update, and delete operations 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 of performance degradation, you want to
collect basic statistics such as the level of parallelism, total database time, and the number
of I/O requests for the ETL jobs. How do you accomplish this?
A.
Enable real-time database operation monitoring using the
DBMS_SQL_MONITOR.BEGIN_OPERATION function, and then use the
DBMS_SQL_MONITOR.REPORT_SQL_MONITOR function to view the required
information.
B.
Examine the Active Session History (ASH) reports for the time period of the ETL or batch
reporting runs.
C.
Enable SQL tracing for the queries in the ETL and batch reporting queries and gather
diagnostic data from the trace file.
D.
Enable real-time SQL monitoring for ETL jobs and gather diagnostic data from the
V$SQL_MONITOR view.
http://docs.oracle.com/database/121/ARPLS/d_sql_monitor.htm#ARPLS74780
Overview
The DBMS_SQL_MONITOR package provides information about Real-time SQL Monitoring and Real-time Database Operation Monitoring. These features provide automatic monitoring of SQL statements, PL/SQL blocks, or composite database operations that are considered expensive. A simple database operation is a single SQL statement or PL/SQL procedure or function. A composite database operation is activity between two defined points in time in a database session. The monitored data is collected in V$SQL_MONITOR and V$SQL_PLAN_MONITOR.
D
Total questions in Exam are 85. There are 2 sections.
51 questions for section 1(New Features for DBA).
And 34 questions for section 2(Key DBA Skills).
All questions do not have equal marks.
I passed the exams last week with 73% & 71%.
All questions are from this dump but the answers in the exam are randomized (changed). Study answers carefully, and use comments here to guide your answer choice. Just a few answers here are wrong. Saw additional 4-5 questions in exam. Which you all the best.
Oracle 12c extends this functionality, allowing you to explicitly monitor composite operations made up of a variety of SQL statements and PL/SQL calls containing SQL. The DBMS_SQL_MONITOR package provides the API for this functionality, as well as rehousing some of the subroutines previously found in the DBMS_SQLTUNE package.
Answer is A
Hi,
Today is my exam. Are these questions still valid?
Hi Farooq
How was your exam? were these questions useful for you? were the answers correct?
Thanks a lot!!