latch free - cache buffers chain problem

From: Gulabchand Jaiswal <gulab_jaiswal_at_yahoo.com>
Date: 25 Oct 2001 05:51:25 -0700
Message-ID: <a562ad94.0110250451.226b3c29@posting.google.com>

Hello All,
oracle 8 .1.7.1.0 , OS : Solaris 8, app - pepolesoft portal database

Extrmely hi latching event problem with cahce buffers chains

The top event in statspack report is latch free %total wait time is 88%.
Top 5 Wait Events

~~~~~~~~~~~~~~~~~ Wait % Total 

Event Waits Time (cs) Wt Time

-------------------------------------------- ------------ ------------ ------- 

latch free 1,880 3,421 88.38

Latch activity for DB section shows following as troublesome :

cache buffers chains 9,196,960 13.0 0.0 75 0.0

drilled through v$latch, v$latch_children and x$bh as per oracle technote 61988.1 Was able to find that TCH for blk 5725 in file#12 is abnornally high i.e. 3390. But that doc stops there. Does not tell how to fix it. Any help will be apprciated.

Thx Received on Thu Oct 25 2001 - 07:51:25 CDT