cache buffers chains & library cache --- latch, latch again...
- From: "syed jaffar hussain" <sjaffarhussain@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 24 Apr 2004 17:36:07 +0300
Hi list,
My database is up since december 2003. However, when I go through
v$latch, I found the following;
NAME GETS MISSES SLEEPS
------------------------------ ---------- ----------
----------
session allocation 1197361058 152407 7480
multiblock read objects 1209057328 1532778 41137
cache buffers lru chain 2791819365 7612195 269427 ===>
session idle bit 4929270638 87527 3590
library cache 6719774102 2139530 937599 ====>
cache buffers chains 7.6325E+10 14700803 934118 ====>
redo writing 110939333 616464 75353
messages 161204253 259719 22385
checkpoint queue latch 352667859 73646 4821
shared pool 418028301 58660 12236
row cache objects 458785060 4877123 94779
redo allocation 468537523 125368 9327
enqueues 678664061 26255 3184
And when I dig at v$latch_children I found a lot of misses for
NAME GETS MISSES SLEEPS
------------------------------ ---------- ---------- ----------
library cache 1145632268 500990 289291
library cache 1864524856 524985 73132
library cache 2557348906 753180 507015
library cache 706338241 232889 41144
library cache 445934611 127500 27031
cache buffers chains 50657614 8439 492
cache buffers chains 41067021 6318 427
cache buffers chains 43140486 7272 474
cache buffers chains 44849453 6217 450
cache buffers chains 45883393 5701 407
cache buffers chains 50139764 6847 556
cache buffers chains 56838229 9668 625
cache buffers chains 52779420 10468 653
cache buffers chains 54897378 6835 466
cache buffers chains 61131696 12187 560
(hell a lot of rows found there for these two)
How can I solve this problem? Is it very bad for performance point of
view, having such big values for those latches?
Best Regards,
Syed Jaffar Hussain
Sr Oracle DBA
Sejel Technology Ltd.
+966 2 6064971 x 324 4
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
