Oracle Database and application optimization

Source: Internet
Author: User
Tags file size one table rollback oracle database

Absrtact: In this paper, Oracle database and Oracle Application optimization, a comprehensive analysis and research, and put forward some of their own suggestions.

1. Introduction

With the advent of the information age, people began to use the database technology widely to carry on the scientific and efficient management to the massive and complex information. Various applications in the database field have sprung up, with visual Foxpro,power Builder and so on, but Oracle is one of the best and most popular large database applications in the field. In this paper, we study how to optimize the database and its application program in Oracal.

2. Optimizing the Database

2.1 Optimization Settings control the number of files, location and backup

It is recommended that Control_file initialization parameters specify that multiple files should be greater than 2 and that the control files be mirrored to different locations and that the control files be backed up to a secure disk.

2.2 Optimize the design of the table space, data file size and location

2.2.1 Design Table Space

Try to spread the disk's read and write operations at the same time. If the data in one table is updated, the database will read both the data in the table and the index information on the table, and the database will slow down if both the data and index information of the table are placed in the same data file. It is best to put the data information and index information in the two data files of different disks, when the reading and writing of the database to the disk will be dispersed on two disks, the speed will be significantly improved. Therefore, when you design the table space and data files for your database, you first create two tablespaces of table and table indexes, which hold the data table space of the user's data and the index table space that holds the table index. In addition, according to the size of the system data and the nature of the data in the system, we consider creating several data table spaces or adding several data files to the data table space.

Size of the 2.2.2 design data file

Put the record size of the table in the same table space, when a table space storage parameter settings, you can ensure that the records in the table are placed in a range, to avoid a record across the range of storage, you can obviously database performance.

2.2.3 the location of the design data file

To avoid conflicts with disk I/O operations, you should create a data file in a different location.

2.3 Optimization Design Replay log files

2.3.1 Replay the size of the log file

Since databases are recycled using replay log files, and when the LGWR process switches in two log files, a checkpoint is automatically generated, so the size of the replay log file directly affects the frequency at which the detection point appears. And because in the database checkpoint, to the user, the speed of the database will be affected, so the frequency of detection points, or detection points just appear in the database processing data peak, will greatly affect the performance of the database. Therefore, the replay log file size design, should consider the frequency of detection points and detection points should avoid the peak of database processing data.

2.3.2 Replay number of log file groups

In Archivelog mode, it is possible to reduce the frequency of database archive log files by appropriately increasing the number of replay log file groups.

2.3.3 Replay archive of log files

The archive of the replay log file should be set on the physical device where the disk reads and writes faster. This reduces the archive time for log files.

Optimization design of 2.4 Rolling back section

The design of the number of 2.4.1 rollback segment

To consider the number of concurrent transactions that the database needs to support, because each rollback segment has the maximum number of transactions it can support, and if the number of rollback segments is not large enough, some new transactions are forced to wait, affecting the performance of the database.

Related Article

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.