Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 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
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Dec 12 2006 - 14:18:48 CST