Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Very long queries in V$SQLTEXT
I'm at site where there seems to be competition to write the longest
SQL's in the world. Once they get above 1000 chars, the usefulness of
V$SQL and V$SQLAREA disappears.
So I've been using V$SQLTEXT - which is fine except for all queries created by Oracle Discoverer. In these cases, V$SQLTEXT returns basically nonsense.
Can anyone assist ? Posts of samples available...
--
"Some days you're the pigeon, and some days you're the statue."
Received on Wed Nov 24 1999 - 06:55:45 CST