Re: Oracle hints
Date: Wed, 30 Jan 2008 11:01:53 -0800 (PST)
Message-ID: <d7dfb3f5-f5de-4d7d-81d7-e731bb2dc01b@e23g2000prf.googlegroups.com>
joel garry wrote:
> On Jan 29, 6:05 pm, Peter Teoh <htmldevelo..._at_gmail.com> wrote:
> > For a one time query, and if I were to make many of these, caching in
> > the V$SQLAREA is not necessary.
> >
> > Is there any Oracle hint to allow me to do that?
> >
> > Thanks.
>
> v$sqlarea is just a view. Oracle has to hard parse the new query
> anyways. There really isn't anything sensible one could do to avoid
> that.
>
> If there are many singular queries, they'll just get aged out fast.
> If you are reusing other sql just after it is getting aged out, you
> need a bigger shared area anyways.
>
> Sybrand probably understates the issues with cursor_sharing.
> http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/memory.htm#sthref648
> Look at the bulletins and bugs found when searching for cursor_sharing
> on metalink.
>
> I can't always tell if Mladen is joking.
>
> Can't help but think it is a valid wish to be able to tell Oracle
> "hey, don't even bother trying to keep this query around. And no
> peeking!"
>
Joel,
do you mean that in addition to the
/*+ cursor_sharing_exact */ hint,
to have a hint along the lines of:
/*+ cursor_sharing_exact_then_flush */
-bdbafh Received on Wed Jan 30 2008 - 13:01:53 CST