Oracle PL/SQL Tutorial/System Tables Data Dictionary/open cursor

Join v$open_cursor and v$sqltext

   <source lang="sql">

SQL> SQL> SELECT oc.user_name, s.sql_text

 2  FROM   v$open_cursor oc, v$sqltext s
 3  WHERE  oc.address    = s.address
 4  and    rownum < 2
 5  AND    oc.hash_value = s.hash_value
 6  ORDER BY oc.user_name, s.piece;

USER_NAME

---

SQL_TEXT

---

SYS = :1 and status = "ACTIVE"

SQL></source>