DBAToolZ

Lightweight Oracle DBA Tools

 

Archive for July, 2009

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


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

  • Hans Forbrich: Douglas – your comment about ASM after Clusterware was true for 11gR1 and older. With 11g...
  • gurpreet: thanks…..
  • MVE: According to the 11gR2 documentation — “OCR and voting disk files can be placed either on ASM, or on...
  • Douglas: Dude, You can’t put the OCR and vote/quorum devices in ASM… Clusterware must be up before ASM,...
  • Craig: Easy to understand -as an Oracle newbie it was very usefull.Thx I followed your tutorial and I’m...

Categories

Blogroll


Archives