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