Re: Reading UNDO and displaying it in v$session

From: kyle Hailey <>
Date: Wed, 2 Apr 2008 14:29:37 -0700
Message-ID: <>


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)?


Received on Wed Apr 02 2008 - 16:29:37 CDT

Original text of this message