1 / 10

OraPerf: Real Life Performance Data

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 Linux 5.x 2 CPU (366 Mhz Celeron, over clocked) Initially supported only Utlbstat/Utlestat. Why Utlbstat/utlestat?.

hamish-houston
Download Presentation

OraPerf: Real Life Performance Data

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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 …. • Don’t know how to interpret report.txt

  4. Problems with Utlbstat/Utlestat • Create/drop tables • Doesn’t 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

More Related