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
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