select
  SADDR,                                   -- SADDR RAW(8)
  SID,                                     -- SID NUMBER
  USER_NAME,                               -- USER_NAME VARCHAR2(30)
  ADDRESS,                                 -- ADDRESS RAW(8)
  HASH_VALUE,                              -- HASH_VALUE NUMBER
  SQL_ID,                                  -- SQL_ID VARCHAR2(13)
  SQL_TEXT,                                -- SQL_TEXT VARCHAR2(60)
  LAST_SQL_ACTIVE_TIME,                    -- LAST_SQL_ACTIVE_TIME DATE
  SQL_EXEC_ID,                             -- SQL_EXEC_ID NUMBER
  CURSOR_TYPE                              -- CURSOR_TYPE VARCHAR2(64)
from
  GV$OPEN_CURSOR
where
  inst_id = USERENV('Instance')