V$SQLSTATS definition in Oracle Database 11.2
V$SQLSTATS

select
  SQL_TEXT,                                -- SQL_TEXT VARCHAR2(1000)
  SQL_FULLTEXT,                            -- SQL_FULLTEXT CLOB
  SQL_ID,                                  -- SQL_ID VARCHAR2(13)
  LAST_ACTIVE_TIME,                        -- LAST_ACTIVE_TIME DATE
  LAST_ACTIVE_CHILD_ADDRESS,               -- LAST_ACTIVE_CHILD_ADDRESS RAW(8)
  PLAN_HASH_VALUE,                         -- PLAN_HASH_VALUE NUMBER
  PARSE_CALLS,                             -- PARSE_CALLS NUMBER
  DISK_READS,                              -- DISK_READS NUMBER
  DIRECT_WRITES,                           -- DIRECT_WRITES NUMBER
  BUFFER_GETS,                             -- BUFFER_GETS NUMBER
  ROWS_PROCESSED,                          -- ROWS_PROCESSED NUMBER
  SERIALIZABLE_ABORTS,                     -- SERIALIZABLE_ABORTS NUMBER
  FETCHES,                                 -- FETCHES NUMBER
  EXECUTIONS,                              -- EXECUTIONS NUMBER
  END_OF_FETCH_COUNT,                      -- END_OF_FETCH_COUNT NUMBER
  LOADS,                                   -- LOADS NUMBER
  VERSION_COUNT,                           -- VERSION_COUNT NUMBER
  INVALIDATIONS,                           -- INVALIDATIONS NUMBER
  PX_SERVERS_EXECUTIONS,                   -- PX_SERVERS_EXECUTIONS NUMBER
  CPU_TIME,                                -- CPU_TIME NUMBER
  ELAPSED_TIME,                            -- ELAPSED_TIME NUMBER
  AVG_HARD_PARSE_TIME,                     -- AVG_HARD_PARSE_TIME 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
  SORTS,                                   -- SORTS NUMBER
  SHARABLE_MEM,                            -- SHARABLE_MEM NUMBER
  TOTAL_SHARABLE_MEM,                      -- TOTAL_SHARABLE_MEM NUMBER
  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
  EXACT_MATCHING_SIGNATURE,                -- EXACT_MATCHING_SIGNATURE NUMBER
  FORCE_MATCHING_SIGNATURE,                -- FORCE_MATCHING_SIGNATURE NUMBER
  IO_CELL_UNCOMPRESSED_BYTES,              -- IO_CELL_UNCOMPRESSED_BYTES NUMBER
  IO_CELL_OFFLOAD_RETURNED_BYTES           -- IO_CELL_OFFLOAD_RETURNED_BYTES NUMBER
FROM
  gv$sqlstats
where
  inst_id=USERENV('Instance')

home |  up