Originally posted by sunkutup
1. I would like to know how to find SQL statements that are not performing well. Is there any script for this.
You can check it through the V$SQLAREA view.


Have your user tables and indices analyzed. Set your optimizer mode to choose. Use bind variables in the query.....


Sam