122: Reducing Risk of Surprises in Changing Multi-tier Distributed Oracle RAC Environment
Boris Zibitsker , BEZ Systems, Inc.    Biography

Objectives: How to set up realistic SLO and SLA for Oracle environment with mixed workloads
How to predict the impact of growth, hardware upgrades, DB & Application tuning in multi-tier env-nt
How to mng change, reduce risk and uncertainty during new appl implementation, server consolidation
Abstract: In Oracle RAC parallel processing environment supporting applications with different performance, resource utilization and data usage profiles workload growth, implementation of new applications affects performance of applications differently. Oracle RAC has several self-healing features helping with performance tuning, but how to justify workload management and operational decisions, hardware upgrades, server consolidation, level of concurrency and parallelism? Interdependences between application servers and DBMS servers in a multi-tier environment makes life even more complex. It is difficult to avoid surprises if you do not know what to expect. In this presentation we will review case studies illustrating how workload characterization and performance prediction justify realistic SLO and SLA, effective strategic, tactical and operational decisions. We will illustrate how comparison of the acctual results with expected enables creation of the proactive Service Level Management.

Audiernce Focus: DBA
Expertise: Intermediate
Track: Architecture
Date: Wednesday, April 16, 2008
Time: 3:15 PM - 4:15 PM