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 executed SQL? (Choose two.)

Question

Accepted Answer

A. Query V$SQL_PLAN to view the execution plan. D. Use the dbms_xplan.display_cursor function with the SQL ID and child number to generate the

Answer

B. Query DBA_HIST_SQL_PLAN to view the execution plan.

Answer

C. Copy and paste the SQL text from the V$SQL view and use EXPLAIN PLAN to generate the

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…

Question

Options

How the community answered

Community Discussion