Can anyone tell me what period of time is recorded in the wait columns. I was under the impression it was 100ths of sec but I'm getting some seriuosly large average wait times if thats the case (e.g. 4003 for buffer busy waits, 7497 for direct path reads etc)
I know its very system dependant but if its hundreths doesnt 40 secs for a buffer busy wait seem excessively high? The majority of my average wait times for reads/write events range from 2000 - 7000 (20secs to 70 secs!!).
The only reason I'm querying it is I've just found this
in the Oracle documentation for buffer busy waits:
"Wait time: Normal wait time is 1 sec. If the session was waiting for a buffer during the last wait, then the next wait will be 3 seconds."
This ties in with a figure of 4000 for buffer busy waits if its in 1000ths of a sec but shows I've got serious problems if its in 100ths!!!