Apart from parallel DDL, which is a special
case, DDL is not likely to be sharable, therefore
does not get put into the shared SQL area;
so you can't find it.
--
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )
____USA__________November 7/9 (Detroit)
____USA__________November 19/21 (Dallas)
____England______November 12/14
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
ecki wrote in message
<60600e9b.0210290804.d40fcad_at_posting.google.com>...
>Hi all,
>
>how is it possible to readout the Oracle Shared Cursor Cache (Oracle
>8.1.7.4, UNIX) to identify especially SQL statements for No-Logging
>DDL's?
>
>Eckard
Received on Tue Oct 29 2002 - 10:19:14 CST
