Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Forcing no changes to SQLShared Area?
Is it your intent to cripple Oracle? Make it not scale and perform
poorly? Perhaps then get SQL Server and talk about how much better it
performs than Oracle?
Then I suggest dropping all bind variables and writing a small proc that flushes the shared pool at regular intervals. You could run the proc from DBMS_JOB. Oh and make the SGA really really small too..
That should really mess things up for you.
Daniel Morgan
Galen Boyer wrote:
> 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
Received on Fri Apr 12 2002 - 17:16:44 CDT