My Oracle Support Banner

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

Last updated on AUGUST 10, 2018

Applies to:

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

Goal

On ASAP 7.3.0.0.0 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.

TABLESPACE_NAME SEGMENT_NAME MB
------------------------------ -------------------------------------- ----------
ASAPDATA_ASM5 TBL_SRQ_LOG 63535

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?
 

Solution

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

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


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