not all DDL in V$SQL
Date: Fri, 3 Oct 2008 08:12:31 -0700 (PDT)
(oracle 22.214.171.124 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