Which method would allow the task to execute quickly?

You upgraded database from the Oracle Database 10g to Oracle Database 11g. To test the
performance SQL on the upgraded database. You want to build the before-change performance
data by using SQL Performance Analyzer .Which method would allow the task to execute quickly?

You upgraded database from the Oracle Database 10g to Oracle Database 11g. To test the
performance SQL on the upgraded database. You want to build the before-change performance
data by using SQL Performance Analyzer .Which method would allow the task to execute quickly?

A.
the EXPLAIN PLAN method

B.
the TEST EXECUTE method

C.
the COMPARE PERFORMANCE method

D.
the OPTIMIZER_USE_SQL_PLAN_BASELINE parameter set to TRUE

Show Hint

Leave a Reply 1

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

L. Zhu

L. Zhu

A is correct. Explain Plan method is less time/resource consuming and it takes bind variable into consideration, unlike explain plan sql statement.

Reply