Basic Oracle knowledge: How to Determine the redologfile size

Source: Internet
Author: User
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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.