Skip to content
MSAMM
Back to the knowledge baseDBA

Tablespace keeps growing after purge programs stopped running

Space consumption climbs steadily and the usual housekeeping appears to be scheduled.

Most likely causes

  • The purge is scheduled but erroring on every run. A failing recurring job can look identical to a healthy one in a schedule list.
  • The retention parameter keeps everything. A purge configured with a long or open-ended retention runs successfully and deletes nothing.
  • Rows are deleted and the segment does not shrink. Deleting rows frees space inside the segment for reuse, not back to the tablespace.
  • The growth is somewhere else entirely. Audit, interface and log tables often grow faster than the transactional ones being purged.

What to check

  • The last several runs of the purge and their completion status — not merely that a schedule exists.
  • The retention parameters actually in use.
  • Which segments are largest and which have grown most, rather than assuming.
  • Whether the growth is in tables, indexes, or undo and temporary space.

If none of the above explains it, raise a ticket and include what you checked. Reading this article cost you no hours.

Still stuck? Raising a ticket costs no hours until you accept a consultant's proposal.

Raise a support ticket