Re: not all DDL in V$SQL

On 3 okt, 22:17, DA Morgan <damor..._at_psoug.org> wrote:
> 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 atwww.psoug.organd 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
> damor..._at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org

Thanks Daniel,
Looks very useful.
However I want to do performance analysis and IO monitoring on these kinda SQL statements and would be helped if I found the CTAS DDL in these kinda views.
Any clues why these aren't captured there?

Regards, Erik Received on Sat Oct 04 2008 - 08:36:15 CDT