Category Archives: Oracle Performance Tuning

Tuning Oracle with SQLT – Part # 2

Tuning Oracle with SQLT – Part  # 2 Here’s the 2nd part to the series covering SQLT as an important tool for SQL and Oracle Tuning for Oracle DBA’s. In the last post of the series, we covered how to install this … Continue reading

Posted in database, Oracle, Oracle DBA, Oracle Performance Tuning | Tagged , , , , , | Leave a comment

Oracle :: AWR Data Extract

Firstly a small note of Thanks !! Before even starting off this post, I would like to convey my heartiest thanks to Brian Diehl for sharing such a useful piece of information on the Oracle Blog. Introduction The Oracle RDBMS has … Continue reading

Posted in Computers, database, experience, Oracle, Oracle DBA, Oracle Performance Tuning | Tagged , , , , , | Leave a comment

Oracle CBO :: Different Predicates, Same Execution Plan

There are some unfortunate and rare situations which I encounter on few misfortune days of my career, whose investigations lead me to new theories and discoveries. While internet becoming so much information rich these days that it becomes quite easy … Continue reading

Posted in Computers, Oracle, Oracle DBA, Oracle Performance Tuning, programming, scripting, technology | Tagged , , , , , , , | Leave a comment