Hotsos Symposium Speaker – Karl Arao

Karl Arao is a new Hotsos Symposium presenter.


Karl AraoKristofferson "Karl" Arao is a Senior Technical Consultant at Enkitec.

Some of his experiences as a DBA include Proactive database maintenance, Database Installation and Configuration for High Availability and Disaster Recovery, Migration and Upgrades, Backup and Recovery, Database Hardening, Capacity Planning, and Performance Tuning. He shares his experiences, adventures, and discoveries in his Blog ( and owns a Wiki site ( where he shares his quick guides and documentations on technologies.

Karl Arao is an Oracle Ace (, OCP-DBA, and RHCE. He presents at local Oracle Events and DBA round tables, and has also presented at the recent Oracle Open World Unconference and Oracle Closed World. He is also a proud member of the Philippine Software Industry Association Technology Council.

Presentation Title

Mining the AWR Repository for Capacity Planning, Visualization, and Other Real World Stuff


New CPUs and storage arrays are getting faster, but these resources are finite and come at a cost. Hence, capacity planning plays a very important role to ensure proper resources are available and to handle expected and unexpected workloads. Another critical matter for the DBAs and IT managers is justifying the expense of adding resources on the system. With guesswork you'll end up getting the most expensive hardware. With proper measurement, proper planning, and management of growth, you'll be able to get just the right hardware for your workload with allowance for a particular growth period. This will result in huge savings for the company and a happier IT shop.

AWR is a built-in data store that started in 10gR1 and is very much like a "Statspack on steroids". It has improved significantly in 11gR2, enabling you to have a far better workload information when going through all the AWR snapshots. From the AWR data samples, we could build amazing reports that will let us notice trends and makes it possible to visualize data and use statistical methods for analysis. Even more surprising about the AWR data samples is we are able to define the database server's Capacity, Requirements, and Utilization in terms of CPU, IO, memory, and network, which are very important key metrics for Capacity Planning.

In this session, attendees will be able to learn how to make use of the AWR, specifically the DBA_HIST tables, to have a clear-cut measurement on resources to aid in Capacity Planning, Predictive Analysis, and Performance Firefighting.

Presentation Materials

Presentation materials are available online to attendees only.


The speaker schedule is as follows: