Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Updating system statistics
Results from 90 mins today:
SREADTIM MREADTIM CPUSPEED MBRC ---------- ---------- ---------- ----------
.571 .482 618 14
A bit of an improvement over the currently used stats, and the MBRC isn't too frightening.
I've set it up to gather for 6 hours tomorrow starting at 8 AM.
Thanks all for your help.
Don.
On 12/12/06, Christian Antognini <Christian.Antognini_at_trivadis.com> wrote:
> Don
>
> > Alright I ran this command:
> >
> > exec
> > dbms_stats.gather_system_stats(interval=>90,stattab=>'SYSSTATS',stat
> > id=>'DEC12');
> >
> > It returned in a minute, so I assume that it runs in the background
> > now.
>
> Mark gave you a good tip...
>
> Anyway, if you specify gathering_mode=>'INTERVAL' a job is scheduled to
> stop it. Have a look to dba_scheduler_jobs.
>
> > 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?
>
> Here the two queries I use to extract the data:
>
> SELECT n1 AS sreadtim, n2 AS mreadtim, n3 AS cpuspeed, n11 AS mbrc FROM
> ...
> WHERE c4 = 'CPU_SERIO'
> ORDER BY statid
>
> SELECT n1 AS maxthr, n2 AS slavethr
> FROM ...
> WHERE c4 = 'PARIO'
> ORDER BY statid
>
>
> HTH
> Chris
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Dec 12 2006 - 16:20:47 CST