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

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

Other related posts: