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: Peter Teoh <htmldeveloper_at_gmail.com>
Date: Fri, 30 Nov 2007 20:44:24 -0800 (PST)
Message-ID: <7be4e3a6-a1b4-412b-ac5f-8d3f90687dca@e6g2000prf.googlegroups.com>


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. Received on Fri Nov 30 2007 - 22:44:24 CST

Original text of this message

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