select a. user_name , b.sql_text,c.sid,c.serial#,c.status from v$open_cursor a, v$sqlarea b,v$session c where a.address = b.address and a.sid = c.sid -- and c.status='ACTIVE' order by a. user_name 试一下就知道好处了