v$transaction.cr_gets
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?
.
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) |
|