User Tools

Site Tools


tuning:oracle_tuning_check_performance

Check the overall and SQL performance of the Oracle Database

Find the performance relevant information inside the database

The most important tool to get information for the runtime behavior of the database is the AWR repository.

The AWR repository is part of each Oracle database since the release 10g, but normally you are not allowed to use these information’s. You need a separate license AND the enterprise edition of the database! And even if you want you cannot buy this license for a standard edition of the database.

So we will go back to the good old statspack, still valid and maintained also for the database version 11g.

You can grep out this information from the data dictionary of the database also with diverse pure SQL scripts, but with statspack you get some more comparable values.

See: Oracle statspack usage

Flow of tuning

If you start with the analyses of all the performance indicators of the Oracle database environment you will find thousands of values.

Therefore we should define us a short flow chart how we should go through all this figures.

 Flow of tuning

"Autor: Gunther Pipperr"
tuning/oracle_tuning_check_performance.txt · Last modified: 2013/03/12 10:24 by gpipperr