Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Non-caching of SQL queries
Peter Teoh wrote:
> On Dec 1, 11:35 am, DA Morgan <damor..._at_psoug.org> wrote:
>> You are not running millions of DDL statements ... your are running >> millions of DML statements. DML is cached and what you were asking was >> hot to cache the DDL. I'm asking why would you want to cache something, >> such as a CREATE TABLE, that will never be executed again during the >> session.
You are correct. My newsreader here at the university already aged that out of what I can see and I got the premise reversed by 180 degrees.
The answer is you can not. And as Sybrand stated, any attempt to alter Oracle's default behavior will bring Oracle to its knees.
A statement used once will age out quickly if there is any need for the space.
-- 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.orgReceived on Sat Dec 01 2007 - 09:32:37 CST
![]() |
![]() |