Lightweight Oracle DBA Tools
It’s widely believed that v$active_session_history.TIME_WAITED is presented in microseconds. It sure seems like it, but something is amiss as my small test shows. Using two sessions I created a test table in one, inserted a row and then from another session tried to select the same row for update:
| session A > SQL> create [...]
My name is Vitaliy Mogilevskiy -- I started working with ORACLE Products in 1996 (Oracle v7, 7.3.4 was pretty good).
What you will find here is what works for me day in day out - 24x7x365 - simple ORACLE DBA Tools written using components that are available on every Unix platform with an ORACLE database -- sqlplus and KSH.
Do you have DBA questions? Head over to Ask DBA.
DBA Forums