Re: Forcing no changes to SQLShared Area?

From: Ganesh Raja <ganesh_at_gtfs-gulf.com>
Date: 13 Apr 2002 04:43:32 -0700
Message-ID: <a8aed4.0204130343.5427cd17@posting.google.com>

Tom,

Galen wants to make sure that the shared sql area is not checked during the next execution.

is there any way to achieve that.

Thanks.

Best Regards,
Ganesh R

Thomas Kyte <tkyte_at_oracle.com> wrote in message news:<a97vor03138_at_drn.newsguy.com>...
> In article <u662wg2zn.fsf_at_grossprofit.com>, Galen says...
> >
> >Is there anyway at the session level to tell Oracle not to even
> >consider the sql shared area on this next piece of SQL. We
> >expect this query not to be there.
> >
> >And, the most important piece, don't push other sql out of the
> >shared SQL area.
> >
> >--
> >Galen Boyer
>
> not unless its a CREATE/DROP type of statement... otherwise in it goes.
Received on Sat Apr 13 2002 - 06:43:32 CDT