Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> latch free - cache buffers chain problem

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US