Re: Updating system statistics

It could be that it's historical, but I've had problems with using interval with gather_system_stats so I have gotten into the habit of using explicit start and stop calls. IIRC you should see a job in the job queue to stop the statistics gathering after your specified interval. 

At 01:02 PM 12/12/2006, Don Seiler wrote:

Alright I ran this command:
exec dbms_stats.gather_system_stats(interval=>90,stattab=>'SYSSTATS',statid=>'DEC12'); 

It returned in a minute, so I assume that it runs in the background
now.  I've noticed two rows in my SYSSTATS table, but the column names
are a bit unintuitive.  Is there a HOWTO on interpreting that data?


Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com 


______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ 
--
http://www.freelists.org/webpage/oracle-l

Other related posts: