Re: Updating system statistics

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Tue, 12 Dec 2006 13:18:48 -0700
Message-Id: <20061212201819.B55C3568863@turing.freelists.org>

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

Received on Tue Dec 12 2006 - 14:18:48 CST