not all DDL in V$SQL

From: ErikYkema <erik.ykema_at_gmail.com>
Date: Fri, 3 Oct 2008 08:12:31 -0700 (PDT)
Message-ID: <c8819360-0e0b-49d0-8deb-814393fbfa3b@m74g2000hsh.googlegroups.com>


Hello,

(oracle 9.2.0.8 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