Hi Maxim, I tried with flush shared_pool without any luck. On a side note, the recursive SQL you mentioned shows only other v$ views and not query's View's SQL statement against x$ tables. set pages 0 set lines 300 set termout off alter system flush shared_pool; alter session set events '10053 trace name context forever, level 1'; select * from v$session where rownum = 1; alter session set events '10053 trace name context off'; alter system flush shared_pool; alter session set events '10046 trace name context forever, level 12'; select * from v$session where rownum = 1; alter session set events '10046 trace name context off'; Thanks, Paresh On Wed, Apr 20, 2011 at 5:51 AM, Maxim Demenko <mdemenko@xxxxxxxxx> wrote: > > > -----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 > > > -- Thanks Paresh 416-688-1003