March 1&2, 2007
Renaissance Charlotte Suites Hotel
Charlotte, North Carolina

2007 Presentations
Please click on the presentation title to download the handouts. Additional Handouts will be added this week. Please check back if the presentation you would like to download is unavailable.

To read more about our conference presenters, click here.

General Session Keynote
Kevin Loney, Director of Technology, Electronic Ink
Future History: My 2010 SEOUC Keynote
Back from the future! In this talk, we will look back on 2007, 2008, and 2009 and see how the trends in the Oracle industry in those years gave rise to the Oracle database world of 2010.  We'll look back at employment trends, database sizes, the new benchmarks, and the rise of usability as a critical issue for applications.  This talk will also cover such critical issues as the disappearance of the .400-hitting DBA, why drug dealers live with their mothers, and why UNIX servers have a nicer office than their operators do.

Friday Keynote
William Hardie, Vice President, Database Product Marketing, Oracle Corporation
Introduction to Oracle Database 11g
2007 marks 30 years of Oracle helping businesses and governments manage their most valuable asset—information.  It's the lifeblood of all your applications; from traditional transactional systems to large data warehouses, Web2.0, XML, and other applications. During this presentation, we'll discuss today’s IT challenges and how Oracle Database 11g can help manage your user’s service-level objectives and reduce your cost of computing.

A Practical Introduction to Oracle 10g Flashback Features
Dave Anderson, SkillBuilders
DBA—Intermediate
This presentation will discuss the enhancements and new features related to flashback query, flashback table, and flashback drop table.  You will learn how to use flashback version query, the FLASHBACK_TRANSACTION_QUERY view, flashback table, and flashback drop table.

Introduction to Automatic Storage Management (ASM)
Dave Anderson, SkillBuilders
DBA—Intermediate
This presentation is an introduction to Oracle's new integrated file system and volume manager, ASM. Demonstrations will illustrate the basics of implementation, including creating disk groups, migrating to and from ASM, and using ASMCMD to manage ASM files.

Beefing Up Memory in Oracle10g
Michael Ault, Quest Software
DBA—Intermediate
This presentation will include Oracle 10g memory management, a discussion of ASMM issues and how to configure the various pools and caches in 10g.  This presentation provides insight into the Oracle10g memory structures and how to monitor and tune them.

Business Process Improvement Through AP Automation
Cliff Autin, ReadSoft
Oracle Financials—All
Thousands of Oracle E-Business Suite users are benefiting from Document Automation technology to enable AP departments to overcome tedious work, such as keying in information from incoming invoices, so that it is handled automatically.  This presentation will explain all functionality, including flow monitoring capabilities, automatic validation, tools for high speed verification, streamlined transfer, approval workflow and EDI.  By utilizing these tools, Oracle E-Business Suite users can increase efficiency of AP processing while cutting down on manual handling costs.

Deploying Oracle Enterprise Manager Grid Control 10g to Monitor Oracle Databases
Leonora Barry, Dominion Resources Services
DBA—Intermediate
Managing multiple applications and databases has made it critical to deploy an efficient tool to keep DBAs informed of the health and well being of their database server.  This presentation covers real world experiences in deploying 10g OEM to monitor over 600 databases for a geographically dispersed team. 

Lock Down Your Data with Oracle Database Security
Jonathan Beasley, Oracle Corporation
Security—All
Information Security is about ensuring confidentiality, integrity, and availability of your data. The vast majority of threats come from the inside and can include unauthorized access to information, fraud, and massive interruptions to the business. Join us to learn more about how you can safeguard your enterprise with Oracle Database Vault to prevent application data from being viewed by your DBAs or other privileged users.

SOA, Web Services, BPEL and How It Interacts with Existing Architecture
Matt Busch, AppWorx
DBA—All
New and exciting advances in enterprise architecture have customers thinking about how to apply SOA, Web Services, and BPEL to their strategy.  This presentation will discuss how to standardize linking, coordination, and communication with old strategies while optimizing performance and efficiency levels.

Database Duplication and Cloning: From 8i to 10g
John Claxton, Independent Consultant
DBA—Intermediate
This session will discuss the methodologies available to duplicate or clone a database using tools available from Oracle8i, 9i, and 10g.  It will also include an actual duplication of a 10g database. Expect to learn the tools, traps and tricks of the trade, along with some of the pitfalls along the way.

Saving Time, Validating, and Maximizing Processes with Storage Software
Michael Doherty, Network Appliance
DBA—All
This presentation will walk you through storage backups, restores, and the cloning of databases. It will discuss cost-effective 
non-disruptive disaster recovery, with the ability to validate processes and/or build QA, Dev, Test—all to help you drive 
excellence across your operational infrastructure.

Application Delivery Networking for Oracle Application and Oracle Fusion Middleware
Michael Falkenrath, F5 Networks
Application Development—All
Traditionally applications and networks have been at odds with one another and lack of coordination between IT teams has exasperated the issue. There is a better emerging architectural model called Application Delivery Networking that goes beyond traditional Layer 2-3 networking. Application Delivery Networking encompasses Layer 4-7 technologies, which are focused on offloading application security, acceleration, and availability functions from the applications themselves. The objective is to create a common repeatable network services model that can be leveraged by all application types to improve application performance, security, and availability.

GoldenGate for Low-Impact, Real-Time Reporting and Data Warehousing
Mark Geisler, GoldenGate Software
Data Warehousing/BI—All
The IT organization is under increasing pressure to find solutions that reduce data latency for reporting and data warehousing activities, as business recognizes that impressive BI improvements are enabled by utilizing near real-time or real-time data. GoldenGate Software has extensive experience deploying its Transactional Data Management (TDM) software for companies that need real-time information that’s available 24x7. This presentation will review GoldenGate’s architecture for enabling real-time data warehousing and “live” reporting that no longer impacts production/OLTP systems.

Extending OEM Grid Control Functionality with Plug-ins
Mike Ghelli, BEZ Systems, Inc.
DBA—All
With OEM Grid Control R2, Oracle now maintains a central repository of performance data for its users to interact with. This presentation will focus on two key areas within the OEM framework: the standard Oracle Instance target type and Management Plug-ins to extend OEM collection capabilities. Attendees will learn what Oracle Instance data is persisted in the OEM central repository and what data is retrieved and displayed dynamically.

Near Real-Time Business Intelligence in the Real World—Case Study with OWB and 10gDB
Randy Gobbo, Maersk
Kurt Lueck, Solomon Technology Group
Data Warehousing/BI—All
This session will detail a real life Oracle business intelligence implementation for Maersk.  We will feature in detail, Oracle Warehouse Builder, Oracle 10gR2 Data Warehouse features, Oracle Portal and many lessons learned.

Use Oracle Heterogeneous Services to Integrate Oracle and Non-Oracle Databases Using Generic Connectivity and Transparent Gateways / Syntax Examples
Ron Harmon, EnteGreat
DBA—Intermediate
Relational data from both Oracle and most non-Oracle sources can be made visible to the Oracle database engine. This allows the Oracle database and applications that use this database to incorporate data from all over the organization into one consolidated delivery vehicle.

Navigating the Waters of Oracle Streams
Vinod Haval, Bank of America
DBA—Intermediate
Using Oracle Streams, you control what information is to be put into a stream and how to navigate the information from database to database until it reaches its final destination. This presentation will discuss setup in homogeneous or heterogeneous environments, setup using a set of processes and database objects to share data and messages, capturing the database changes, and configuring streams to capture user-defined messages.

Optimizing Data Guard Performance
Vinod Haval, Bank of America
DBA—All
Data Guard is one the finest DR solutions Oracle is providing. This presentation lists some of the best practices you can implement in order to improve the overall performance of the Data Guard and make sure that the entire environment is highly available and can be recovered up to the time specified.

Supercharge Your Applications with Analytics
Joshua Jeyasingh, Oracle Corporation
Data Warehousing/BI—All
Oracle's comprehensive set of Business Intelligence applications provides greater business insight by proactively guiding users to make the most informed decisions. Oracle's BI applications include capabilities such as corporate performance management, interactive dashboards, and embedded analytic capabilities for delivering insight pervasively across your enterprise. Open, pre-built, industry specific BI applications provide actionable intelligence for each business function and user role. These solutions are hot-pluggable into your existing operational systems, meaning you can infuse enhanced intelligence capabilities into your Oracle, custom, and third-party applications, all while leveraging existing investments in hardware, software, and employee skill sets.

Oracle 10g RAC Over Veritas SFRAC: Architecture, Installation, Configuration, and Verification
Ashok Kapur, Hawkeye Technology, Inc.
DBA—Advanced
RAC is part of High Availability architecture available as part of Oracle RDBMS. This presentation covers the function of all Veritas and Oracle RAC components; installation, configuration, and verification of Oracle 10g RAC and Veritas SFRAC.

Forms Personalization for Oracle HRMS
Timothy Lavery, SEKON Enterprises, Inc.
Oracle HRMS—Intermediate
One of the best kept secrets of Oracle Applications is the Forms Personalization functionality.  This powerful feature allows users to define Business Rules on Oracle Forms via a GUI (Form) Interface instead of PL/SQL and Custom Library.  This session will provide an overview of how to use Forms Personalization, using a number of HRMS-related examples.

Overview of Oracle HRMS Audit Trails
Timothy Lavery, SEKON Enterprises, Inc.
Oracle HRMS—All
The purpose of this session is to educate attendees on the capabilities of the Audit Trail functionality for Oracle HRMS.  An understanding of Oracle's Audit Trail for HRMS will enable users, analysts, and consultants to better determine how Sarbanes-Oxley auditing requirements can be accommodated, while at the same time avoiding costs on unnecessary customization or reports.

Best Practices in Enterprise Database Protection
Ulf Mattsson, Protegrity
Security—Intermediate
New business models rely on open networks with multiple access points to conduct business in real time, driving down costs and improving response times. By leveraging the ability to quickly exchange critical information and improve position, enterprises are introducing new vulnerabilities that can be exploited to gain unauthorized access to sensitive information. This presentation will review best practices with real world solutions to protect the confidentiality and integrity of your database.

Delivering IT Projects On Time and Within Budget
Jennifer McNeill, CipherSoft, Inc.
Professional Skills—All
This presentation will provide insights into the real reason IT projects fail as well as why they so often go over budget.  Participants will learn how to manage projects effectively and how to monitor projects to ensure they will be effective.  In addition, the presentation will provide winning strategies to attendees for project planning.

Enabling Your Applications to Provide Web Services—Migrating Oracle Forms Applications to the Web
Jennifer McNeill, CipherSoft, Inc.
Application Development—Intermediate
This presentation provides insights on the alternatives for migrating Oracle applications to the Web with strategies for providing effective Web services applications. Participants will learn technical aspects and challenges of moving from Oracle Forms into Java and Forms 10g.

Real Time Analytics Using Oracle Data Mining
Shyam Nath, Oracle Corporation
Data Warehousing/BI—All
The session will highlight the data mining capabilities of the Oracle database and how to integrate it with the Oracle BI platform. It will discuss real time decisioning using data mining. Participants will learn basics of data mining and learn how to extend data mining to solve real world problems. The users will see case studies on how to use data mining to create analytical applications that provide a business advantage.

JDeveloper 10g Release: 3 New Features
Shaun O'Brien, Piocon Technologies
Application Development—Novice
This session will focus on the latest release of JDeveloper (10g Release 3) including a full survey of the new features with step-by-step development of a working example illustrating how these new features enable seamless design, visualization, development, and deployment of the most cutting edge features of a SOA environment.

SOA in the Wading Pool
Shaun O'Brien, Piocon Technologies
Application Development—Intermediate
This presentation will introduce the Oracle SOA Suite. Each of the components will be covered in approachable, yet comprehensive detail illustrating how each fits the vision of Oracle Fusion. Attendees will develop the confidence to lead their organizations into the SOA pool without worry that they're heading in over their heads.

Data Privacy...The Internal Threat
Eric Offenberg, Princeton Softech
Security—All
While companies are making great strides in protecting data privacy in production application environments, the idea of implementing similar strategies in their testing environments is often overlooked.  This presentation on combating the internal threat to your application databases will include a review of current legislative themes, how privacy is bring addressed today by large enterprises, understanding where threats to data privacy exist within your organization, and methodologies for implementing a solution to this issue.

Getting the Most Out of RMAN / Scripts and Samples
Charles Pfeiffer, FireTower Tech, LLP
DBA—Intermediate
This presentation will cover the basics of implementing and using RMAN, including creating an RMAN repository, configuring RMAN backup parameters for a database and backing it up, and discussing key configuration parameters. In addition, this presentation will walk through some of RMAN's reporting capabilities to verify that a good backup exists in the catalog and will include recovering and cloning a database.

Introduction to Application Express
Doris Phillips, City of Charlotte
Data Warehousing/BI—Novice
This introduction to Oracle’s Application Express provides an overview of Application Express and walks through the techniques for developing an application based on a case study that uses Application Express to track Service Level Agreement metrics.

Living With and Around Oracle Warehouse Builder 10.2
Jim Raper, City of Charlotte
Data Warehousing/BI—Intermediate
This presentation will focus on three Extract, Transform, and Load techniques with Oracle Warehouse Builder 10.2:  merging data from multiple input sources, creation of complex views using joined tables, and transforming data using Expressions.  The presenter will also highlight a bug workaround in 10.2.

Wait-Time Based Oracle Performance Management
Dean Richards, Confio Software
DBA—Advanced
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 that 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.

Database Best Practices: Developing for Performance
Kuljit Sangha, Quest Software
Application Development—All
Did you know that the most common source of database performance problems is poorly performing SQL?  Learn about best practices that can help you accurately simulate production workload and ensure optimal performance in your Oracle environment. This presentation will show how these best practices, combined with Quest solutions for Oracle, enable developers to produce quality SQL, while reducing development time and boosting productivity.

Enhance Oracle SSHR with Advanced Personalizations and OA FWK Extensions
Ramesh Sannegowda, Xcelicor, Inc.
Oracle HRMS—Advanced
Up until OA FWK 5.10, customers were limited to just basic personalizations. Oracle now delivers enhanced personalizations, including SPEL binding and Custom Look & Feel. Special JDeveloper with built-in extensibility allows you to easily and rapidly extend the application. This presentation will demonstrate these advanced personalization and extension features.

You'll Love Being the DBA: Smoothing the Transition
Hilary Shreter, Oak Ridge Associated Universities
Professional Skills—All
This presentation is a lessons-learned discussion on transitioning the skill-base of database administrators in an Oracle Applications / Discoverer setting.  This discussion will outline some success factors, some lessons learned, and sketch the baseline documentation needed to make sure that transition is smooth and transparent.

60 Oracle Security Tips in 60 Minutes
Kenny Smith, Cnetics
Security—Intermediate
These Oracle features, scripts, and pearls of wisdom can assist any Oracle professional with the daunting task of locking down and protecting an Oracle database system. This presentation provides database system security tips from an Oracle professional who has performed many database security assessments and prepared customers for audits.

Beginner’s Guide to Oracle Business Intelligence
Craig Warman, Computer Resource Team, Inc.
Data Warehousing/BI—Novice
Many Oracle professionals–from beginners to seasoned veterans–are finding themselves unfamiliar with the capabilities the Oracle database and tools provide for Business Intelligence.  This presentation bridges that gap by providing an overview of various data mining concepts, then moves quickly into some of the various Oracle technologies that meet those needs: Oracle Warehouse Builder (OWB), Analytic Workspace Manager (AWM), Oracle Discoverer Relational and OLAP Editions, Business Intelligence Beans (BI Beans), Oracle Data Miner (ODM), and the Oracle Spreadsheet Add-In for Predictive Analytics.  Attendees will gain a practical understanding of when and how these products can be quickly deployed to solve problems that used to require a combination of third-party tools and significant custom software development investment.

Statspack: Identifying and Correcting Performance Problems
Robert Webb, FireTower Tech, LLP
DBA—Novice/Intermediate
Oracle Statspack report is freely available in all recent versions of Oracle.  This utility is highly useful for monitoring the health of your database as well as identifying specific performance bottlenecks.  We will examine the Statspack report in detail from a DBA perspective, focusing on the areas that often identify performance problems and discuss potential solutions.

Zen & the Art of Database Automation
Matthew Zito, GridApp Systems, Inc.
DBA—Advanced
By the end of this presentation, participants will: 1. Gain a broad understanding of the role database automation technology plays in securing the data center, as well as the other benefits of this technology; 2. Discover how to implement a comprehensive plan to automate your database infrastructure; and 3. Learn how to quantify the ROI of a database automation investment.