SELECT * FROM v$open_cursor;

SADDR    SID        USER_NAME                      ADDRESS  HASH_VALUE SQL_TEXT                                                    
-------- ---------- ------------------------------ -------- ---------- ------------------------------------------------------------
03CA34F0          9 SYSTEM                         04A83C70 3111621964 select * from v$open_cursor