OraPerf.com:%20Real%20Life%20Performance%20Data - PowerPoint PPT Presentation

About This Presentation
Title:

OraPerf.com:%20Real%20Life%20Performance%20Data

Description:

OraPerf.com: Real Life Performance Data Anjo Kolk Sr. Chief Oracle Technologist Veritas Software History of OraPerf.com Started in December 1998 Cable modem Redhat ... – PowerPoint PPT presentation

Number of Views:134
Avg rating:3.0/5.0
Slides: 11
Provided by: AKol8
Category:

less

Transcript and Presenter's Notes

Title: OraPerf.com:%20Real%20Life%20Performance%20Data


1
OraPerf.com Real Life Performance Data
  • Anjo Kolk
  • Sr. Chief Oracle Technologist
  • Veritas Software

2
History of OraPerf.com
  • Started in December 1998
  • Cable modem
  • Redhat Linux 5.x
  • 2 CPU (366 Mhz Celeron, over clocked)
  • Initially supported only Utlbstat/Utlestat

3
Why Utlbstat/utlestat?
  • Shipped with Oracle Release
  • utlBstat Begin Statistics
  • utlEstat End Statistics
  • Run utlbstat and some time later utlestat
  • Utlestat will produce a file called report.txt
  • Many DBAs use this to monitor their database(s)
  • But .
  • Dont know how to interpret report.txt

4
Problems with Utlbstat/Utlestat
  • Create/drop tables
  • Doesnt support OPS/RAC
  • Only Instance statistics

5
Interesting stats
6
YAPP
  • OraPerf.com is based on YAPP

7
Is STATSPACK getting popular?
8
Oracle Versions
9
Future of OraPerf.com
10
Wrap up
Write a Comment
User Comments (0)
About PowerShow.com