Oracle Database 12c Release 2 Performance Tuning Tips & Techniques (Oracle Press) by Richard Niemiec

Author:Richard Niemiec [Niemiec, Richard]
Language: eng
Format: azw3
Publisher: McGraw-Hill Education
Published: 2017-03-22T04:00:00+00:00

NOTE

The Least Redo Block Address (LRBA) is set only for the current block, and the current block is the one with the DIRTY flag set to Y.

Can you get more than six versions of a block? Probably, but this is unsupported. In the following listing, I’ve selected the maximum-allowed CR buffers per data block address (dba):

Now consider an example in 11g where I am updating/selecting multiple times in a block to get the maximum number of CR versions of a block:

Now I am going to run the 11g command to flush the buffer cache:

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.