Re: Help me, please - Problems with Oracle Trace

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 15 Nov 1998 16:12:58 +0100
Message-ID: <364EEF7A.60B7FE4B@sybrandb.demon.nl>

sql_trace = true in init<sid>.ora. This will however produce a deluge of trace files as ALL sessions are traced.

Hth,

Sybrand Bakker, Oracle DBA

FireHawk wrote:

> Cool !
> But the problem is: I can't access source code to put an alter session
> comand.
> Is there a same "alter system" to put in init*.ora ?
> Thanks a lot
>
> Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk> wrote in message
> news:01be1003$19eaff10$0300a8c0_at_WORKSTATION...
> >
> >Alter session set events '10046 trace name context forever, level 4'
> >causes trace to dump all values of bind variables.
> >
> >
> >FireHawk <dba_at_freemail.com.br> wrote in article
> ><72jqba$auu$1_at_usenet42.supernews.com>...
> >> When I make a Oracle trace (alter session set sql_trace=true) the
> >output is
> >> any as:
> >> SELECT CORP,HOUSE,CUST,EQP_TABLE_CODE
> >> FROM CUST_OUTLET
> >> WHERE HOUSE=NVL(:b1,' ')AND CUST=
> >> NVL(:b2,' ')
> >> But, I don't need the b1 and b2 parameters.
> >> I need the contents of b1 and b2.
> >

Received on Sun Nov 15 1998 - 09:12:58 CST