Re: Oracle hints

On Jan 30, 11:01 am, bdbafh <bdb...@xxxxxxxxx> wrote:
joel garry wrote:
On Jan 29, 6:05 pm, Peter Teoh <htmldevelo...@xxxxxxxxx> 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...
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

Not really, since the idea is not to share at all because it is
unique. Hopefully, this could help Oracle not have to go through all
it's checking. I have no idea if this is realistic, on the surface it
seems simple enough.

jg
--
@home.com is bogus
If wishes were horses
beggars would ride
If turnips were watches
I'd wear one by my side.
.

Relevant Pages