oracle如何查询后台正在运行的SQL和SQL的实时变量值

wifox

 

 

查询后台正在运行的sql

Select osuser, username, sql_text,b.* from v$session a, v$sqltext b
where a.sql_address =b.address
and a.sid='2830'
order by address, piece;

 

 

 

查询后台正在运行sql对应的变量

Select * from v$session a, v$sqltext b ,v$sql_bind_capture c
where a.sql_address =b.address
and b.sql_id=c.sql_id
and a.sid='2830'