Re: Competition for OraPerf

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 3 Nov 2006 16:33:54 -0000
Message-ID: <BtidnRbcTfQL8tbYnZ2dneKdnZydnZ2d@bt.com>

"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.

-- 
Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Received on Fri Nov 03 2006 - 10:33:54 CST