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
Recent Comments