Re: consistent read and LIO question

From: lsllcm <lsllcm_at_gmail.com>
Date: Wed, 22 Apr 2009 05:37:46 -0700 (PDT)
Message-ID: <ba24c1e6-17e6-4668-9ee8-cc5931d55271_at_d7g2000prl.googlegroups.com>

On Apr 19, 12:02 am, srivenu.kadiy..._at_gmail.com wrote:
> Hi,
> The index could be a non-unique index.
> The leaf block could have been pinned a second time to check that
> there are no other index values  (id = 1000).
> You could try creating a unique index and run the test again
> regards
> srivenu

Yes, it is non unique index. After change to unique index, it is as same as expected,

The consistent read is 4.

Where can I find the related document about this? Oracle document does not state that the leaf block could have been pinned a second time to chech it again,

Thanks
Jacky Received on Wed Apr 22 2009 - 07:37:46 CDT