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: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 14 Nov 1998 19:20:15 GMT
Message-ID: <01be1003$19eaff10$0300a8c0@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 Sat Nov 14 1998 - 13:20:15 CST

Original text of this message

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