Sunday, February 23, 2014

Performance Tuning Tools

Available tools:

  • Basic: 
    • Time model
    • Top wait events
    • Dynamic performance views and tables
    • Alert log
    • Trace files
    • Enterprise Manager pages
  • Add-in: Statspack --- collect snapshots of statistics
  • Options:
    • Diagnostics pack
    • Tuning pack (requires Diagnostics Pack)


No comments:

Post a Comment