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: Prepared statement parameter values while tracing

Re: Prepared statement parameter values while tracing

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 05 Jul 2005 20:09:51 +0200
Message-ID: <j4jlc1ho4hvh8mn1gkjfsgcv4ch96ffk23@4ax.com> 





On 5 Jul 2005 09:52:26 -0700, "OcNavi" <ocnavi_at_gmail.com> wrote:



>10046 and level 12

>I set it using alter system set events '10046 trace name context

>forever, level 12'




So please read the trace file carefully. The bind variables ARE
definitely in the trace file, though not in the format you expect.
You need to read more carefully (the output of event 10046 is
documented) and adjust your expectations accordingly.



--
Sybrand Bakker, Senior Oracle DBA


Received on Tue Jul 05 2005 - 13:09:51 CDT












Original text of this message













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