Resources

This page has links to useful Oracle performance tuning resources.

Github repositories:

Python scripts used for producing graphs that are helpful in Oracle database performance tuning:

https://github.com/bobbydurrett/PythonDBAGraphs

SQL scripts that are helpful in Oracle database performance tuning and other DBA tasks:

https://github.com/bobbydurrett/OracleDatabaseTuningSQL

Scripts:

Package to extract select statements from source database and run them in different scenarios comparing their plans, run time, and resource consumption: zip

Script to show the executions of a given SQL statement over time: zip

Collection of sql tuning scripts I use most often: zip

Papers and presentations:

Delphix User Experience

PowerPoint WebEx recording

Focusing Your Oracle Database Tuning Efforts For PeopleSoft Applications

Powerpoint, Word, Zip

You’re Smarter Than a Database – Overcoming the optimizer’s bad cardinality estimates

Powerpoint, Word, Zip

SQL Tuning Scripts

Powerpoint, Zip

Cardinality Errors Due to Relationships Between Columns

Word

Exadata Distinctives

Powerpoint

Introduction to SQL tuning

PDF, Zip, Powerpoint

– Bobby

 

 

 

 

 

One Response to Resources

  1. Jags S says:

    This is nice website..I am also posted good articles on the site
    http://techgoeasy.com
    if you get time,please do check and comments

Leave a Reply