Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using dbms_stats.gather_system_stats

rg2May 5 2008 — edited Apr 29 2010

Hi,

I have a new server (Win2003 32Bit) running 10.2.0.4 and we just loaded a 50gb database into. Over the weekend I ran my schema and database stats, and now things in the database seems to be running smoothly, but I think we can still improve performance. First by looking at the SQL, but for now, I wanted to try and use the GATHER_SYSTEM_STATS package.

Does this package collect stats on the OS side or the DB itself?

Also, what is the best method for running this? Today our QA dept, is testing it, so should I turn it on now VIA execute dbms_stats.gather_system_stats('start'); and then wait like an hour and then execute dbms_stats.gather_system_stats('stop'); ??? Should I let this run for about 2-3 days??? Is there a better way to implement this through a job that runs it like every 1 or so???

Please advise and help me out determine the best method?

Locked Post

New comments cannot be posted to this locked post.

Locked on May 27 2010

Added on May 5 2008

#general-database-discussions

13 comments

16,796 views