Re: not all DDL in V$SQL

From: DA Morgan <>
Date: Sat, 04 Oct 2008 14:24:46 -0700
Message-ID: <>

ErikYkema wrote:

> 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

Overhead. What you propose, CTAS, would create substantial overhead.

Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Sat Oct 04 2008 - 16:24:46 CDT

Original text of this message