11GR2: Frequent log switches
Hi,
We have a EBS R12.1.3 implementation which is running on 11.2.0.3 database. We have 3 redolog groups of 1G each. However, we are seeing very frequent log switches. How can we control this situation. Here is the example of log switch happening.
TO_CHAR(COMPLETION_TIME,'DD (BLOCKS*BLOCK_SIZE)/(1024*1024)
--------------------------- -------------------------------
13-NOV-14:04:30:27 .000488281
13-NOV-14:05:00:07 16.0058594
13-NOV-14:05:00:08 1.21435547
13-NOV-14:05:00:11 1.86914063
13-NOV-14:05:00:12 .816894531
13-NOV-14:05:00:14 .640136719
13-NOV-14:05:00:29 9.41650391
13-NOV-14:05:00:30 .473632813
13-NOV-14:05:00:31 .574707031
13-NOV-14:05:00:32 .384277344
13-NOV-14:05:00:33 .736816406
13-NOV-14:05:30:04 26.581543
13-NOV-14:05:30:05 .000488281
13-NOV-14:05:30:06 .016601563
13-NOV-14:05:30:07 .000488281
13-NOV-14:05:30:08 .000488281
13-NOV-14:05:30:22 .112304688
13-NOV-14:05:30:22 .000488281
13-NOV-14:05:30:23 .013671875
13-NOV-14:05:30:24 .000488281
13-NOV-14:05:30:25 .001464844
13-NOV-14:06:00:05 77.2119141
13-NOV-14:06:00:05 .007324219
13-NOV-14:06:00:06 .024902344
13-NOV-14:06:00:08 .016113281
13-NOV-14:06:00:10 .032714844
13-NOV-14:06:00:26 2.13085938
13-NOV-14:06:00:27 .021972656
13-NOV-14:06:00:28 .025878906
13-NOV-14:06:00:31 .037109375
13-NOV-14:06:00:34 .037109375
13-NOV-14:06:30:05 .000488281
13-NOV-14:06:30:06 587.519531
this happens through out the day
--------------------------- -------------------------------
13-NOV-14:16:30:06 196.556641
13-NOV-14:16:30:06 9.43701172
13-NOV-14:16:30:11 27.9545898
13-NOV-14:16:30:13 .019042969
13-NOV-14:16:30:17 .079589844
13-NOV-14:16:30:38 .28125
13-NOV-14:16:30:38 .002929688
13-NOV-14:16:30:40 .022460938