Home

Oracle Performance Doctor is a tool which helps you to understand the behavior of your application on Oracle database level.
The tool does:

1. Extract execution plan for all SQL’s executed by specified db user and print it to file on server side.
2. For all executed SQL statements the tool will provide more performance version of sql text by using built-in module dbms_sqltune.
   Typical usage scenario:

Pre-requirements:

1. You have an application which uses Oracle database (10.2 and above).
2. You know database user schema name, used by your application
3. You also know database SYS or SYSTEM credentials.
4. You want to know how efficient your application on database level, is all indexes are used, is any long running statement, etc…

Execute Oracle Performance Doctor

1. Run your application for a while by running load tests or simple use your application for couple of hours, ideally execute all functions in it.
2. Execute Oracle Performance Doctor on database. Choose PLAN or TUNE option.

Result Analyses

1. Check all execution plans in final report. Here you can find some “suspicions” plans, requires deeper analysis. For example: sql does not use bind variables, indexes are not used, too many resources are used, etc…
2. Check tuned versions of SQL text, it might give some ideas how to improve your application performance.

Project Members:

• Victor Conovalov (admin)