Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help me, please - Problems with Oracle Trace
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 Sat Nov 14 1998 - 13:20:15 CST