Ctoug: Events

Real Life RAC Experiences at United Technologies

Speaker:

Walter Silva with over 20 years IT experience, has worked as an application programmer and database administrator on Oracle since version 7. He currently works in the Corporate Office for United Technologies as an Infrastructure Architect supporting >80,000-user HR/Payroll Systems.

Presentation Synopsis

In late 2006, United Technologies' Human Resources predicted an imminent large increase in Employee Self Service application volume starting January 2007, and was expected to tax the capacity on it's current RAC infrastructure. This presentation relives the scramble of adding two nodes "live" to the existing RAC, with all the steps, tweaks, and twists encountered before, during, and after the actual event. It is a sharing of the experience and lessons-learned ... with detailed notes, tips, and tricks.

Orchestrating with BPEL: A Service Oriented Approach to Business Process

Speaker:

Dave Senak is a SOA Specialist with The Hartford. As a specialist in BPEL technologies since 2005, Dave was instrumental in implementing BPEL as an enterprise foundational platform at The Hartford. Dave prior experience includes developing J2EE solutions at Hartford Life.

Matt Sandberg is a SOA Specialist with The Hartford where he specializes in BPEL and Fair Isaac Blaze rules deployments. Matt has more than eight years of software development experience implementing XML and J2EE solutions.

Summary:

In a service-oriented architecture, business processes can be described in terms of web service invocations. Business Process Execution Language (BPEL) builds on web service specifications such as WSDL and SOAP to deliver a standards-based solution for business process modeling. This presentation discusses how BPEL can contribute to an overall SOA strategy, and demonstrates BPEL implementation using Oracle BPEL Process Manager.

DB Time-based Oracle Performance Tuning: Theory and Practice

DB Time-based Oracle Performance Tuning: Theory and Practice
Oracle 10g formally introduced the fundamental concept of DB Time as part of the Server Manageability effort. This concept underlies or is significantly used by many of the manageability technologies of the Diagnostic and Tuning packs in both 10g and 11g, including ADDM, SQL Tuning Advisor, Access Advisor, and Enterprise Manager. Less prominently but no less importantly the concept of DB Time is intended to be the new lingua franca for Oracle performance tuning. This session will introduce the abstract theory of DB Time and its time-normalized sibling Average Active Sessions. The process of performance tuning using DB Time will be discussed and compared with other current methodologies including those based on wait-events and SQL trace.

The session will discuss the Active Session History (ASH) technology and its critical relationship to quantifying the expenditure of DB Time in an active system across many dimensions of interest to performance analysts. The automatic analysis of DB Time by the Automatic Database Diagnostic Monitor (ADDM) is also discussed. Examples usages of Enterprise Manager’s visualization of DB Time will also be presented

Materialized Views, Caching & Database Worst Practices

e might use them, and various useful ‘techniques’ you need to know in order to make the most of them.

Database Worst Practices 1 hour

A lot of time is spent by IT professionals studying best practices in the industry. This presentation turns that around and takes a look at some "worst practices," the top things you can do to ensure failure, delays, and poor performance in your database applications. Instead of focusing on things to do in your database applications, the presentation looks at things you should never do. The presentation uses actual customer experiences to investigate the top 10 things done wrong over and over again, and how to avoid making the same mistakes yourself.
Tom Kyte is a Senior Technical Architect in Oracle’s Server Technology Division. Before starting at Oracle, Kyte worked as a systems integrator building large-scale, heterogeneous databases and applications, mostly for military and government customers. Kyte spends a great deal of time working with the Oracle database and, more specifically, working with people who are working with the Oracle database. In addition, Kyte is the Tom behind the AskTom column in Oracle Magazine, answering people's questions about the Oracle database and its tools (http://asktom.oracle.com/). Kyte is also the author of Expert Oracle Database Architecture (Apress, 2005), Expert One on One Oracle(Wrox Press, 2001/Apress 2004), Beginning Oracle Programing (Wrox press, 2002/Apress 2004), and Effective Oracle by Design (Oracle Press, 2003). These are books about the general use of the database and how to develop successful Oracle applications.

PERFORMANCE and TUNING event, presented by Oracle's Graham Wood

the Server Manageability effort. This concept underlies or is significantly used by many of the manageability technologies of the Diagnostic and Tuning packs in both 10g and 11g, including ADDM, SQL Tuning Advisor, Access Advisor, and Enterprise Manager. Less prominently but no less importantly the concept of DB Time is intended to be the new lingua franca for Oracle performance tuning. This session will introduce the abstract theory of DB Time and its time-normalized sibling Average Active Sessions. The process of performance tuning using DB Time will be discussed and compared with other current methodologies including those based on wait-events and SQL trace.

The session will discuss the Active Session History (ASH) technology and its critical relationship to quantifying the expenditure of DB Time in an active system across many dimensions of interest to performance analysts. The automatic analysis of DB Time by the Automatic Database Diagnostic Monitor (ADDM) is also discussed. Examples usages of Enterprise Manager’s visualization of DB Time will also be presented.

Oracle 10g Performance and Tuning Features

Performance Statistics
- Metrics and Thresholds
- Server-Generated Alerts and Notifications
- Time Model Statistics
- Database Time
- Active Session History
- Wait Classes
Automatic Workload Repository
- AWR Snapshots
- AWR Views
- AWR Report
Oracle 10g Tuning Advisors
- Automatic Database Diagnostic Monitor
- SQL Tuning Advisor
- SQL Profiles
- Undo Advisor
- Redo Log Advisor