Hello all -
I am trying to track the growth of a few problem tables.. if there is a runaway
process, they might continue to write without dying.. I looked at
dba_hist_seg_stat.space_used_delta, it doesn't seem to be consistent in
tracking the growth. Especially for situations like, if the table gets
truncated or if there are massive deletes, this data doesn't accurately
represent reality..
Any suggestions on how it could be tracked?
Worst case I am thinking of dumping the dba_segment data into a table nightly
to track it. Trying to see if there are better ways to handle this.
Thanks
-Upendra
