Oracle__运行中的SQL

[size=large]运行中的SQL[/size]

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;

[size=large]SQL占用资源[/size]