Re: 10.1.0.3: cursor_sharing = SIMILAR and ora-7445s

From: Martic Zoran <zoran_martic_at_yahoo.com>
Date: Wed, 24 Nov 2004 09:15:43 -0800 (PST)
Message-ID: <20041124171543.66285.qmail@web52606.mail.yahoo.com>

Paul,

I suppose in the case 1. and 2. you mentioned you have SQL's running much much longer then you need for the parsing.

Why are you bother what is the library cache hit rate?

I have that hit even worse, but do not care about 0.01 second of parsing time while SQL's are running more then 10 seconds.

What is the parse CPU time/CPU used time by session ratio?

What are you trying to fix? Which performance problem?

Regards,
Zoran

• Paul Drake <bdbafh_at_gmail.com> wrote:

> 10.1.0.3 / win32 (w2k svr sp4)
> just a heads up - we're hit issues with
> cursor_sharing = SIMILAR in in
> ternal testing of 10g.
>
> 1. involving database links (where cursor_sharing =
> EXACT has to be used)
> 2. involving somewhat complex queries using GROUPING
>
>
> setting cursor_sharing=EXACT relieved the symptoms.
> going to try cursor_sharing_exact hint.
> we're still not ready for cursor_sharing=EXACT in
> production if we
> want less than a 42% miss rate in the library cache
> sql area
> (*choke*).
>
> Pd
> --
> http://www.freelists.org/webpage/oracle-l
>
                

---

Do you Yahoo!?
All your favorites on one personal page – Try My Yahoo! http://my.yahoo.com

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Nov 24 2004 - 11:11:43 CST