les_07-反应调整 ( 28 ).pptVIP

Reactive Tuning Objectives After completing this lesson, you should be able to do the following: Use Enterprise Manager pages to identify performance issues Eliminate operating system issues Where Is the Problem? Performance issues can be categorized: Operating system (OS) Application Instance OS Issues Operating system issues: Memory CPU I/O (disk and network) Database Home Page OS Statistics and Enterprise Manager OS Statistics Application Issues Application issues can be categorized as: Resource serialization Relational design Session management Cursor management Program design Instance Issues Instance issues are categorized as: Memory SGA PGA I/O Physical I/O Data placement Contention Locks Latches Serialized resources Architecture Performance Management Approach Performance Pages For Reactive Tuning Database Home Page Database Performance Page Active Sessions Waiting Pages SQL Details Historical Data View Diagnosis of Hung or Extremely Slow Databases New functionality for problem analysis when the database is performing very slowly, or is hung: Direct access to SGA for performance monitoring (memory access mode) V$SESSION V$SESSION_WAIT V$SYSTEM_EVENT V$SYSSTAT Hang analysis using Enterprise Manager Also supported for Oracle9i databases Using Memory Access Mode Using the Hang Analysis Page Notes page only Practice Overview: Reactive Tuning This practice covers the following topics: Use Enterprise Manager performance pages to identify or eliminate OS issues Use Enterprise Manager performance pages to identify database performance issues in an application workload Summary In this lesson, you should have learned how to: Use Enterprise Manager pages to identify performance issues Eliminate and identify operating system issues Performance Pages For Reactive Tuning There are cases where real-time problem diagnosis needs to be performed. An irate user calls you, or you see a sudden spike in the activity of the system on the monitor. The Enterprise Manager Perfo