htmldeveloper_at_gmail.com 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_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Fri Nov 30 2007 - 11:42:24 CST
