Hi Team,

we are trying to find reason for the cache buffer chains wait event. our aim is to find the object causing the wait and the reason i.e. why it is causing the wait. below are the steps we are performing to find the object:

1.) find P1

select p1, p1raw, p1text
from v$session where sid = 366;

P1 P1RAW P1TEXT
---------- ---------------- -------
5553027696 000000014AFC7A70 address

2.) find times this latch has been requested by sessions but has been missed

select gets, misses, sleeps, name
2 from v$latch where addr = '000000014AFC7A70';

GETS MISSES SLEEPS NAME
----- ------ ------ --------------------
49081 14 10 cache buffers chains

3.) identify the object whose buffer is so popular

select dbarfil, dbablk, tch
from x$bh
where hladdr = '000000014AFC7A70';

DBARFIL DBABLK TCH
------- ------ -----
6 220 34523

The TCH column shows the touch count, i.e. how many times the buffer has been accessed—a measure of its popularity


but unfortunately we don't have x$bh object in our database (10.2.0.5).

so how can we proceed forward now . any help will be much appreciated.

Thanks,
Abhishek