Re: Queries & bind variable values

From: sumit Tyagi <dba.tyagisumit_at_gmail.com>
Date: Wed, 1 Jul 2015 16:36:59 +0530
Message-ID: <CAFW4NVygyPtWK-MyEur1L+8svdt-N7f8dvuu09ugOtzY59B3nQ_at_mail.gmail.com>

Thanks all i will refer above links and test them in my env

On Mon, Jun 29, 2015 at 7:54 PM, Anju Garg <anjugarg66_at_gmail.com> wrote:

> Sumit,
>
> Please refer to following blog post of mine:
>
>
> http://oracleinaction.com/find-out-values-of-bind-variables-across-multiple-executions-of-a-sql/
>
> Hope it helps!
>
> regards
> Anju Garg
>
> Regards,
> *Anju Garg*
>
> *Corporate Trainer (Oracle DBA), Blogger, Speaker, Author*
> Oracle 12c Database Administration OCP
> Oracle 11g R2 RAC OCE
> Oracle 11g Performance Tuning OCE
> Oracle 11g SQL Tuning OCE
>
> *Blog:* http://oracleinaction.com
>
>
>
>
>
> On Mon, Jun 29, 2015 at 2:53 PM, sumit Tyagi <dba.tyagisumit_at_gmail.com>
> wrote:
>
>> Hi Oracle-L team ,
>>
>> How can we get the information ( report) regarding the actual values
>> that were used at the time of query execution . We have sql_id info .
>>
>> Use case : client want to know the values of bind variables for the
>> sessions that are captured in blocking session query . Below is the
>> blocking session query .
>>
>> SELECT DISTINCT S1.USERNAME || '_at_' || S1.MACHINE
>> || ' ( INST=' || S1.INST_ID || ' SID=' || S1.SID || ' ) IS BLOCKING '
>> || S2.USERNAME || '_at_' || S2.MACHINE || ' ( INST=' || S1.INST_ID || ' SID='
>> || S2.SID || ' ) ' AS BLOCKING_STATUS
>> FROM GV$LOCK L1, GV$SESSION S1, GV$LOCK L2, GV$SESSION S2
>> WHERE S1.SID=L1.SID AND S2.SID=L2.SID
>> AND S1.INST_ID=L1.INST_ID AND S2.INST_ID=L2.INST_ID
>> AND L1.BLOCK > 0 AND L2.REQUEST > 0
>> AND L1.ID1 = L2.ID1 AND L1.ID2 = L2.ID2;
>>
>>
>> --
>>
>> *--*
>> *BR*
>> *Sumit Tyagi*
>> *+91-7829543355*
>>
>
>

-- 

*--*
*BR*
*Sumit Tyagi*
*+91-7829543355*

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jul 01 2015 - 13:06:59 CEST