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 formats and displays the contents of the execution plan for the cursor with the SQL_ID
‘9g485acn2n30m’ from the library cache.
B.
It formats and displays the contents of the execution plan but does not guarantee accuracy if
the SQL statement has bind variables.
C.
It formats and displays the contents of the execution plan but does not guarantee that the same
execution plan would be executed.
D.
It formats and displays the contents of the execution plan for the cursor with the SQL_ID
‘9g485acn2n30m’ from the DBA_HIST_SQL_PLAN view.
D. Wrong
http://docs.oracle.com/cd/B28359_01/appdev.111/b28419/d_xplan.htm
…based on the information stored in the V$SQL_PLAN and V$SQL_PLAN_STATISTICS_ALL fixed views.
…
dbms_xplan.display_cursor from library cache
A is right