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 -> Re: Latch free waits..

Re: Latch free waits..

From: Ron <support_at_dbainfopower.com>
Date: Tue, 27 Jul 2004 15:14:16 -0700
Message-ID: <t96dnWl8DP4nTpvcRVn-vg@comcast.com>

Hello Thomas,

   As a start point, please generate statspack report during the time database experiences bad performance and compare it to the statspack report from the time when performance is acceptable.

  Statspack report provides you with information on what database is waiting most and in the latch section of the report what latches are the problem ones.

   If it is acceptable, please share generated statspack report with the group for further review (no need to send SQL part)

Regards,

   Ron,
   Support
   DBA Infopower
   http://www.dbainfopower.com

"Thomas" <manojtom007_at_yahoo.com> wrote in message news:65182aad.0407261102.1746c19e_at_posting.google.com...
> High amount of latch free waits is slowing down sessions on db.. any
> ideas on how to debug further?
>
>
> LATCH# NAME
> ---------- ---------------------------------------------------------------
-
> 156 shared pool
> 157 library cache
> 159 library cache pin allocation
> 98 cache buffers chains
>
> latch sleep /impacts stats..
>
> LATCH TYPE IMPACT SLEEP RATE WAITS
> HOLDING LEVEL
> ------------------------------------- ----------- ----------
> ------------- -----
> library cache 3589515 0.08%
> 3500279 5
> shared pool 800304 0.03%
> 772812 7
> library cache pin allocation 625205 0.05%
> 613239 4
> row cache objects 25799 0.00%
> 24582 4
> row cache enqueue latch 12366 0.00%
> 12171 5
> library cache pin 3985 0.00%
> 3983 4
Received on Tue Jul 27 2004 - 17:14:16 CDT

Original text of this message

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