Hi ,

(1) You can use SQL Navigator provided by Quest Software Lab. There is a feature called SQL Tuning Wizard.

(2) You can also use TOAD ( Tool for Oracle Application Developer).


But the best is with EXPLAIN PLAN available in oracle.

You can refer SQL Tuning tip/tricks books or ref. material for this.