Application Development
Rich Web Applications for the Enterprise...Creating RWA from Your Oracle Database
John Krahulec, Bizwhazee
Leverage the power of your existing Oracle Database and PL/SQL development skills to create the rich web applications your customers desire.
Modernizing Your Oracle Forms Application - Making the Business Case
Jennifer McNeill, CipherSoft Inc.
In this presentation, you will learn technical aspects and challenges of moving from Oracle Forms into Forms 10g and Java, migration options available and pros and cons of Forms 10g and Java, business reasons for moving to 10g and Java, challenges associated with migrating applications into 10g and Java, and if the effort and dollars spent for a migration project will justify the costs.
Oracle Application Express Now and in the Future
David Peake, Oracle Corporation
Learn why Oracle Application Express (APEX) is one of Oracle's most popular technologies and see how this database-centric RAD tool can help solve your business requirements. Some of the major new developments will also be discussed.
Data Warehousing/BI
The Economics of Oracle Data Warehouse Performance
Randy Arseneau, Zettapoint, Inc.
Enterprise Data Warehouses are growing at a blistering pace. As DWH designers, administrators and users struggle to manage this expanding tidal wave of data, they are often confronted with significant barriers to scalability, manageability, and performance. In this presentation, we will discuss some best practices for usage-based data classification that can significantly improve DWH efficiency and performance, while reducing infrastructure TCO.
My Data Warehouse Dream Machine: Building the Ideal Data Warehouse Platform
Michael Ault, Texas Memory Systems
Facing a data warehouse implementation? Have no clue what hardware to look at? Come to this presentation for a take on what makes an ideal data warehouse machine.
Tapping Oracle 11g Geospatial information with Oracle OBIEE
Vincent Belanger, TUSC
This presentation will demonstate how to see your organization geospatially, allowing for business decisions to be made at the speed of business, leveraging Oracle's 11g geospatial offering and OBIEE
Using Visual Analytics to Prototype Data Warehouse Requirements
Jim Raper, City of Charlotte
Defining a data warehouse and business intelligence build strategy is fraught with problems, not the least of which are scope gallop, delivering on time, and missing the mark on what management actually needs (regardless of what they initially said they wanted). This presentation will present a front-loaded use of visual analytics to assist the team in defining the true requirements both for the customers and for the developers.
DBA
Going Solid: Use of Tier Zero Storage in Oracle Databases
Michael Ault, Texas Memory Systems
In this presentation the proper use of multi-tier storage will be discussed, along with techniques for characterization of database objects for proper multi-tier placement.
Eliminating Oracle Database Production Issues with the Implementation of Database Configuration Management
Sandy Chopra &
Steve Riley, Booz Allen Hamilton
Database Configuration Management (CM) is the process of securing and controlling the database environment and is vital to the success of custom development projects. The Database CM Manager, who is often an Oracle DBA, controls the database environment from the Operating System layer to the Data layer. As part of our presentation, we will walk through an application development life cycle and discuss best practices and lessons learned from our experiences.
Database Duplication Using RMAN in 11g
John Claxton, B/E Aerospace
Using RMAN to create "clones" of a database keeps getting better and better. This session will discuss the latest and greatest RMAN duplication features from 11g.
Simplifying Database Environments
Matt DeMarco, NetApp
NetApp storage solutions deliver business value to both the application developer and IT management. This represents a significant cost saving that is realized as soon as the solution is deployed. In addition, NetApp's content management solutions can be easily integrated into an application with minimal effort and maximum business benefit. The net result is that applications can be developed and deployed significantly faster and easier than with any other storage platforms and at a much lower cost.
SQL Tuning Scripts - A Demonstration of a Set of Proven SQL*Plus Scripts
Bobby Durrett, U.S. Foodservice
This presentation demonstrates a set of SQL*Plus scripts used over and over again to produce fantastic improvement in SQL performance. The scripts focus on the information we need without including a bunch of useless stuff. The session includes an explanation of each script, how to use them to tune a SQL statement, and working through an example. Download the scripts for free at http://www.geocities.com/bobbyandmarielle/sql.zip.
Database Benchmarking: Methodologies, Tools, and Techniques
Jonah Harris, myYearbook.com
Oftentimes DBAs are called upon to perform benchmarks between different vendor software or hardware platforms. In these cases, a working knowledge of proper benchmarking methodologies and toolkits available is a must. This session covers these aspects as well as many more database benchmarking DOs and DON'Ts.
Managing Statistics for Optimal Query Performance
Karen Morton, Method R Corporation
Half the battle of writing good SQL is understanding how the Oracle Optimizer analyzes your code and applies statistics in order to derive the "best" execution plan. This presentation reviews several key areas where "bad" statistics can cause query plans to be sub-optimal. Then, we'll discuss how to choose an optimal stats gathering strategy that includes how to best use dynamic sampling and when and how to manually set statistics directly versus collecting them.
Find the SQL, Find the Plan
Margaret Norman, Duke Energy
When troubleshooting reports performance problems for a single process or report, the DBA is often challenged to extract the information for just the problematic session. “Find the SQL, Find the Plan” explores four real-world scenarios where performance was good and has now degraded, using cache and AWR data to find the session, SQL, and actual execution plan being used by the troublesome process or report.
Tuna Helper - Proven Process for Tuning SQL
Dean Richards, Confio Software
Many DBAs and Developers are faced with tuning poorly performing SQL statements. However, many tuning projects fail because the process being used is inefficient. This presentation will walk through a process Confio Software uses with great success and will include topics such as: indexing strategies, use of histograms, SQL wait event data, column selectivity and several more that will help the you succeed on future tuning projects.
Performance Tuning Oracle RAC
Murali Vallath, Summersky Enterprises
This presentation will look into the methods of tuning a RAC, by collecting and analyzing performance statistics from live and controlled test environments. Many real-life examples will be discussed during this session.
Using Oracle Transportable Tablespace and Streams Replication to Migrate Terabyte Size Oracle Database from HP to Linux Without Application Downtime
Janet Wang, Time Warner AOL
Oracle provides several ways for cross-platform database migration, but to migrate your mission-critical Terabyte size database cross-platform without impacting business will definitely create some big challenges. This presentation will describe a solution for this type of migration using Oracle transportable tablespace and Oracle STREAMS replication. It also includes Oracle logical dataguard in the whole scenario to provide failover protection in case the primary database failed in the middle of migration.
Multiple Databases in a Single Oracle RAC Cluster
Scott Washburn, Wolseley
This presentation will discuss several concepts to implementing multiple database instances into a single Oracle Real Application Cluster. Some of the techniques will be compared to deploying RAC to dedicated hardware and deploying multiple instances to single server. RAC concepts will be discussed to determine if there is a potential bottleneck in performance with deploying multiple RAC clusters.
Oracle Apps
Reconciling Oracle Projects to Oracle General Ledger
Sheryl Bishop, SkyBridge Global, Inc.
The two most common questions I hear from Oracle Projects users is, “Why do I need to reconcile Oracle Projects to the general ledger?” and “How do I reconcile Oracle Projects to the general ledger?” This presentation will address why reconciling is important, give you some tips on how to perform the reconciliation, and what to look for when the two are out of balance.
Managing Your Oracle and Other Software Assets to Lower the Total Cost of Ownership
Scott Rosenberg, Miro Consulting
This presentation will give practical tips and real-life examples on how to play the software licensing game and win. Topics to be covered include: How to optimize an organization’s software license investment and lower the TCO; The most common and costly mistakes made when purchasing or negotiating software; Avoiding the pitfalls of software license compliance; Proactive software asset management; Obtaining the best price, terms and conditions when negotiating software licenses.
R12 Aftermarket CRM Service
Mark Wittkopp, CD Group
The presentation will walk through the different modules and the successes/challenges of implenting the Service Suite of products.
Security
Attack Your Database Before Others Do
Todd DeSantis, Sentrigo
In this presentation, you will learn common security mistakes developers make, how to use open source tools to find those mistakes, and how to roll out your own PL/SQL fuzzer.
Data Privacy - Closing the Gap
Eric Offenberg, CIPP, IBM
Privacy breaches continue to make headlines as organizations scramble to protect the confidentiality of their critical customer and business data. 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. Join us as we explore best practices to address this privacy gap and secure your data and your organization.
Success Stories/Tools of the Trade
Managing a Successful R12 eBusiness Suite Upgrade - A Repeatable Methodology to Help Ensure Success
Art Dowd, O2Works LLC
If you are running Oracle applications, you have an upgrade in your future. Whether it’s a scaled down “technical” upgrade or a full blown, features-driven “functional” upgrade, there are certain tenants that are essential to a successful upgrade. Many companies only upgrade every few years and it becomes a “deja-vu all over again” experience. Because we continually assist companies with their upgrade projects, we have developed proven, repeatable methodology that helps ensure success.
Essentials of Test Data Management
Steve Johnston, IBM
Creating realistic and consistent test databases is the first step in delivering reliable database and/or application enhancements and upgrades. But with multiple database clones to configure and manage, your costs can quickly spiral out of control. Testing cycles are extended, and releases are delayed. So, how can you support rapid database and application deployment while controlling costs? Join us for a discussion of proven test data management techniques.
System Architecture/Administration
Server Crash: Oracle Blamed, But Who Was the Actual Culprit?
Bill Ellis, Precise
A server crash is painful. You are better off avoiding this situation. This is a rare opportunity to hear a true story about a critical yet unstable system and learn from their experience. We'll review the steps taken to mitigate the multiple problems which combined together caused the database server to crash.
The Life of a Query
Jonah Harris, myYearbook.com
Have you ever wondered how the Oracle Database consumes your SQL, executes your query, and gives you a result set? In this session, we'll take a walk through the core components of the Oracle Database as we explore the life of a query from beginning to end. Through this process you will gain valuable insight into Oracle which will help you to solve performance issues and write more efficient queries.
Are Rich Internet Application (RIA) Technologies Right for You?
Jason O'Meara, Quest Diagnostics, LLC
While most enterprises have used the web successfully for document delivery applications, they have found it challenging to deliver true business applications with no compromise in functionality, usability, performance, and security. A handful of RIA technologies have emerged that overcome these shortcomings and allow businesses to achieve their goals of reduced cost, increased agility, increased user engagement, and increased employee productivity while maintaining the deployment and management benefits of a web application.
