not all DDL in V$SQL

From: ErikYkema <>
Date: Fri, 3 Oct 2008 08:12:31 -0700 (PDT)
Message-ID: <>


(oracle on AIX5/3)

I seem to be missing many SQL statements that recently executed
(seconds) in V$SQL and/or V$SQLAREA.

These are mostly CTAS (create table as select x, y, z, from table ab).
Also the SELECT part of the CTAS is not visible as a separate statement.

I see other DDL like truncate, create bitmap index, however no drop.

Does anyone explain and comprehend this behaviour?

Regards, Erik Received on Fri Oct 03 2008 - 10:12:31 CDT

Original text of this message