Symptom
Oracle databases take a long time to purge records.
Resolution
This is due to the number of commits, but certain settings can be modified by an Oracle DBA.
Commit behavior:
alter system set commit_logging='IMMEDIATE' scope=spfile;alter system set commit_wait='NOWAIT' scope=spfile;
Memory increase:
alter system set sga_max_size=5000M scope=spfile;alter system set sga_target=2500M scope=spfile;
Applies To
OnGuard (All versions); Oracle 11g
