| Scale of DBA_HIST_SQLSTAT values [message #191664] |
Thu, 07 September 2006 11:09  |
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 #192236 is a reply to message #192060] |
Mon, 11 September 2006 09:06  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
