WG: Complete (more than 4000 char) text of fixed view definition?
Date: Wed, 20 Apr 2011 11:51:08 +0200
Message-ID: <004201cbff40$7a0e52e0$6e2af8a0$_at_gmail.com>
-----Ursprüngliche Nachricht-----
Von: Maxim Demenko [mailto:mdemenko_at_gmail.com]
Gesendet: Mittwoch, 20. April 2011 11:48
An: 'D'Hooge Freek'
Betreff: AW: Complete (more than 4000 char) text of fixed view definition?
Freek,
thanks, again something new for me - i thought, that does apply only to
10053 trace - which gets the content only after hard parse, indeed, after
flush shared_pool, select * from v$session records the recursive sql into
10046 tracefile as well (again, solaris x86/11.2.0.2 if that matters)
Best regards
Maxim
-----Ursprüngliche Nachricht-----
Von: D'Hooge Freek [mailto:Freek.DHooge_at_uptime.be]
Gesendet: Mittwoch, 20. April 2011 11:41
An: mdemenko_at_gmail.com
Betreff: RE: Complete (more than 4000 char) text of fixed view definition?
Maxim,
Are you sure it is not recorded?
Could it be that the session already has the statement parsed, so the sql
itself is not recorded in the trace file?
Regards,
Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge_at_uptime.be
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Apr 20 2011 - 04:51:08 CDT