oracle如何查看后台正在运行着的sql语句

admin Python 2023-02-27 941浏览 0

select a.program,b.spid,c.sql_text from v$session a,v$process b,v$sqlarea c where a.paddr=b.addr and a.sql_hash_value=c.hash_value and a.username is not null;