bigdatalyn / oracledatabasetuningsql Goto Github PK

# OracleDatabaseTuningSQL

These are the SQL scripts that Bobby Durrett uses for Oracle
database performance tuning.

These scripts are designed to be run through Oracle's sqlplus utility.

So, if you have a script called example.sql you would run it like this in
sqlplus:

sqlplus myuser/mypassword@mydatabase < example.sql

Directories:

ash                      - Active Session History related

awr                      - Automatic Workload Repository related

force_matching_signature - Queries that use force_matching_signature

misc                     - Queries that don't fall into another category

optimizerstatistics      - Values that the optimizer uses

perfprofile              - Performance profiles from V$ tables

plan                     - Scripts to show a query plan

refresh                  - Refresh tables using export and import

resourcemanager          - Resource manager queries

spaceproddbs             - Space and related queries

testselectpackage        - Package to extract and test select statements

v$                       - Scripts that use the v$ views

- Bobby Durrett

http://www.bobbydurrettdba.com/