WG: Complete (more than 4000 char) text of fixed view definition?
- From: "Maxim Demenko" <mdemenko@xxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 20 Apr 2011 11:51:08 +0200
-----Ursprüngliche Nachricht-----
Von: Maxim Demenko [mailto:mdemenko@xxxxxxxxx]
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@xxxxxxxxx]
Gesendet: Mittwoch, 20. April 2011 11:41
An: mdemenko@xxxxxxxxx
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@xxxxxxxxx
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » WG: Complete (more than 4000 char) text of fixed view definition? - Maxim Demenko
