My Oracle Support Banner

PurgeOrders Doesn't Seem to Reduce Table Segment Even After Data Is Purged (Doc ID 2429053.1)

Last updated on MAY 23, 2022

Applies to:

Oracle Communications ASAP - Version and later
Information in this document applies to any platform.


On ASAP version:

We are currently using purgeOrders script to purge SARM DB with DB_PURGE_DAYS=3. The records that are relevant to the WOs in tbl_wrk_ord are deleted but the segment size corresponding to table still remains same.

------------------------------ -------------------------------------- ----------

We have done some investigation and noticed that "Deleting data isn't expected to change the size of the table segment. It will create free space in blocks that are part of the table segment and it will likely create at least a few empty blocks"

Is this the expected behavior? Will the empty blocks in segment be reused if new data is inserted? Also is there any way to decrease the corresponding segment size if we purge the data from SARM DB?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.