Re: Competition for OraPerf

"hpuxrac" <johnbhurley_at_sbcglobal.net> wrote in message news:1162575799.259782.56520_at_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.
>

My error - I should have realised that from the second sentence.

It wasn't so long ago that people would quote some paper about buffer busy waits being close to zero and worrying what to do because they'd had a few hundred in the last 6 weeks.

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