Oracle Database Performance Tuning.

INTRODUCTION:

                               Dear readers, Tuning performance of Oracle Database includes variety of component aspects to keep in mind. Because at every component level we need to do performance tuning, and component corresponds to Table, OS, Database, Index, Many other physical and logical components of Database. So to summarize and to make systematic understanding of how we can do performance tuning of Oracle Database is categorized in below sub-topics based on sub-components of Database. In below sub-topics, in brackets it is mentioned to whom it is helpful. Some topics are of interest to Developers and all of them are capability that Professional DBA should possess.

1. Optimizing Table Performance.  (Developer/DBA)
2. Choosing and Optimizing Indexes. (Developer/DBA)
3. Optimizing Instance Memory. (DBA)
4. Monitoring System performance.(DBA)
5. Minimizing System Contention.(DBA)
6. Analyzing Operating System performance.(DBA)
7. Troubleshooting Database. (DBA)
8. Creating Efficient SQL.(Developer/DBA)
9. Manually Tuning SQL.(Developer/DBA)
10. Tracing SQL Execution.(Developer/DBA)
11. Automated SQL Tuning. (Developer/DBA)
12. Execution Plan Optimization and Consistency. (Developer/DBA)
13. Configuring the Optimizer. (DBA)
14. Implementing Query Hints. (DBA)
15. Executing SQL in Parallel. (Developer/DBA)

       Let us dig into each of the above mentioned sub-topics in order to gain knowledge on how we can address performance related issues in those particular section with real world example.