Select 'ALTER TABLE '||TABLE_NAME||' SHRINK SPACE ' from user_tables where tablespace_name='ST_DATA' Select 'ALTER TABLE '||TABLE_NAME||' ENABLE ROW MOVEMENT ' from user_tables where tablespace_name='ST_DATA'
non-partitioned tables for which there are no Maintenance applications provided by SecureTransport and are not supposed to grow much.įor the first two Axway SecureTransport has the option to store them in separate schemas/databases and also has Maintenance applications which if configured can remove old partitions to automatically free the space occupied by historic table data.įor the non-partitioned tables a manual approach may be needed.įor old ST installation where LOBs are of BASICFILE type it may be enough to make a script with the output of the following queries and execute it:. There are three main ST consumers of space: This is due to the way Oracle manages LOBs and stores their undo data. However since Oracle changed the default LOB type to SecureFile in version 12c some customers began to observe what is considered an unexpected database growth. 
SecureTransport provides some functionalities towards reducing tables size.
Frequently, during high season, the database reaches the point when all the storage is consumed which is not needed for normal operation during low season and the database size have to be manually decreased. Databases, even when configured and used properly, grow over time.
0 kommentar(er)
