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 the execution plan.
D.
Use the dbms_xplan.display_cursor function with the SQL ID and child number to generate the execution plan.