Category Diverse

Large Volume Data Delete and Insert approach

by Snehashish Ghosh

 Scenario


During Delete or Insert of Large volume of data huge amount of archive log get generated filling up the archive log destination area.
Also large amount of undo records fill up the undo tablespace.
So how should we plan a large volume of data delete or insert in database. Data Volume >20GB can follow this approach.

Solution


1. Increase the DATA tablespace size in case of insert
2. Increase the size of undo tablespace proportional to the amount of data to be deleted or inserted
3. Move the database to noarchivelog mode

Read More