oracle tunning

cursor_sharing
1. avoid FTS (Full Table Scan)
2. cluster index-organized tables
3. cluster materialized view
4. Orace Patii
 Crsor sharing.