select
  SQL_TEXT,                                -- SQL_TEXT VARCHAR2(1000)
  SQL_FULLTEXT,                            -- SQL_FULLTEXT CLOB
  SQL_ID,                                  -- SQL_ID VARCHAR2(13)
  SHARABLE_MEM,                            -- SHARABLE_MEM NUMBER
  PERSISTENT_MEM,                          -- PERSISTENT_MEM NUMBER
  RUNTIME_MEM,                             -- RUNTIME_MEM NUMBER
  SORTS,                                   -- SORTS NUMBER
  LOADED_VERSIONS,                         -- LOADED_VERSIONS NUMBER
  OPEN_VERSIONS,                           -- OPEN_VERSIONS NUMBER
  USERS_OPENING,                           -- USERS_OPENING NUMBER
  FETCHES,                                 -- FETCHES NUMBER
  EXECUTIONS,                              -- EXECUTIONS NUMBER
  PX_SERVERS_EXECUTIONS,                   -- PX_SERVERS_EXECUTIONS NUMBER
  END_OF_FETCH_COUNT,                      -- END_OF_FETCH_COUNT NUMBER
  USERS_EXECUTING,                         -- USERS_EXECUTING NUMBER
  LOADS,                                   -- LOADS NUMBER
  FIRST_LOAD_TIME,                         -- FIRST_LOAD_TIME VARCHAR2(19)
  INVALIDATIONS,                           -- INVALIDATIONS NUMBER
  PARSE_CALLS,                             -- PARSE_CALLS NUMBER
  DISK_READS,                              -- DISK_READS NUMBER
  DIRECT_WRITES,                           -- DIRECT_WRITES NUMBER
  BUFFER_GETS,                             -- BUFFER_GETS 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
  ROWS_PROCESSED,                          -- ROWS_PROCESSED NUMBER
  COMMAND_TYPE,                            -- COMMAND_TYPE NUMBER
  OPTIMIZER_MODE,                          -- OPTIMIZER_MODE VARCHAR2(10)
  OPTIMIZER_COST,                          -- OPTIMIZER_COST NUMBER
  OPTIMIZER_ENV,                           -- OPTIMIZER_ENV RAW(2000)
  OPTIMIZER_ENV_HASH_VALUE,                -- OPTIMIZER_ENV_HASH_VALUE NUMBER
  PARSING_USER_ID,                         -- PARSING_USER_ID NUMBER
  PARSING_SCHEMA_ID,                       -- PARSING_SCHEMA_ID NUMBER
  PARSING_SCHEMA_NAME,                     -- PARSING_SCHEMA_NAME VARCHAR2(30)
  KEPT_VERSIONS,                           -- KEPT_VERSIONS NUMBER
  ADDRESS,                                 -- ADDRESS RAW(8)
  TYPE_CHK_HEAP,                           -- TYPE_CHK_HEAP RAW(8)
  HASH_VALUE,                              -- HASH_VALUE NUMBER
  OLD_HASH_VALUE,                          -- OLD_HASH_VALUE NUMBER
  PLAN_HASH_VALUE,                         -- PLAN_HASH_VALUE NUMBER
  CHILD_NUMBER,                            -- CHILD_NUMBER NUMBER
  SERVICE,                                 -- SERVICE VARCHAR2(64)
  SERVICE_HASH,                            -- SERVICE_HASH NUMBER
  MODULE,                                  -- MODULE VARCHAR2(64)
  MODULE_HASH,                             -- MODULE_HASH NUMBER
  ACTION,                                  -- ACTION VARCHAR2(64)
  ACTION_HASH,                             -- ACTION_HASH NUMBER
  SERIALIZABLE_ABORTS,                     -- SERIALIZABLE_ABORTS NUMBER
  OUTLINE_CATEGORY,                        -- OUTLINE_CATEGORY VARCHAR2(64)
  CPU_TIME,                                -- CPU_TIME NUMBER
  ELAPSED_TIME,                            -- ELAPSED_TIME NUMBER
  OUTLINE_SID,                             -- OUTLINE_SID NUMBER
  CHILD_ADDRESS,                           -- CHILD_ADDRESS RAW(8)
  SQLTYPE,                                 -- SQLTYPE NUMBER
  REMOTE,                                  -- REMOTE VARCHAR2(1)
  OBJECT_STATUS,                           -- OBJECT_STATUS VARCHAR2(19)
  LITERAL_HASH_VALUE,                      -- LITERAL_HASH_VALUE NUMBER
  LAST_LOAD_TIME,                          -- LAST_LOAD_TIME VARCHAR2(19)
  IS_OBSOLETE,                             -- IS_OBSOLETE VARCHAR2(1)
  IS_BIND_SENSITIVE,                       -- IS_BIND_SENSITIVE VARCHAR2(1)
  IS_BIND_AWARE,                           -- IS_BIND_AWARE VARCHAR2(1)
  IS_SHAREABLE,                            -- IS_SHAREABLE VARCHAR2(1)
  CHILD_LATCH,                             -- CHILD_LATCH NUMBER
  SQL_PROFILE,                             -- SQL_PROFILE VARCHAR2(64)
  SQL_PATCH,                               -- SQL_PATCH VARCHAR2(30)
  SQL_PLAN_BASELINE,                       -- SQL_PLAN_BASELINE VARCHAR2(30)
  PROGRAM_ID,                              -- PROGRAM_ID NUMBER
  PROGRAM_LINE#,                           -- PROGRAM_LINE# NUMBER
  EXACT_MATCHING_SIGNATURE,                -- EXACT_MATCHING_SIGNATURE NUMBER
  FORCE_MATCHING_SIGNATURE,                -- FORCE_MATCHING_SIGNATURE NUMBER
  LAST_ACTIVE_TIME,                        -- LAST_ACTIVE_TIME DATE
  BIND_DATA,                               -- BIND_DATA RAW(2000)
  TYPECHECK_MEM,                           -- TYPECHECK_MEM NUMBER
  IO_CELL_OFFLOAD_ELIGIBLE_BYTES,          -- IO_CELL_OFFLOAD_ELIGIBLE_BYTES 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
  OPTIMIZED_PHY_READ_REQUESTS,             -- OPTIMIZED_PHY_READ_REQUESTS NUMBER
  LOCKED_TOTAL,                            -- LOCKED_TOTAL NUMBER
  PINNED_TOTAL,                            -- PINNED_TOTAL NUMBER
  IO_CELL_UNCOMPRESSED_BYTES,              -- IO_CELL_UNCOMPRESSED_BYTES NUMBER
  IO_CELL_OFFLOAD_RETURNED_BYTES           -- IO_CELL_OFFLOAD_RETURNED_BYTES NUMBER
from
  GV$SQL
where
  inst_id = USERENV('Instance')