What would this command accomplish?

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?

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.



Leave a Reply 2

Your email address will not be published. Required fields are marked *


L. Zhu

L. Zhu

dbms_xplan.display_cursor from library cache

A is right