RMOUG Training Days 2007
February 14th-15th

 

NEW!  RMOUG UNIVERSITY SESSIONS
Tuesday, February 13, 1:00 p.m. - 5:00 p.m.


Based on participant feedback asking for longer/in-depth sessions, RMOUG is offering six University Sessions this year for an extra fee of $125 for people not attending Training Days, and $112.50 for people attending the conference. Each session is four hours long and is offered only on Tuesday afternoon. Below are descriptions of the sessions offered.

Data Guard—All You Wanted to Know But Didn't Have Time to Find Out
Carel-Jan Engel, DBA!ert
Room 102

Running Data Guard out of the box is a piece of cake. GUI driven, a couple of mouse clicks, and voila! But what's going on behind the scenes? How do you determine the right settings of the LOG_ARCHIVE_DEST_n parameters? SYNC/ASYNC, LGWR/ARCH—there are some 50 pages of documentation to explain one parameter.  What is important, what isn't?  What is a robust setup of init.ora, listener.ora, tnsnames.ora, to enable easy switchovers and failovers? How do you tune the redo transport between primary and standby? How do you split the network traffic of redo and application? How do you deal with a setup with two standbys? There are many more questions to be answered when setting up Data Guard. Having set up more than 50 Data Guard configurations at more than 30 sites, Carel-Jan has developed a robust approach that can deal with complex environments, but can also be scaled down for straightforward primary/standby setups. During this University Session he will share his insight with you, illustrated with demonstrations of setups, failovers and switchovers.

Wait Events and the Geeks Who Love Them
Kyle Hailey, Independent Consultant
Room 103/105

The wait interface method for tuning Oracle databases has become well known. Unfortunately the exact meaning of the wait events themselves is still shrouded in mystery. Now for the first time, each of the top 30 wait events will be explained in detail and examples of typical causes and solutions given. The top 30 wait events represent 99.9 percent of the wait time reported in Oracle customer databases. Note: the lecture is aimed at version seven through nine, though some version 10 wait events will be discussed. Lecture excludes RAC and OPS wait events.

Web Development with JDeveloper 10g for Forms and PL/SQL Developers
Peter Koletzke, Quovera
Room 104/106

It is often difficult to select among the myriad of technologies available for Web applications deployed in the J2EE environment. In addition, development work for this environment is very different from the "traditional" paths Forms and PL/SQL developers are accustomed to. This University Session offers a solid introduction to a recommended set of technologies that provide a development experience as close to Forms as possible—ADF Business Components, JSF, and ADF Faces. It briefly explains where these technologies fit in the J2EE world and how to create code using Oracle Application Development Framework (ADF) in JDeveloper 10g. Students then obtain an introduction in how to use ADF Business Components to create a code layer to access the database for queries and updates. The presentation focuses on how to create a Web user interface using JavaServer Faces (JSF) and ADF Faces that connects to the data access layer. Concepts discussed include J2EE architectures, Web languages, converting forms applications to J2EE, ADF architecture, the ADF Model layer, entity objects, view objects, database-centric development, bindings, and data controls.

RMAN Backup and Recovery—A Beginner's Guide
Robert Freeman, Independent Consultant
Room 108/110

More and more Oracle sites are using RMAN as their preferred backup and recovery solution. In this four-hour University session, the author of Oracle Database 10g RMAN Backup and Recovery will walk you through the setup and use of RMAN. You will leave the session having learned how to setup and configure RMAN, what a recovery catalog is and when to use it, and how to backup your database with RMAN. Most important, you will learn how to recover your database from all those nasty, late night failures that never come at a convenient time.

ASM: From Beginner to Master
Arup Nanda, Starwood Hotels
Room 107/109

Automatic Storage Management (ASM), introduced in Oracle 10g, redefined the way storage is used in the Oracle database. It has been designed to keep in mind the Oracle database access, so the performance is considerably better compared to other storage techniques. It is a myth that ASM is only for the RAC database; it is good for any Oracle database. In this session, you will learn everything about ASM, from setting it up to use in backup and recovery. Everything will be demonstrated live.

SQL Developer and Application Express (Two-Part Session)
Room 111/113

Part One
SQL Developer Workshop: Oracle's Graphical Database Development Tool (Two Hours)
Kris Rice, Oracle Corporation

There are many tools available in the market today that allow you to interact with an Oracle database. SQL Developer, Oracle's graphical alternative to SQL*Plus, allows the database developer a convenient way to perform basic tasks. Using a combination of presentation and hands on, this workshop walks you through various aspects, including editing and debugging PL/SQL, creating user defined master-detail reports and more. Adding extensions to SQL Developer and demonstrating how to build a small extension will be discussed. We will be using the latest release of SQL Developer, pointing out the latest new features.

Part Two
End the Microsoft Access Chaos—Your Simplified Path to Oracle Application Express (Two Hours)
Mike Hichwa, Oracle Corporation

Many companies have large numbers of Access applications, which have become unmanageable. They are looking for better solutions to maintain, secure and consolidate these applications. Oracle Application Express is one such solution. Using the Oracle Migration Workbench you can migrate a Microsoft Access schema and data today, but what about the application? This was a manual process, but with the introduction of Application Express 3.0, help is at hand. An important feature of Application Express 3.0 is the new Application Migration Workshop. In this demonstration rich workshop, we will briefly position Oracle Application Express 3.0 and then walk through a series of tasks that a developer might do in migrating an Access application to Oracle Application Express following an appropriate migration methodology to ensure your migration is successful. In closing we'll look at a few plans for the future as to how this capability could be extended or applied to other targets and outline our strategy for migration tools going forward.