What would you do to revert to the previous set of statistics as soon as possible?

You modified the optimizer statistics of a table by using the DBMS_STATS.GATHER_TABLE_STATS procedure.
You realized that the newly generated statistics have created suboptimal execution plans for that particular table.
What would you do to revert to the previous set of statistics as soon as possible?

You modified the optimizer statistics of a table by using the DBMS_STATS.GATHER_TABLE_STATS procedure.
You realized that the newly generated statistics have created suboptimal execution plans for that particular table.
What would you do to revert to the previous set of statistics as soon as possible?

A.
run Automatic Database Diagnostic Monitor (ADDM) Advisor to recommend a solution

B.
wait for the default automatic optimizer statistics generation

C.
execute the DBMS_STATS.RESTORE_TABLE_STATS procedure

D.
execute the DBMS_STATS.RESTORE_DATABASE_STATS procedure

E.
purge the existing table statistics and execute the DBMS_STATS.GATHER_TABLE procedure with a different set of parameters

Explanation:
This procedure restores statistics of a table as of a specified timestamp ( as_of_timestamp). The procedure will restore statistics of associated indexes and columns as well. If the table statistics were locked at the specified timestamp the procedure will lock the statistics. The procedure will not restore user defined statistics.

REF: Oracle(r) Database PL/SQL Packages and Types Reference 10g Release 2 (10.2)



Leave a Reply 1

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


seenagape

seenagape

Correct answer is