Re: Non-caching of SQL queries

htmldeveloper@xxxxxxxxx wrote:
As we all know, any queries got cached in V$SQLAREA, SQLAREA or
various other dynamic performance view.

Now my question is whether it is possible make DDL/DML queries that
will not be cached. The reason are because I know that these queries
are one-off, and putting them into a large batch scripts, I would like
to maximize performance via minimal processing overheads.

Is that possible? Oracle8/9i/10g differences?

And how would caching them do anything other than waste memory?
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@xxxxxxxxxxxxxxxx (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
.