v$transaction.cr_gets

From: Chuck <skilover_nospam@xxxxxxxxxxxxxx>
Date: Fri, 29 Jun 2007 18:05:07 GMT

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

Follow-Ups:
- Re: v$transaction.cr_gets
  - From: sybrandb

Prev by Date: Re: DX Lock problem
Next by Date: Re: NEED BOOKS ON ORACLE
Previous by thread: Re: Oracle Database 10g R2 RAC Installation On Red Hat Linux Using VMware Server
Next by thread: Re: v$transaction.cr_gets
Index(es):
- Date
- Thread

Relevant Pages

Re: v$transaction.cr_gets
... Is it all consistent gets for the transaction? ... that required rolling back a change from the undo segment listed in the ... So is this all the logical I/O, or just the logical I/O needed ...
(comp.databases.oracle.server)
Re: buffer cache and Rollback
... specific RBS specified in the transaction slot of the updating transaction, ... layer of the onion by reconstructing read consistent images until the block ... A rollback/undo block is just another block, if it's in the buffer cache ...
(comp.databases.oracle.server)
Re: v$transaction.cr_gets
... Is it all consistent gets for the transaction? ... that required rolling back a change from the undo segment listed in the ... Your smug answers are not helpful. ...
(comp.databases.oracle.server)
Re: v$transaction.cr_gets
... Jonathan Lewis wrote: ... Is it all consistent gets for the transaction? ... So is this all the logical I/O, or just the logical I/O needed ...
(comp.databases.oracle.server)
Re: Undo
... consistent gets from cache ... transaction tables consistent reads - undo records applied ... Below is the doc from oracle in the performance tuning guide on ... This is called delayed block cleanout. ...
(comp.databases.oracle.server)