There are different ways of deleting short dumps from the SNAP table. However, before you delete them, you must analyze the cause of the short dump using transaction code ST22. If the issue related to short dumps is resolved, you can proceed to remove the short dumps before they all filling up the hard disk of your system. Here are the several ways to delete the short dumps:
1. Dump analysis: Reorganization
• Go to transaction code ST22. Choose 'Reorganize'. You can now select all short dumps older than n days for deletion.
CAUTION: 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.
• With the database utility transaction code SE14, you can drop and recreate the SNAP table.
CAUTION: When you do this, ALL short dumps are deleted.
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.
• 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.
4. The SNAP is also automatically reorganized. With each short dump that occurs in the dialog box (the dump is displayed as soon as it occurs), a maximum of 20 short dumps are deleted from the SNAP that are older than 7 days. In normal production operation this reorganization should be sufficient.
No comments:
Post a Comment