Delete Short Dumps

Delete Short Dumps

Method 1 : Dump analysis: Reorganization
• Go to transaction code ST22. Choose ‘Reorganize‘. You can now select all
short dumps older than n days for deletion.
Warning: If a large amount of records are deleted simultaneously during the
reorganization, ORACLE error ora1562 ‘failed to extend rollback segment …’
may occur. In this case, refer to error Note 6328.


Method 2 :  Drop and recreate the SNAP table
• With the database utility transaction code SE14, you can drop and
recreate the SNAP table.
Warning: When you do this, ALL short dumps are deleted.


Method 3 : Reorganization program RSSNAPDL
• To avoid database problems, this program deletes old short dumps
gradually from the SNAP table unless they are selected for retention. With
standard setting all short dumps that are older than 7 days and that are
not flagged are deleted. Since this program occupies the database when
large datasets are processed, it should be scheduled to run overnight.
Execute RSSNAPDL in transaction SE38