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