Hotsos Symposium Speaker – Henry Poras
Henry Poras is a returning Hotsos Symposium presenter.
Biography
Henry Poras has been an Oracle DBA for over ten years, working with custom applications as well as off-the-shelf products. He is currently developing an airline reservation system, which has strict HA and performance demands. The performance and load testing structure provides a convenient environment in which to develop innovative techniques for better understanding the hardware and tuning needs of the application.
Henry has been a speaker at the New England Oracle Users Group (NOUG) and previous HotSos Symposia.
Presentation Title
Determining Resource Utilization and Saturation Limits Using AWR history and Queueing Theory
Abstract
Combining queries of the Oracle's AWR tables with Queueing Theory analysis provides a unique method by which resource utilization needs and chokepoints within a system can be determined. We can experimentally determine, for example, the number of disks needed to achieve necessary throughput levels, as well as the load when CPU will saturate. AWR is also useful to determine changes in resource use over time as well as changes in workload mixes being run on the system. Data obtained from drilling into the Operating System will be used when appropriate. Our load test environment provides a useful test bed to collect this data, but the techniques can also be generalized to production systems. The impact of mixed workloads (different kinds of jobs being run simultaneously) will also be considered. This analysis is applied to a multi-tiered RAC system.
Presentation Materials
Presentation materials are available online to attendees only.
Schedule
The speaker schedule is as follows: