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>
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