播布客視訊-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/，如需轉載，請註明出處，否則將追究法律責任。