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



Leave a Reply 0

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