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: joel garry <joel-garry_at_home.com>
Date: Wed, 11 Jul 2007 15:44:29 -0700
Message-ID: <1184193869.965229.5310@j4g2000prf.googlegroups.com>


On Jul 11, 11:54 am, "astalavista" <nob..._at_nowhere.com> wrote:
> Hi,
>
> I have a session with a query very long (more than 10 hour)
> the execution plan seems correct through TOAD :
>
> SELECT SUM (glaa) "AA"
> FROM f0911, f55126a
> WHERE glco = tdco
> AND glpost = 'P'
> AND gllt = 'AA'
> AND glaa > 0
> AND globj >= 100000
> AND globj < 800000
> AND tdac24 = :b3
> AND glco = :b2
> AND globj = :b1
> AND ((globj = tdobj AND tdobj <> ' ') OR (tdobj = ' '))
> AND gldgj >= tddfyj
> AND gldgj < tddgj
> GROUP BY tdac24, glco, globj
>
> Operation Object Name Rows Bytes Cost Object Node In/Out PStart PStop
>
> SELECT STATEMENT Optimizer Mode=CHOOSE 1 53
> SORT GROUP BY NOSORT 1 45 53
> NESTED LOOPS 1 45
> 53
> TABLE ACCESS BY INDEX ROWID PRDDTA.F55126A 1 22 1
> INDEX UNIQUE SCAN PRDDTA.F55126A_PK 48
> TABLE ACCESS BY INDEX ROWID PRDDTA.F0911 1 23 52
> INDEX RANGE SCAN PRDDTA.F0911_40 22 39
>
> I can see the query there are bind variables
> how I can see the value of the bind variables
> during the query is running ?
>
> 10046 level 12 only give me db file sequential read wait event
>
> How I can find bind variable actually used ?
>
> Thanks in advance

See metalink Note:224270.1 Trace Analyzer TRCANLZR - Interpreting Raw SQL Traces with Binds and/or Waits generated by EVENT 10046

The level 12 should have the bind info.

http://www.oracle.com/technology/pub/articles/gallagher_tfm.html looks kind of interesting.

jg

--
@home.com is bogus.
http://lauren.vortex.com/archive/000256.html
Received on Wed Jul 11 2007 - 17:44:29 CDT

Original text of this message

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