RE: Updating system statistics
- From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
- To: "Don Seiler" <don@xxxxxxxxx>
- Date: Tue, 12 Dec 2006 21:21:47 +0100
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
