Overview of Oracle9i Database Performance Tuning

一、 Reference Books
     a. Performance TUNING Guide(B28274-01)
     b. Troubleshoot Oracle Performance
     c. Expert one-on-one ORACLE
     
二、 TUNING 范围
     1. APPLICATION:
          SQL statement performance
          Change management         
     2. Instance tuning:
          Memory
          Database Structure
          Instance Configuration
     3. OS Interactions
        I/O
        SWAP
        PARAMETERS
       
三、 TUNING 阶段
     1. Application Design
        (Tune the design
           Tune the application
           Tune memory
           Tune I/O
           Tune contention
           Tune os
          )
     2. Database Configuration
        (Define the problem
         Examine the OS and ORACLE statistics
         Consider common performance errors
         Build a conceptual model
         Implement and measure the change
         Check the bottleneck has been resolved
         )
     3. Adding a new application to an existing database
     4. Troubleshooting and TUNING   
    
四、 TUNING 目标
     1. Minimizing response time
     2. Increasing throughput
     3. Increasing load capabilities
     4. Decreasing recovery time
   
五、 TUNING Problems
     1. Bad session management
     2. Bad cursor management
     3. Bad relational design
    
六、 TUNING METHODOLOGY
     1. Check alert log and trace files
     2. Check parameter
     3. Check memory, I/O , CPU, PROCESS
     4. Identify and tune SQL statements
    
参考连接：http://www.boo booke.com/bbs/viewthread.php?tid=7630&extra=page%3D1