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