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