Re: cache buffers chains & library cache --- latch, latch again...
- From: "biti_rainy" <biti_rainy@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx <oracle-l@xxxxxxxxxxxxx>
- Date: Sun, 25 Apr 2004 0:52:48 +0800
hi,syed jaffar hussain
you may do a statspack report . the value in the DB that is=
up since december 2003 is not useful.
Best regards
yahoo id: feng_chunpei
A new dba from china
---- from the mail-----
>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=
=3D=3D=3D>
>session idle bit 4929270638 87527 3590
>library cache 6719774102 2139530 937599=
=3D=3D=3D=3D>
>cache buffers chains 7.6325E+10 14700803 934118=
=3D=3D=3D=3D>
>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
>----------------------------------------------------------------=
-
>
>.
=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1
----------------------------------------------------------------
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:
