Bind variables

From: astalavista <nobody_at_nowhere.com>
Date: Wed, 11 Jul 2007 20:54:18 +0200
Message-ID: <46952759$0$15319$426a34cc@news.free.fr>

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 Received on Wed Jul 11 2007 - 13:54:18 CDT