Re: Bind variables

On Jul 11, 1:54 pm, "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

Which release of Oracle is this? Report that information to 4 numbers. Also, is the PLAN_TABLE created with the current definition? We need more information than you've provided in order to even begin answering your question.

David Fitzjarrell Received on Wed Jul 11 2007 - 14:10:43 CDT