Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help me, please - Problems with Oracle Trace
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 - 06:34:56 CST