select
  KEY,                                     -- KEY NUMBER
  STATUS,                                  -- STATUS VARCHAR2(19)
  USER#,                                   -- USER# NUMBER
  USERNAME,                                -- USERNAME VARCHAR2(30)
  MODULE,                                  -- MODULE VARCHAR2(48)
  ACTION,                                  -- ACTION VARCHAR2(32)
  SERVICE_NAME,                            -- SERVICE_NAME VARCHAR2(64)
  CLIENT_IDENTIFIER,                       -- CLIENT_IDENTIFIER VARCHAR2(64)
  CLIENT_INFO,                             -- CLIENT_INFO VARCHAR2(64)
  PROGRAM,                                 -- PROGRAM VARCHAR2(64)
  PLSQL_ENTRY_OBJECT_ID,                   -- PLSQL_ENTRY_OBJECT_ID NUMBER
  PLSQL_ENTRY_SUBPROGRAM_ID,               -- PLSQL_ENTRY_SUBPROGRAM_ID NUMBER
  PLSQL_OBJECT_ID,                         -- PLSQL_OBJECT_ID NUMBER
  PLSQL_SUBPROGRAM_ID,                     -- PLSQL_SUBPROGRAM_ID NUMBER
  FIRST_REFRESH_TIME,                      -- FIRST_REFRESH_TIME DATE
  LAST_REFRESH_TIME,                       -- LAST_REFRESH_TIME DATE
  REFRESH_COUNT,                           -- REFRESH_COUNT NUMBER
  SID,                                     -- SID NUMBER
  PROCESS_NAME,                            -- PROCESS_NAME VARCHAR2(5)
  SQL_ID,                                  -- SQL_ID VARCHAR2(13)
  SQL_TEXT,                                -- SQL_TEXT VARCHAR2(2000)
  IS_FULL_SQLTEXT,                         -- IS_FULL_SQLTEXT VARCHAR2(1)
  SQL_EXEC_START,                          -- SQL_EXEC_START DATE
  SQL_EXEC_ID,                             -- SQL_EXEC_ID NUMBER
  SQL_PLAN_HASH_VALUE,                     -- SQL_PLAN_HASH_VALUE NUMBER
  EXACT_MATCHING_SIGNATURE,                -- EXACT_MATCHING_SIGNATURE NUMBER
  FORCE_MATCHING_SIGNATURE,                -- FORCE_MATCHING_SIGNATURE NUMBER
  SQL_CHILD_ADDRESS,                       -- SQL_CHILD_ADDRESS RAW(8)
  SESSION_SERIAL#,                         -- SESSION_SERIAL# NUMBER
  PX_IS_CROSS_INSTANCE,                    -- PX_IS_CROSS_INSTANCE VARCHAR2(1)
  PX_MAXDOP,                               -- PX_MAXDOP NUMBER
  PX_MAXDOP_INSTANCES,                     -- PX_MAXDOP_INSTANCES NUMBER
  PX_SERVERS_REQUESTED,                    -- PX_SERVERS_REQUESTED NUMBER
  PX_SERVERS_ALLOCATED,                    -- PX_SERVERS_ALLOCATED NUMBER
  PX_SERVER#,                              -- PX_SERVER# NUMBER
  PX_SERVER_GROUP,                         -- PX_SERVER_GROUP NUMBER
  PX_SERVER_SET,                           -- PX_SERVER_SET NUMBER
  PX_QCINST_ID,                            -- PX_QCINST_ID NUMBER
  PX_QCSID,                                -- PX_QCSID NUMBER
  ERROR_NUMBER,                            -- ERROR_NUMBER VARCHAR2(40)
  ERROR_FACILITY,                          -- ERROR_FACILITY VARCHAR2(4)
  ERROR_MESSAGE,                           -- ERROR_MESSAGE VARCHAR2(256)
  BINDS_XML,                               -- BINDS_XML CLOB
  OTHER_XML,                               -- OTHER_XML CLOB
  ELAPSED_TIME,                            -- ELAPSED_TIME NUMBER
  QUEUING_TIME,                            -- QUEUING_TIME NUMBER
  CPU_TIME,                                -- CPU_TIME NUMBER
  FETCHES,                                 -- FETCHES NUMBER
  BUFFER_GETS,                             -- BUFFER_GETS NUMBER
  PHYSICAL_READ_REQUESTS,                  -- DISK_READS NUMBER
  PHYSICAL_WRITE_REQUESTS,                 -- DIRECT_WRITES NUMBER
  IO_INTERCONNECT_BYTES,                   -- IO_INTERCONNECT_BYTES NUMBER
  PHYSICAL_READ_REQUESTS,                  -- PHYSICAL_READ_REQUESTS NUMBER
  PHYSICAL_READ_BYTES,                     -- PHYSICAL_READ_BYTES NUMBER
  PHYSICAL_WRITE_REQUESTS,                 -- PHYSICAL_WRITE_REQUESTS NUMBER
  PHYSICAL_WRITE_BYTES,                    -- PHYSICAL_WRITE_BYTES NUMBER
  APPLICATION_WAIT_TIME,                   -- APPLICATION_WAIT_TIME NUMBER
  CONCURRENCY_WAIT_TIME,                   -- CONCURRENCY_WAIT_TIME NUMBER
  CLUSTER_WAIT_TIME,                       -- CLUSTER_WAIT_TIME NUMBER
  USER_IO_WAIT_TIME,                       -- USER_IO_WAIT_TIME NUMBER
  PLSQL_EXEC_TIME,                         -- PLSQL_EXEC_TIME NUMBER
  JAVA_EXEC_TIME                           -- JAVA_EXEC_TIME NUMBER
from
  GV$SQL_MONITOR
where
  inst_id=USERENV('Instance')