Re: X$BH.TCH What does it means ?

From: <sybrandb_at_yahoo.com>
Date: 10 Jun 2003 07:40:50 -0700
Message-ID: <a1d154f4.0306100640.462a3595@posting.google.com>

Miguel Zunda <mzunda_at_polar.es> wrote in message news:<3EE5AF58.9010003_at_polar.es>...
> Hello.
>
> When I look at my x$bh I see hundreds of rows with a tch higher than
> 150. Loads of them are blocks of the same index or of the same table.
>
> 1/What does it mean?.
> 2/What can I do to minimize this value?.
>
> Thanks

1 look x$bh in dict and x$bh.tch in dict_columns and/or in your manual.
2 stay away from it unless you know what you are doing. Youaren't planning to update them manually, are you?

Regards

Sybrand Bakker
Senior Oracle DBA Received on Tue Jun 10 2003 - 09:40:50 CDT