Re: Reading UNDO and displaying it in v$session
- From: "kyle Hailey" <kylelf@xxxxxxxxx>
- To: makulev@xxxxxxx
- Date: Wed, 2 Apr 2008 14:29:37 -0700
ROW_WAIT_OBJ#
ROW_WAIT_FILE#
ROW_WAIT_BLOCK#
don't seem to be as dependable as P1 and P2 for IO events. Not sure
why. My guess is that sometimes when they are not filled out, then the
values are left over from previous usage (like a db file sequential
read from UNDO in your case)
What are the value of P1 and P2 for your direct path write temp waits
( ie your File and Block)?
Best
Kyle
http://perfvision.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
