Re: Reading UNDO and displaying it in v$session
From: kyle Hailey <kylelf_at_gmail.com>
Date: Wed, 2 Apr 2008 14:29:37 -0700
Message-ID: <6f373fd20804021429u449f5eaen550e82da94533569@mail.gmail.com>
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)?
Date: Wed, 2 Apr 2008 14:29:37 -0700
Message-ID: <6f373fd20804021429u449f5eaen550e82da94533569@mail.gmail.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Apr 02 2008 - 16:29:37 CDT