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: Competition for OraPerf

Re: Competition for OraPerf

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 3 Nov 2006 09:43:19 -0800
Message-ID: <1162575799.259782.56520@m7g2000cwm.googlegroups.com>

Jonathan Lewis wrote:
> "hpuxrac" <johnbhurley_at_sbcglobal.net> wrote in message
> news:1162569354.618747.94450_at_f16g2000cwb.googlegroups.com...
> >
> > 63 parses a second is too much.
> >
> > Maybe just ask the people to use the system less often?
> >
>
> Not necessarily - if all 63 parse calls result in
> hit on the session cursor cache, then they might
> as well be held cursors for the amount of impact
> they have on the library cache and related latches.
>
> Even if every single one of them results in a library
> cache seek their impact is likely to be pretty insignificant
> compared to the hammering that's going on with the
> tablescans and the client round-tripping that's hammering
> away like crazy.
>

Sorry I was only kidding about the 63 parses a second being too much. Received on Fri Nov 03 2006 - 11:43:19 CST

Original text of this message

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