You identified poorly performing SQL by analyzing the V$SQL and V$SQLSTATS views.You want to investigate the plans for t
Posted: Sun Jun 11, 2023 3:49 pm
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.)
A. Query V$SQL_PLAN to view the execution plan.
B. Query DBA_HIST_SQL_PLAN to view the execution plan.
C. Copy and paste the SQL text from the V$SQL view and use EXPLAIN PLAN to generate theexecution plan.
D. Use the dbms_xplan.display_cursor function with the SQL ID and child number to generate the execution plan.
A. Query V$SQL_PLAN to view the execution plan.
B. Query DBA_HIST_SQL_PLAN to view the execution plan.
C. Copy and paste the SQL text from the V$SQL view and use EXPLAIN PLAN to generate theexecution plan.
D. Use the dbms_xplan.display_cursor function with the SQL ID and child number to generate the execution plan.