2007年7月13日 星期五

Oracle9i Database: Performance Tuning (2)

Diagnostic and Tuning Tools

  • PERFSTAT is associated with STATSPACK
  • DBSNMP is the user that connects intelligent agent with the database
  • There are three types of statistics reported in the REPORT.txt file after running UTLESTAT.SQL

Ø Library cache statistics

Ø Buffer busy wait statistics

Ø Rollback contention statistics

沒有留言: