Re: Oracle hints



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.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
.

Relevant Pages

  • Re: Oracle hints
    ... Is there any Oracle hint to allow me to do that? ... Oracle has to hard parse the new query ... don't even bother trying to keep this query around. ...
    (comp.databases.oracle.server)
  • Re: Oracle hints
    ... Is there any Oracle hint to allow me to do that? ... Oracle is merciless for people building unscalable applications. ...
    (comp.databases.oracle.server)
  • Re: Views - performance
    ... when u use stored object views oracle has to read the data dictionary ... this includes lots of steps for execution ... semantics of the query and fires it ... you'll possibly have any idea is to use explain plan to provide a base ...
    (comp.databases.oracle.server)
  • RE: DBI-1.48 bind_param_inout produces ORA-01461 colliding with a CLOB
    ... can pass strings as varchar's and have them inserted ... In theory I could write something to query the ... CLOB w/in Oracle is probably what is killing me... ...
    (perl.dbi.users)
  • Re: Equilevant of Oracle for optional records
    ... and a normalized t2 could be more useful, to build the query, and once this ... the Iqaluit Trauma: ... Oracle handles this data structure perfectly but I suspect it might be ...
    (microsoft.public.access.queries)