Re: not all DDL in V$SQL
Date: Sat, 4 Oct 2008 06:36:15 -0700 (PDT)
On 3 okt, 22:17, DA Morgan <damor..._at_psoug.org> wrote:
> ErikYkema wrote:
> > Hello,
> > (oracle 220.127.116.11 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
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