Re: not all DDL in V$SQL

From: DA Morgan <>
Date: Fri, 03 Oct 2008 13:17:18 -0700
Message-ID: <>

ErikYkema wrote:
> Hello,
> (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

Go to Morgan's Library at and look up DDL Event Triggers. Then look at the code related to: "Trigger To Log Multiple DDL Activities"

Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Fri Oct 03 2008 - 15:17:18 CDT

Original text of this message