What tools/utilities does Oracle provide to assist with performance tuning?

Oracle provide the following tools/ utilities to assist with performance
monitoring and tuning:

  • ADDM (Automated Database Diagnostics Monitor) in Oracle 10g

  • TKProf

  • UTLBSTAT.SQL and UTLESTAT.SQL - Begin and end stats monitoring

  • Statspack

  • Oracle Enterprise Manager - Tuning Pack