This discussion is archived
0 Replies Latest reply: Feb 9, 2011 3:04 AM by vdiez RSS

DBA_SEGMENTS and DBA_HIST_SEG_STAT understanding

vdiez Newbie
Currently Being Moderated
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?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points