TAILIEUCHUNG - 9 Automatic Performance Management

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 .

• Cơ sở dữ liệu
• workshop II
• ocp 10g
• oracle
• database
• cơ sở dữ liệu
• công nghệ thông tin
• thiết kế web
• giáo trình photoshop
• kĩ thuật cắt html
• CSS căn bản
• đồ họa máy tính
• thiết kế flash