After completing this lesson, you should be able to: • Diagnose database performance issues • Configure the Automatic Workload Repository • Access the database advisors • Use the SQL Access Advisor to improve database performance • Use asynchronous COMMIT effectively | Automatic Performance Management Oracle Database 10g: Administration Workshop II 9- Objectives After completing this lesson, you should be able to: Diagnose database performance issues Configure the Automatic Workload Repository Access the database advisors Use the SQL Access Advisor to improve database performance Use asynchronous COMMIT effectively Tuning Statistics SGA Attach AWR Advisors Async. Commit Oracle Database 10g: Administration Workshop II 9- Tuning Activities The three activities in performance management are: Performance planning Instance tuning SQL tuning Tuning Activities The three facets of tuning involve performance planning, instance tuning, and SQL tuning. Performance planning is the process of establishing the environment: the hardware, software, operating system, network infrastructure, and so on. Instance tuning is the actual adjustment of Oracle database parameters and operating system parameters to gain better performance of the Oracle database. SQL . | Automatic Performance Management Oracle Database 10g: Administration Workshop II 9- Objectives After completing this lesson, you should be able to: Diagnose database performance issues Configure the Automatic Workload Repository Access the database advisors Use the SQL Access Advisor to improve database performance Use asynchronous COMMIT effectively Tuning Statistics SGA Attach AWR Advisors Async. Commit Oracle Database 10g: Administration Workshop II 9- Tuning Activities The three activities in performance management are: Performance planning Instance tuning SQL tuning Tuning Activities The three facets of tuning involve performance planning, instance tuning, and SQL tuning. Performance planning is the process of establishing the environment: the hardware, software, operating system, network infrastructure, and so on. Instance tuning is the actual adjustment of Oracle database parameters and operating system parameters to gain better performance of the Oracle database. SQL tuning involves making your application submit efficient SQL. This is an applicationwide, as well as a statement-specific, consideration. Systemwide, you want to be sure that different parts of the application are taking advantage of each other’s work and are not competing for resources unnecessarily. In this lesson, you learn about some common actions that you can take to tune specific SQL statements. Note: For more information about performance tuning, refer to the Oracle Database Performance Tuning Guide. Oracle Database 10g: Administration Workshop II 9- Performance Planning Investment options System architecture Scalability Application design principles Workload testing, modeling, and implementation Deploying new applications Performance Planning There are many facets to performance planning. You have to consider the investment in your system architecture: the hardware and software infrastructure needed to meet your requirements. The number of hard drives and controllers has an
