Re: High CPU usage

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 12 Oct 2006 05:33:53 -0700
Message-ID: <1160656433.810268.27530@h48g2000cwc.googlegroups.com>

shiva wrote:
> One thing I'm noticing from AWR report is our application is executing
> the same sort of query again and again. Unfortunately it doesn't use
> bind variables. Though it is repeatedly executing them hard parses are
> very less. So I guess most times these are being executed using cpu
> without parsing!!! (may be I could be wrong.) So my question is, is
> CURSOR_SHARING behaviour in 10G different then 9i?
> does changing 'optimizer_features_enable=9.2' give any benifit? Thanks

Doesn't CURSOR_SHARING default to 'EXACT' in 10g? ( That should be the same default as for 9.2 ... at least for later patched versions of 9.2 ... maybe some early releases of 9.2 had a different default ? ( I don't remember exactly ) ).

These guys in a 10g case study have some interesting comments about the cpu cost of a hard parse in 10g

http://www.dbspecialists.com/presentations/case_study_10g.html Received on Thu Oct 12 2006 - 07:33:53 CDT