System Statistics

[ehegagoka]

hi!

im currently reading on this

http://www.oracle.com/technology/pub...lewis_cbo.html

and i've run the dbms_stats.gather_system_stats procedure which populated the table sys.aux_stats$, so it is now using cpu costing, can i put back my database (9i release 2) to the previous state before i did run the gather_system_stats? thanks again =)

[tabreaz]

How about reading complete document about DBMS_STATS packge.

http://www.psoug.org/reference/dbms_stats.html

[ehegagoka]

hi!
thanks for the reply got it =)

[craigdba]

You can delete your statistics