Non-caching of SQL queries

Giganews Newsgroups
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?

Replies