Home » RDBMS Server » Performance Tuning » Scale of DBA_HIST_SQLSTAT values
Scale of DBA_HIST_SQLSTAT values [message #191664] Thu, 07 September 2006 11:09 Go to next message
kwalz58
Messages: 13
Registered: February 2006
Location: SC
Junior Member
OK - I have been going through every doc and book I have around here as well as I can't tell how many web searches trying to get an answer to this. In DBA_HIST_SQLSTAT for the IOWAIT_TOTAL, IOWAIT_DELTA and the rest of the wait columns - what is the scale of the value? Is it in seconds, ms, cs? I know that depending on where you are in some of the other performance tables that can change but I have yet to find it documented exactly what the value scale is for the numbers in that view.
Re: Scale of DBA_HIST_SQLSTAT values [message #192060 is a reply to message #191664] Sun, 10 September 2006 14:25 Go to previous messageGo to next message
shoblock
Messages: 325
Registered: April 2004
Senior Member
times are in microseconds (1/1000000 of a second)

http://download-east.oracle.com/docs/cd/B14117_01/server.101/b10755/statviews_2158.htm
Re: Scale of DBA_HIST_SQLSTAT values [message #192236 is a reply to message #192060] Mon, 11 September 2006 09:06 Go to previous message
kwalz58
Messages: 13
Registered: February 2006
Location: SC
Junior Member
That is the documentation that has confused me. While it directly specifies that the elapsed and CPU times are in microsec's there is no scale specified for the other time based values.

You would think there would be some kind of statement like "All times are in x unless otherwise noted". It almost seems that if they specifiy the ones in microseconds that they are an exception to the rest rather the exemplar.
Previous Topic: other buffer pool .... cache sizes ??
Next Topic: enable Full-Text Search
Goto Forum:
  


Current Time: Sat Dec 03 07:37:39 CST 2016

Total time taken to generate the page: 0.25769 seconds