0 Replies Latest reply: Feb 9, 2011 5:04 AM by VDiez RSS

    DBA_SEGMENTS and DBA_HIST_SEG_STAT understanding

    VDiez
      Hi,

      we have a three nodes RAC 10.2.0.4 and we trying to define a growth (bytes and records) daily checking procedure for certains tables. The confusion arrives when we check the total size for a giving date/time in a table in DBA_SEGMENTS (BYTES) and then comparing to corresponding date/time snap on DBA_HIST_SEG_STAT (SPACE_USED_TOTAL,SPACE_USED_DELTA) for the table (taking in count all instances) and numbers do not match. i.e. Lets say DBA_SEGMENTS says table USERS had 1Gb total size one week ago, when we check for the corresponding snap in the past in DBA_HIST_SEG_STAT and sum all instances values for tables USERS, results dont match, DBA_SEGMENTE always report a lot more size .

      What are we missing here?