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 [...]
DBAToolZ
Lightweight Oracle DBA Tools
Archive for July, 2009
Vitaliy Mogilevskiy - Solving ORACLE problems since 1996.
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
- crosscheck controlfilecopy all
- Using TOAD and SQL Developer to compare database objects in schemas in two different databases.
- unable to start the oracle listener
- ORA-00932: inconsistent datatypes:
- Moving object of a schema in the same database
- Db Creation
- can we use Oracle Golden Gate for File system ?
- RMAN error
- How SID find correct DB in oracle ?
- queries running when logging in oracle through toad and pl/sql developer
Recent Comments
- Paul: I’m getting an error: Connect failed because target host or object does not exists. How to solve it?
- Mack: Years after posting this, people, me included, are still praising it. Clear and gets the job done. Pity Oracle...
- huakun: thanks,非常感谢
- yuga: mine is windows7 64 bit
- yuga: in my system oracle odbc dirver not showing ,i have installed oracle 10g and jdk 7 but not showing dirver plz...
Categories
Blogroll
- Ask the VC
- Ask the Wizard
- asktom.oracle.com
- Cal Henderson
- Cary Millsap
- Dan Norris
- Doug's Oracle Blog
- Eric Ries
- Jeremiah Owyang
- Jonathan Lewis
- Karl Arao
- Kevin Closson
- Matt Cutts
- MySQL Performance Blog
- Oracle in the Cloud
- PHP and Oracle: Christopher Jones
- Rasmus Lerdorf
- Richard Foote
- Tim Hall
- Tom Kyte