OOUG Meeting Agenda April 3, 2008 print

Our April meeting is sponsored by Confio Software and tailored for the OOUG membership.

Sponsored by:

Meeting Location:

5600 Post Rd
Dublin, OH 43017
(614) 410-4550

This facility provides free wireless internet access.

Registration:

Please register by Tuesday, April 1^st, 2008 by sending email to membership@ooug.org.

If you need overnight lodging, see the list of local hotels.

Meeting Cost:

• Free for 2008 OOUG members
• $20 for non-member attendees (cash or check only)

The meeting includes presentations, breakfast, lunch and snacks. Gift giveaways will vary but usually include drawings for Oracle books.  All attendees are automatically registered in the OOUG gift drawings.  Occasionally, vendor representatives will offer additional gift drawings that require attendees to register directly with the vendor in order to be eligible to win a prize - such registration is entirely at the option of the attendee.

Meeting Schedule:

Presentation Abstracts:

Achieving High-availability on Oracle E-Business Suite through Streams

One of the biggest challenges facing Oracle E-Business suite (EBS) customers who have implemented the single global instance concept is how to apply patches while keeping the application available 24x7. We are addressing this challenge by creating a second EBS database for the manufacturing shop floor users and providing the opportunity for patching and maintenance for applications such as HR/Payroll, Finance, and Order Management in the original EBS database. Both databases are kept in sync by setting selective schema level bi-directional Streams between the two databases. This session will discuss the overall EBS architecture, Streams implementation design and best practices and lessons learned from the implementation. This is the first known use of Oracle Streams to address high-availability for Oracle E-Business suite.

Wait-Time Based Oracle Performance Management

There are many ways to use Oracle wait events for performance tuning of an Oracle database, but often there is confusion on exactly what the data means. The issue typically centers around the fact the wait event data is analyzed at the wrong level or the collected wait event data is not detailed enough. This presentation will focus on these problems and review several real-life case studies of using wait event data coupled with Wait-Time based performance analysis to solve the most difficult performance related issues.

Lunch and Learn

Demonstration of the Confio software.

SQL*Plus and Alternatives

Command-line interaction with Oracle is alive and well, and nearly all Oracle users fire up SQL*Plus at one point or another... but the command line offers power most users never realize. Catherine will review three open-source command-line clients for SQL*Plus (yasql, senora, and sqlpython), comparing their features, strengths, and weaknesses. She will also cover "the SQL*Plus you never knew you had": little-known features of the tool you thought you knew.

Solaris Performance Diagnostics for Database People

There are loads of presentations covering database performance diagnostics and troubleshooting. There don't appear to be many that help you investigate what's going on with your database server.

This presentation focuses on Solaris tools that come with the operating system that help the DBAs and developers figure out what may be going wrong on the database server, which may or may not be related to what your database is doing, but are likely impacting your database.

Dallas will discuss and give examples for using top, sar, prstat, iostat, netstat, truss and other OS utilites that DBAs and developers can use to become familiar with what is going on with their servers, and what data might be of concern.

Speaker Information:

Dean Richards, Senior Oracle DBA, Confio Software

Dean Richards has over 15 years of Oracle project development, implementation and strategic database architecting. Before coming to Confio, Dean held engineering positions at McDonnell Douglas and Daugherty Systems, an object-oriented solution provider for Anheuser-Busch.

Dean was also a technical director for Oracle Corporation managing all aspects of their broadband account including short and long-term technical planning and strategic alliances. As a highly successful liaison between management and technical staff, Dean has proven to be an effective collaborator implementing cutting-edge Oracle solutions. A double major in Computer Sciences and Mathematics, Dean graduated Cum Laude from Southern Illinois University.

Catherine Devlin

Catherine Devlin has worked since 1999 on small-scale Oracle systems as an all-purpose DBA, PL/SQL developer, and writer of web and GUI interfaces. She is an active writer, speaker, and organizer in the Oracle and Python communities and is president of DAY-O, OOUG's Dayton SIG. She works for IntelliTech Systems at Wright-Patterson Air Force Base in Dayton, and blogs at catherinedevlin.blogspot.com.

Dallas Deeds

I have been working in IT for 13 years, as a Perl programmer, and Oracle DBA. My major focus for the last 8 years has been Oracle database adminstration, especially performance tuning. I am part of a seven-member DBA team administering over 550 Oracle database ranging in size from 2 GB to 4 TB.

Sadeepa Wijesekara

Sadeepa Wijesekara has been an IT Architect, Oracle DBA, Oracle E-Business suite (EBS) Architect, UNIX administrator and SOA Architect since 1997. His specialties include High available systems architecture, SOA architecture and EBS suite implementations. He has introduced numerous innovative ideas around EBS patch management, EBS integration and EBS high availability while working at Oracle Corporation and other corporations.