What tools/utilities does Oracle provide to assist with performance tuning?
Oracle provides the following tools/ utilities to assist with performance monitoring and tuning: • ADDM (Automated Database Diagnostics Monitor) introduced in Oracle 10g • TKProf • Statspack • Oracle Enterprise Manager – Tuning Pack (cost option) • Old UTLBSTAT.SQL and UTLESTAT.SQL – Begin and end stats monitoring