Re: 8.1.7 cache buffer chains contention

That's a bit odd, I would have expected to see at least a couple of CR copies of the block.

Is the index in the DEFAULT pool, or one or other of the KEEP / RECYCLE pools ?

Has your value for _db_block_max_cr_dba been adjusted.

How do you feel about doing:

    alter session set events
    'immediate trace name treedump level NNN';

where NNN is the object_id of the index in question. This will dump a line of text for every block in the index, and prove that the block IS the root block (it will be the first one listed in the dumpt) as well as telling us something about the degree of packing of the block and the rest of the index.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases

Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.

Scott Gamble wrote in message ...


>

>I just checked to see how many versions of that block

>showed up in X$bh, and there was only one.

>>