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@xxxxxxxxxxxx> 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
-- //www.freelists.org/webpage/oracle-l