The default redologfile size of Oracle10g is 50 MB. in use, it is often found that there are a large number of Checkpointnotcomplete problems in alterlog.
The default redo log file size of Oracle10g is 50 MB. in use, it is often found that there are a large number of Checkpoint not complete problems in alter log.
The default redo log file size of Oracle10g is 50 MB. in use, it is often found that there are a large number of Checkpoint not complete problems in alter log.
We should all know what this problem is. To solve this problem, we only need to increase the redo log file size, but how much is appropriate? In fact, the estimation method is very simple, 10 Gb can use awr (9i uses statspack) to generate a report for a stable running cycle, the specific cycle depends on the database usage.
Load Profile Per Second Per Transaction Redo size: 173,302.31 470,896.98
Based on the data provided in the report, the redo size is 173 k per second, and the recommendation for redo log is generally to switch between 2-3 times per hour. The following example uses a 20-minute switch, the size of the redo log file should be set to redo size x 60x20, that is, 173 k x 60x20. Therefore, the size of the redo log file should be set to 208 m, if you have enough space, you can set up richer ones. Of course, 10 Gbit/s can be used to automatically complete the above diagnostic steps. However, not every time ADDM can diagnose all problems (maybe I cannot use them ), it seems that awr reports are easier to find problems.
Another solution: to set the redolog file, ensure that the information of logswitch. logswitch is recorded in alertSID. log within 30 minutes. If the two switches take 10 minutes, you need to increase the size of the redolog file to three times. If the two switches take 15 minutes, you need to increase the size of the redolog file to twice. If the two switches take more than 30 minutes, you do not need to increase the size of the redo log file.