Oracle instance Performance Analysis and Optimization-AWR learning summary, oracleawr

Oracle instance Performance Analysis and Optimization-AWR learning summary, oracleawr
Summary

Sunan Health Blog's article ORACLE performance optimization includes instance performance optimization and SQL statement performance optimization. They interact with each other and affect each other. If the instance has performance problems, no matter whether the SQL statements are well written, ORACLE cannot run at high speed. The performance of SQL statements is optimized. Our company has a lot of information for reference. This time I briefly summarized the analysis and optimization of ORACLE instances.

Automatic Workload Repository is a tool provided by Oracle that automatically collects, processes, and maintains performance-related statistics. It compares the statistical information collected by two snapshots to generate report data. Through AWR and AWR reports, DBAs can easily learn the activity status of the latest database, the change trend curves of various database performance indicators, and possible exceptions in the recent database, analyze potential performance bottlenecks of the database to optimize the database.

Document directory

1. Summary 2

1.1 performance optimization Overview 2

2. Automatic workload Library (AWR) 3

2.1 Summary 3

2.2 enable AWR 3

2.3 SNAPSHOT (SNAPSHOT) 3

2.4 generate AWR report 4

3. Generate AWR Step 5

3.1 SQL File 5

3.2 generate AWR report 5

4. Performance Analysis 8

4.1 db time 8

4.2 Cache size (Cache Sizes) 8

4.3 Load Profile 9

4.4 database Efficiency (Instance Efficiency Percentages) 9

4.5 Shared Pool Statistics (Shared Pool Statistics) 10

4.6 Top 5 Events (Top 5 Timed Events) 11

4.7 SQL Statistics (SQL Statistics) 12

Document address

Http://wenku.baidu.com/view/b9bbf0cbe518964bcf847ce5