Re: not all DDL in V$SQL

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