Re: flashback buf free by RVWR waits and LOB caching
- From: Tanel Poder <tanel@xxxxxxxxxx>
- To: Laimutis.Nedzinskas@xxxxxx
- Date: Mon, 28 Feb 2011 15:16:25 +0200
On Mon, Feb 28, 2011 at 10:25 AM, <Laimutis.Nedzinskas@xxxxxx> wrote:
> ...
>
> Only that the actual recovery would happen when LOB is first accessed.
> Which brings some interesting "hows" how Oracle performs LOB version of
> "block cleanout" but again, that is doable provided enough data is stored
> for crash recovery. The only questions are where that data is stored and
> how it affects performance.
>
>
LOB read consistency & block versioning is done using LOB indexes. They keep
pointers to different versions of LOB chunks in them... I have a little
illustration on page 21 of my old LOB internals presentation:
http://www.slideshare.net/tanelp/oracle-lob-internals-and-performance-tuning
Tanel
Other related posts:
