Re: Bind variables

astalavista 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

Level 4 is sufficient for bind vars, or v$sql_bind_capture in 10g and above.

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com


"Semper in excremento, sole profundum qui variat."

------------------------------------------------------------