| |
| | The Oracle (tm) Users' Co-operative FAQ - time unit (Site not responding. Last check: 2007-10-16) |
 | | In late versions of Oracle 8.1, Oracle started recording time in v$session_wait, v$session_event, and v$system_event (or at least the underlying X$ objects) in micro seconds. |
 | | However, the micro second time is not always exposed - some views have a column time_waited_micro, some only have the time_waited where the value is rounded to the hundredth. |
 | | This does lead to some oddities in trace files, where you may find the elapsed time of an action recorded to the micro second, but the corresponding CPU time rounded to the hundredth, with the effect that the CPU time will sometimes be much larger than the elapsed time. |
| www.jlcomp.demon.co.uk /faq/time_unit.html (252 words) |
|