有,
select c.username,c.sid,
a.sql_text from v$sql a,v$open_cursor b,v$session c where c.saddr = b.saddr
and a.address = c.sql_address and c.sql_hash_value = a.hash_value order by c.sid
select c.username,c.sid,
a.sql_text from v$sql a,v$open_cursor b,v$session c where c.saddr = b.saddr
and a.address = c.sql_address and c.sql_hash_value = a.hash_value order by c.sid
各位提到的v$sql ,v$open_cursor 在那里可以看到.????????
where a.sql_address =b.address order by address, piece;