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: Preston <dontwantany_at_nowhere.invalid>
Date: Sat, 01 Dec 2007 09:18:56 GMT
Message-ID: <4G94j.580$Dh6.265@newsfe4-win.ntli.net>


DA Morgan wrote:

> Peter Teoh wrote:
> >On Dec 1, 1:42 am, DA Morgan <damor..._at_psoug.org> wrote:
> > > And how would caching them do anything other than waste memory?
> >
> > Thanks for the reply.
> >
> > Erh....not sure why u ask that question.
>
> 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.

He wasn't you know - he asked how to *avoid* caching certain DDL & DML statements...

Quote: "Now my question is whether it is possible make DDL/DML queries that will not be cached."

          ^^^

-- 
Preston.
Received on Sat Dec 01 2007 - 03:18:56 CST

Original text of this message

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