Oracle Database purge time

Last Modified on 01/10/2022 4:12 pm EST

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

Additional Information

How would you rate this article?