AnalysesOracle 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 SQLs 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.