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 waits

Re: latch waits

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Fri, 27 Oct 2000 18:16:48 +0800
Message-ID: <39F95610.7B9@yahoo.com>

Bob Pombrio wrote:
>
> On Fri, 27 Oct 2000 13:13:50 GMT, Brian Peasland
> <peasland_at_edcmail.cr.usgs.gov> wrote:
>
> >Bob,
> >
> >Which latch are you waiting on? There are many latches in an Oracle
> >system. Each one may require a different method to reduce your wait.
> >
> >HTH,
> >Brian
> >
> >
> >Bob Pombrio wrote:
> >>
> >> I am getting long wit time on latches, can any body explain what I need to
> >> adjust to get those numbers to drop?
> >>
> >> Missing my mispent youth. Can I get a refund?
> >
> >--
> >========================================
> >Brian Peasland
> >Raytheons Systems at
> > USGS EROS Data Center
> >These opinions are my own and do not
> >necessarily reflect the opinions of my
> >company!
> >========================================
>
> I seem to be getting a lot of misses on the library cache. Any idea would be
> welcome, as in how do I increase the size of my library cache.
> Missing my mispent youth. Can I get a refund?

See if you are using literals (as opposed to bind variables).. This is a library cache killer...

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Early to bed and early to rise, 
 makes a man healthy, wealthy and wise." - some dead guy
Received on Fri Oct 27 2000 - 05:16:48 CDT

Original text of this message

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