如何查出前台正在发出的SQL语句

select user_name,sql_text 
from v$open_cursor 
where sid in (select sid from 
(select sid,serial 
from v$session 
where status=''''ACTIVE''''))

SQL> desc v$open_cursor 
 名称                    空?      类型 
 ----------------------------- -------
 SADDR                           RAW(4) 
 SID                             NUMBER 
 USER_NAME                       VARCHAR2(30) 
 ADDRESS                         RAW(4) 
 HASH_VALUE                      NUMBER 
 SQL_TEXT                        VARCHAR2(60)