Oracle 9i DBA -- Oracle9i Database: Performance Tuning (1Z0-033)

Oracle 9i DBA 認證考試 -- Oracle9i Database: Performance Tuning (1Z0-033)

這門考試是考OCP證照的最後ㄧ門考試，這們考試可以是難也可以是簡單，簡單的是內容不多，難的是相關考試資源沒有其他3門考試要來的多。隨後幾篇是當初準備考試的筆記，供大家參考；以下是此門考試的內容 :

• Overview of Oracle9i Performance Tuning
• Diagnostic and Tuning Tools
• Sizing the Shared Pool
• Sizing the Buffer Cache
• Sizing Other SGA Structures
• Database Configuration and I/O Issues
• Optimize Sort Operations
• Diagnosing Contention for Latches
• Tuning Rollback (UNDO) Segments
• Monitoring and Detecting Lock Contention
• Application Tuning
• Tuning Oracle Shared Server
• Using Oracle Blocks Efficiently
• SQL Statement Tuning
• Tuning Operating System and Using Resource Manager
• Other