Re: not all DDL in V$SQL
Date: Sat, 04 Oct 2008 14:24:46 -0700
> 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.orgReceived on Sat Oct 04 2008 - 16:24:46 CDT