Hello Everybody,

see the time below, for each redo switch from server

MINUTES
----------
13.9
9.95
5.93
5.7
6.17
6.17
5.87
6.17
6.93
7.05
6.35
6.83

The size of each archive is also 1G.

1048574976 Nov 15 07:12 _8431.arc
1048574976 Nov 15 07:29 _8432.arc
1048568832 Nov 15 07:47 _8433.arc
1048574976 Nov 15 08:07 _8434.arc
1048572928 Nov 15 08:23 _8435.arc
1048574976 Nov 15 08:39 _8436.arc
1048574976 Nov 15 08:56 _8437.arc
1048572928 Nov 15 09:14 _8438.arc

My redo log size is 1G. The log block size is 1024 on HP. In my DB log_checkpoint_timeout is set to 86400, but Oracle recommends to set log_checkpont_interval which should be calculated as log block size.

1) I would like to set my checkpoint_interval = (1G*1024*1024*1024)/1024 is that fine?
2) I am thinking to increase the size of redo log size to 2G.

Please suggest me what should I do?


Regards