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

Assembly language programming exercises:

https://github.com/bobbydurrett/Assembly

Miscellaneous Python scripts from some classes that I am taking:

https://github.com/bobbydurrett/miscpython

Python script to copy a file up to an Office 365 SharePoint site:

https://github.com/bobbydurrett/copyfiletosharepoint

MySQL scripts:

https://github.com/bobbydurrett/MySQL-Scripts

Misc:

Misc code on Rosetta Code: url

Stack Overflow: url

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

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.