Re: Reading UNDO and displaying it in v$session
From: Yong Huang <yong321_at_yahoo.com>
Date: Thu, 3 Apr 2008 11:47:56 -0700 (PDT)
Message-ID: <859943.45565.qm@web80607.mail.mud.yahoo.com>
You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost. http://tc.deals.yahoo.com/tc/blockbuster/text5.com
Date: Thu, 3 Apr 2008 11:47:56 -0700 (PDT)
Message-ID: <859943.45565.qm@web80607.mail.mud.yahoo.com>
Jonathan Lewis posted a message about this problem before having the same
suspicion.
http://groups.google.com/group/comp.databases.oracle.server/browse_frm/thread/4ba9035dd2c70992
Yong Huang
> From: "kyle Hailey" <kylelf_at_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
You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost. http://tc.deals.yahoo.com/tc/blockbuster/text5.com
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Apr 03 2008 - 13:47:56 CDT