How to find the worst sql statements in one oracle application

3rd party tool

http://www.wise-oracle.com/



http://www.confio.com/English/Products/Ignite_for_Oracle.php


http://www.confio.com/download/Ignite6_4_63Trial.zip

Oracle Tools

Oracle enterprise management diagnostics pack (not free)

Oracle DBA worst pratice

http://www.dba-oracle.com/t_worst_practices.htm

Oracle SQL top sessions

http://www.dba-oracle.com/oracle10g_tuning/t_sql_top_sessions.htm