Re: Oracle hints
Date: Wed, 30 Jan 2008 11:01:53 -0800 (PST)
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
> 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.
> 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
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