Hello,
I am using a stored procedure having inserts in 4 tables in my application. There are two Oracle(RAC 12.1) Instances with storage in SAN with archiving enabled. Each Instance has 4 DBWR, 4 ARC and 1 LGWR processes. I have created 5 Redo Log Groups for each instance. In each REDO log Group, there are two redo log files (Each of 1GB, in different ASM disk groups). Archive log destination is also in separate disk group. I observed significant amount of pause in database operations (about 3-4 min) when REDO log file switch happens. ARC processes I/O utilization goes up to 99.99% during that time period. Though there are 4 ARC process but only 2 of them takes I/O utilization. When archiving is done, database operations get normal.
When Database runs in NOARCHIVE mode, every thing goes fine even in case of REDO log file switching. But i know that oracle don't recommends NOARCHIVE mode.
Please suggest me some solution/change which can be implemented to get over this DB operation pause situation in archive mode.
Waiting for your valuable and precious suggestions/comments.