Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Help me, please - Problems with Oracle Trace

Re: Help me, please - Problems with Oracle Trace

From: FireHawk <dba_at_freemail.com.br>
Date: Sun, 15 Nov 1998 10:34:56 -0200
Message-ID: <72mhmg$85a$1@usenet49.supernews.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US