DBAToolZ

Lightweight Oracle DBA Tools

 

Posts tagged WAIT_TIME

Making sense of ASH TIME_WAITED Units

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 [...]

July 31st, 2009 | Tags: , , , , , , | Category: Tuning | Comments (5)

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.

RSS DBA Forums


Recent Comments

  • Dave MacLean: Just used your post (for basic and client). We use UNIX-based Oracle with PC-based Oracle client/ODBC...
  • taiwo: please my users are getting the following errors, i need help to resove the issues..thanks in advance error 6...
  • Toufik HAMDANI: Hello, really nice post. I can now connect to my database ! thanks a lot !
  • Jaruwan: Can I implement SCAN on the standalone 11gR2 server, in the case we convert to full rac later on so nothing...
  • Deepak: Hi, We had Oracle 11gR2 RAC in a SAN environment on Windows 2008 R2 platform. It is now a production server....

Categories


Blogroll


Archives