V$SEGMENT_STATISTICS definition in Oracle Database 11.2
V$SEGMENT_STATISTICS

select
  owner,                                   -- OWNER VARCHAR2(30)
  object_name,                             -- OBJECT_NAME VARCHAR2(30)
  subobject_name,                          -- SUBOBJECT_NAME VARCHAR2(30)
  tablespace_name,                         -- TABLESPACE_NAME VARCHAR2(30)
  ts#,                                     -- TS# NUMBER
  obj#,                                    -- OBJ# NUMBER
  dataobj#,                                -- DATAOBJ# NUMBER
  object_type,                             -- OBJECT_TYPE VARCHAR2(18)
  statistic_name,                          -- STATISTIC_NAME VARCHAR2(64)
  statistic#,                              -- STATISTIC# NUMBER
  value                                    -- VALUE NUMBER
from
  gv$segment_statistics
where
  inst_id = userenv('instance')

home |  up