You enabled tracing for a session by executing the following command: SQL>SET AUTOTRACE TRACEONLY; You issued a SQL query in the same session. Which two statements are true? (Choose two.) A. It generates only a report on the execution path…
Examine the values for the following initialization parameters: STATISTICS_LEVEL = TYPICAL TIMED_STATISTICS = true You are managing an online transaction processing (OLTP) system. Application users notice that some queries have poor response time. You determine that queries from session ID…
You are managing an online transaction processing (OLTP) application database. Some users on the system are reporting degradation in the performance of SQL statements. To diagnose the problem, you want to identify the SQL statements that are expensive on system…
View the Exhibit and examine the statistics of a SQL statement.Which two conclusions can you draw from the statistics? (Choose two.) A. The SQL statement has high logical I/O. B. The SQL statement has high CPU usage. C. The SQL…
You are managing an online transaction processing (OLTP) system. Many users complain about the slow response time. You investigated and found that in the Top 5 events, direct path read accounts for 73.2% of the total wait time.Which two are…
You identified poorly performing SQL by analyzing the V$SQL and V$SQLSTATS views. You want to investigate the plans for these SQL statements.Which two methods can you use to pull out the execution plan from the library cache for the already…
You identified a SQL statement with SQL ID 9g485acn2n30m, which is expensive on the resources. To view the execution plan for the statement, you executed the following command: SQL> SELECT * FROM TABLE(dbms_xplan.display_cursor(‘9g485acn2n30m’,1)); What would this command accomplish? A. It…
You identified poorly performing SQL statements that use bind variables. You want to examine the execution plans for the most recently executed statements for further diagnosis. Which method would you recommend to view the execution plans? A. SQL*Plus Autotrace B.…
Examine the SQL statement given below: SQL> EXPLAIN PLAN for SELECT department_name,count(*) FROM hr.employees e, hr.departments d WHERE e.department_id=d.department_id GROUP BY d.department_name; To view the execution plan for the statement, you queried plan_table. View the Exhibit and examine the execution…
You noticed a high number of SQL statements with the same PLAN_HASH_VALUES. View Exhibit1 to see the details. View Exhibit2 to see the details of the SQL text for the statements. What do you infer from the results? A. The…