|Subject:||Non-caching of SQL queries|
|Posted by:||htmldevelop…@gmail.com (htmldevelop…@gmail.com)|
|Date:||Thu, 29 Nov 2007|
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?