Re: Complete (more than 4000 char) text of fixed view definition?

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_at_gmail.com> wrote:

>
>
> -----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
>
>
>

-- 
Thanks
Paresh
416-688-1003

--
http://www.freelists.org/webpage/oracle-l