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: Bind variables

Re: Bind variables

From: astalavista <nobody_at_nowhere.com>
Date: Thu, 12 Jul 2007 21:28:27 +0200
Message-ID: <469680de$0$25873$426a74cc@news.free.fr>

>

> No, we do not need more information. The answer to his question is that
> with 10046, level 12, bind variables will be in the trace file. This is
> so ever since Oracle7. Unfortunately, tkprof doesn't format bind
> variables, so he will have to read the raw trace file. The version is
> important only if he's running Oracle 6 or lower versions.

OK thanks I think I don't see bind variable because the query is running and
I don't set the event before the query start am i right ?
I only see wait event: db file sequential read

My question was :
is it possible to see bind variables of a running query ??

Thanks Received on Thu Jul 12 2007 - 14:28:27 CDT

Original text of this message

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