Segment growth monitoring
From: Upendra nerilla <nupendra_at_hotmail.com>
Date: Wed, 11 Nov 2015 17:13:33 -0500
Message-ID: <BLU181-W19EF1DFB6E9050A4CACB85D8130_at_phx.gbl>
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..
Date: Wed, 11 Nov 2015 17:13:33 -0500
Message-ID: <BLU181-W19EF1DFB6E9050A4CACB85D8130_at_phx.gbl>
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
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Nov 11 2015 - 23:13:33 CET