Performance Tuning

Reference : Troubleshooting Performance Issues  from Oracle Supp

Active / Kill sessions , Long running queries

Active session history

Top Sql for tuning

Explain plan

Sq tuning set and Sql baseline

Bind variables

Wait events

Log Switches

Process spins

Outlines for Siebel Tuning   and  outlines for plan stability

Real application testing

Database Resource Manager

Partitions

Hints

AWR and ADDM