Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Non-caching of SQL queries
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
![]() |
![]() |