Specific process of Oracle Database Optimization in Linux

This article describes how to optimize your Oracle in Linux through 12 procedures.

1. Standard optimization: follow the instructions in the Oracle technical documentation to tune your Linux, such as shared memory. I will not go into details here, because the document is comprehensive.

2. Use Dedicate or MTS-type databases based on your usage. For more information, see the document.

3. If you do not have special requirements for Java applications in the database, do not install it or start it. (If you have installed it)

4. It is best for your server to be dedicated. If you are not dedicated, it means you are not so sensitive to performance and do not need to be optimized.

5. The larger the memory, the better. However, Linux has a limit on the memory size, so you need to find some patches.

6. Download a kernel Patch for SGI's POSIX Asynchronous I/O and Raw I/O. It can greatly increase the access speed of your data files.

7. If you use the ext2 file system, increase the Block size to 4 ~ 8 KB. The size of the partition where dbf is located is at least kb.

8. Try to use a SCSI hard disk. For IDE, adjust the parameters.

9. Here is a sample program:

1 2 Next Page

[Content navigation]
Page 1st: specific process of Oracle Database Optimization in Linux	Page 2nd: specific process of Oracle Database Optimization in Linux