Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: latch waits
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 guyReceived on Fri Oct 27 2000 - 05:16:48 CDT