View the Exhibit to examine the metrics with a threshold.
Which statement is true regarding the Number of Transactions (per second)metric?
View the Exhibit that sets the threshold for the Current Open Cursors Count metric. Why is the Significance Level threshold type not available in the threshold setting?
You executed the following PL/SQL block successfully:
VARIABLE tname VARCHAR2(20)
dbms_addm.insert_finding_directive (NULL, DIR_NAME=>’Detail CPU Usage’, FINDING_NAME=>’CPU Usage’,
:tname := ‘database ADDM task4’;
dbms_addm.analyze_db(:tname, 150, 162);
Then you executed the following command:
SQL> SELECT dbms_addm.get_report(:tname) FROM DUAL;
The above command produces Automatic Database Diagnostic Monitor (ADDM) analysis ____.
View the Exhibit to examine a portion of the output from the VALIDATE DATABASE command. Which statement is true about the block corruption detected by the command?
View the Exhibit exhibit1 to examine the series of SQL commands. View the Exhibit exhibit2 to examine the plans available in the SQL plan baseline. The baseline in the first row of the Exhibit is created when OPTIMIZER_MODE was set to FIRST_ROWS. Which statement is true if the SQL query in exhibit1 is executed again when the value of OPTIMIZER_MODE is set to FIRST_ROWS?
View the Exhibit for some of the parameter settings. You start a session and issue the following command:
SQL>CREATE INDEX emp_ename ON emp(ename)
TABLESPACE users INVISIBLE;
What is the outcome of the above command?
View the Exhibit to examine the error while executing the REPAIR FAILURE command in an RMAN session.
What is the reason for this error?
View the Exhibit exhibit1 to observe the maintenance window property. View the Exhibit exhibit2 to examine the output of the query. Which two statements describe the conclusions? (Choose two.)
View the Exhibit to observe the error.
You receive this error regularly and have to shut down the database instance to overcome the error.
What can the solution be to reduce the chance of this error in future, when implemented?
Which statement is true for enabling Enterprise Manager Support Workbench in Oracle Database 11g to upload the physical files generated by Incident Packaging Service (IPS) to MetaLink?