Exact meaning of TCH in X$BH
From: Lothar Flatz <l.flatz_at_bluewin.ch>
Date: Fri, 30 Dec 2022 11:58:11 +0100
Message-ID: <a9afb1f3-05b2-5061-eb94-6cf698c27928_at_bluewin.ch>
Hi guys,
Can somebody give a detailed explanation? Does the number wrap around? When?
Date: Fri, 30 Dec 2022 11:58:11 +0100
Message-ID: <a9afb1f3-05b2-5061-eb94-6cf698c27928_at_bluewin.ch>
Hi guys,
the official definition is : "|X$BH.TCH| is a touch count for the
buffer. A high value for |X$BH.TCH| indicates a hot block."
(Source:
https://docs.oracle.com/en/database/oracle/oracle-database/19/tgdba/instance-tuning-using-performance-views.html#GUID-64F78817-8B4C-4392-B518-CA31CF728B69).
But the biggest value for tch I have ever seen is 255 (unsigned seven bit integer) . Therefore I think it is not exactly a counter but rather reflects a range.
Can somebody give a detailed explanation? Does the number wrap around? When?
Thanks
Lothar
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Dec 30 2022 - 11:58:11 CET