播布客视频-Performance Tuning笔记(一)Overview

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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/9252210/viewspace-627222/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/9252210/viewspace-627222/