OCP043 Chapter 9 Automatic Performance Management

 

The content of this lecture includes:

1: Diagnose database performance

2: configure the automatic workload file library

3: Use a database Consultant

4: use SQL access advisor to improve database performance

5. asynchronous submission

About the first 4 points, has been introduced in the previous notes, here will not go into detail, For details, please refer to: http://ylw6006.blog.51cto.com/470441/623614

Asynchronous Submission mechanism:

When the commit command is entered, the information in the redo log buffer is written to the redo log file. When the Commit complete is returned, the table name log information is written successfully. To improve performance, asynchronous Submission mechanism can be adopted

 

This article is from the "yueda tianchong" blog