Re: v$transaction.cr_gets

"Chuck" <skilover_nospam_at_bluebottle.com> wrote in message news:nRbhi.35$fw2.28_at_trnddc04...
> What exactly does this column represent? The docs simply say 'Consistent
> gets'. Is it all consistent gets for the transaction? Or is it just gets
> that required rolling back a change from the undo segment listed in the
> xidusn column?

It is all consistent gets made by the
session since the transaction started.

Other readers might like to ponder the following result from a 10.2.0.3 system:

SQL> select log_io, phy_io, cr_get from v$transaction;

    LOG_IO PHY_IO CR_GET
---------- ---------- ----------

        14 17 2185

The description in the manual for "Log_io" is "Logical I/O". So is this all the logical I/O, or just the logical I/O needed to make the transactional changes or what ? Notice that the logical I/O is much smaller than the "consistent gets".

(By the way, that's a rhetorical question intended to highlight why it's perfectly reasonable for someone to ask something that might appear to be a completely stupid question about something that's "in the manual").

-- 
Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html