Non-caching of SQL queries

From: <htmldeveloper_at_gmail.com>
Date: Thu, 29 Nov 2007 18:20:13 -0800 (PST)
Message-ID: <fbd78d1c-8bfb-4ebd-a182-2ed42d5cde0c@s19g2000prg.googlegroups.com>

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? Received on Thu Nov 29 2007 - 20:20:13 CST