Re: not all DDL in V$SQL

ErikYkema wrote:
> 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

Go to Morgan's Library at www.psoug.org 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
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org