Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Non-caching of SQL queries

Re: Non-caching of SQL queries

From: DA Morgan <damorgan_at_psoug.org>
Date: Sat, 01 Dec 2007 07:32:37 -0800
Message-ID: <1196523157.584044@bubbleator.drizzle.com>


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.

>
> Sorry, my original question was how to avoid caching when issuing DDL
> or DML statement. Don't quite understand your question sir.
>
> Thanks.

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.org
Received on Sat Dec 01 2007 - 09:32:37 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US