Retrieve values of bind variables

Tuning de Banco, Tuning de SQL, Ferramentas de tuning
  

Poston Tue, 26 Apr 2016 6:10 pm

Good Afternoon Folks.

I'm trying to optimize some queries and must obtain the values that the application passed to the binds variables of a given query. You can obtain these values?

I thank you.
dejambo

Poston Fri, 06 May 2016 11:04 am

Good morning, I'm not a DBA, but you can try on v $ sqlarea.

Select * from v $ sqlarea;

It stores the queries for a while.
spernega
Location: São Paulo - SP

Poston Tue, 10 May 2016 1:08 pm

You can use this query:
Code: Select all
select a.*
    From V$SQL_BIND_CAPTURE A
    where A.sql_id in (select sql_id from v$session where sid= 110 ); 
just pass the's SQL_ID. (In the case above, I'm getting the session's SQL_ID 110).
dr_gori
Location: Seattle, WA, USA

Thomas F. G



Return to DBA Tuning

Who is online

Users browsing this forum: No registered users and 2 guests