Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: System stats fit in two rows?

Re: System stats fit in two rows?

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Thu, 09 Sep 2004 08:45:54 -0600
Message-Id: <6.1.0.6.2.20040909083926.03232940@pop.centrexcc.com>


You get 2 rows per statid, one for serial IO and cpu speed, and one for parallel IO. There are 12 slots to hold statistics (n1 - n12) and there are only 4 statistics values for serial IO (for Oracle 9): cpuspeed, mbrc, sreadtim, and mreadtim so one row is enough to store that.

At 08:23 AM 9/9/2004, Barr, Stephen wrote:
>When we collect system stats into a table we only see two rows of data - is
>this normal?
>
>Should there be more rows?
>
>Thanks,
>

Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com

--
To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe 
To search the archives - http://www.freelists.org/archives/oracle-l/
Received on Thu Sep 09 2004 - 09:46:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US