Click on a link below to go to session category or presenter.
________________________________________________________________________________________________________________________
SESSION CATEGORIES:
Application Design
Application Development
Database Administration
Data Warehousing
Network Administration
Technology Management
Web Internet/Intranet
OTHER CATEGORIES:
Presenters by Name
Vendor Presentations
Paul Dorsey, Dulcian
Session: 7 - 9:00 to 10:00
Application Design - Intermediate
It has been difficult for traditional Oracle shops to make the transition to the J2EE technology stack. Getting up to speed building applications in this space takes a great deal of time. Applications that seem to perform well in development and test environments do not scale well in production. By using a repository-based approach, it is possible to cleanly and consistently generate entire applications, thus improving productivity and guaranteeing scalability. This presentation will describe an appropriate repository and a generation algorithm to generate JSP/Struts applications using Oracle's ADF Business Components (ADF BC) framework.
Ann Horton, Oracle Corporation
Session: 8 - 10:30 to 11:30
Application Design - Intermediate
JDeveloper 10.1.3 provides greatly enhanced UML modeling capabilities including: sequence diagrams, use case diagrams, more complete activity diagram notation, and more robust Java class and data diagrams. This session will walk through each type of UML diagram and explain its purpose, syntax, optional features, how it fits into the development lifecycle, and provide tips for its use. This presentation will also discuss how activity diagrams can support business process management with BPEL.
John King, King Training Resources
Session: 5 - 3:45 to 4:45
Application Design - Novice
Service-Oriented Architecture (SOA) is a standards-based framework that represents business functions as a set of shared, reusable services. Services can, in turn, be combined and orchestrated to produce composite services and business processes. The Enterprise Service Bus (ESB) provides the backbone of SOA. The ESB is a standards-based integration platform that combines middleware and services on the network. This presentation introduces the basic concepts and terminology of a Service-Oriented Architecture and its importance to IT.
Tuomas Pystynen, Deepbase Consulting
Session: 7 - 9:00 to 10:00
Application Design - Intermediate
This presentation will describe how to generate efficient SQL queries for a search page that has multiple optional search fields and lets users navigate over results page by page (a la Google). It will also answer these questions: Is it possible to compute the total number of rows returned with a reasonable overhead? How do I ensure consistent results in a stateless environment? Finally,the presentation compare various solutions using different techniques and features such as static/dynamic SQL, literals/bind variables, top-N optimization, analytic functions, and more.
Olivier Ricordel, Oracle Corporation
Session: 11 - 3:45 to 4:45
Application Design - All
Whether attempting to produce best of breed solutions or trying to consolidate organizations that have standardized on different vendors, businesses find themselves in the situation of having implemented several different Enterprise Application suites, each with its own interface, provisioning system, and security model. With the introduction of the PeopleSoft and JD Edwards product suites, Oracle Portal has successfully integrated three of the industry's major application suites (Oracle eBusiness Suite, PeopleSoft Enterprise, and JDE EnterpriseOne) into a single user experience. In addition, Oracle has worked with other vendors such as SAP to expose their products within this same interface.
Bradley Brown. TUSC
Session: 11 - 3:45 to 4:45
Application Development - All
You've surely heard a lot about XML. Get ready to understand its power with XSU, XSQL, and XSLT. Learn how easy it is to extract data and manipulate it into a variety of output formulas. Attending this presentation will spark all kinds of ideas--from extracting XML from your database to receiving XML files from another server or another company--and show you how easy it is to extract data and manipulate it into a variety of output formats.
Donald Burleson, Burleson Consulting
Session: 9 - 1:00 to 2:30
Application Development - All
This presentation will show actual case studies to illustrate the performance differences with these approaches to SQL tuning. Best of all, the presenter will share his proven SQL tuning secrets that ensure optimal SQL execution. Database Administration Creating a Self-Tuning Oracle 10g Database This presentation will show how you can extend upon these automation features to make Oracle 10g even more self-managing. Using the existing data from the Automated Workload Repository and Automatic Session History tables, you will learn how to create sophisticated scripts to detect anomalies and how to dynamically invoke the dbms_scheduler utility to automatically repair the process. This presentation will show working code from real-world Oracle 10g databases, and is indispensable for any Oracle professional who wants to know how to automate their manual decision rules within the automation framework of Oracle 10g.
Paul Dorsey, Dulcian
Session: 5 - 3:45 to 4:45
Application Development - Intermediate
You have ten million logical objects spread across 100 million rows in the database that have to be processed in under two hours. The processing will require an additional 20-30 million records to be created and inserted into the database. Your Java team tried to build the application in the middle tier and crashed and burned. You tried writing standard PL/SQL and the routine takes two days to execute. What do you do now? This presentation will explain how fast you can perform various operations in SQL and PL/SQL when throughput is the top priority.
Daniel Fink, 7S Consulting
Session: 2 - 10:30 to 12:00
Application Development - All
"Fix the database!" "Write better code!" If you listen closely in many IT departments, you can hear the battle cries of the development and DBA staffs. As the pressure for faster response time increases along with the variety of development languages and tools, the gap between the application developer and database engineer grows wider. This session will cover the basics of the wait interface, extended SQL trace and TKPROF, the explain plan myth, and identifying inefficient SQL operations using Method R and Throw Away. The goal is to introduce basic optimization and troubleshooting topics and to establish a common ground of understanding to enable developers and designers to interact more effectively with database administrators.
Daniel Fink, 7S Consulting
Session: 6 - 5:00 to 6:00
Application Development - All
This package was introduced with Oracle9i with the promise to easily extract the DDL for an object, schema, or entire database with simple calls. No longer did you have to perform an export or import to get poorly formatted DDL (and then have to reformat it to actually get it to work). A supplied package would do it all for you . . . if it worked properly. Unfortunately, DBMS_METADATA developed a well-deserved reputation for being poorly documented, difficult to work with, and having more than its fair share of bugs. This session will examine the basic calls, workarounds for several bugs, and how to put it all together as a flexible script.
Sue Harper, Oracle Corporation
Session: 1 - 9:00 to 10:00
Application Development - All
As a DBA or database developer, do you use a variety of tools to browse database objects, create and run SQL, and edit and debug PLSQL? Raptor is Oracle's newest graphical alternative to SQL*Plus, allowing the database developer a convenient way to perform basic tasks. With Raptor you can manage objects in Oracle databases. You can browse, create, edit, and delete (drop) database objects; create, edit, and debug SQL statements and PL/SQL code; manipulate data; export and import database objects; and create reports. You can connect to any target Oracle database schema using standard Oracle Database authentication. In this session we introduce Raptor and, using demonstrations, show the user the new functionality available today.
Steve Harris, SageLogix
Session: 3 - 1:30 to 2:00
Application Development - Advanced
The implementation of a Service-Oriented Architecture (SOA) requires a distributed architecture that can be very complicated to implement. Oracle Application Server provides an excellent platform for implementing an SOA. This presentation will address how Oracle Application Server and Oracle Portal can be optimally utilized to create an enterprise solution that addresses the key factors in building successful software solutions. This includes maximizing development technologies, testing processes, configuration management methodologies, and maintainability.
Rick Hata, Lockheed Martin
Session: 3 - 12:30 to 2:00
Application Development - Intermediate
The knee bone is connected to the elbow bone - Not quite, but let's dissect the different components of an analytic function. Let's also see how an analytic function operates within the context of the processing of an SQL statement. Once you have gained the understanding of the anatomy of an analytic function, you'll gain the knowledge to know when and how to use an analytic function. If just breaking down the anatomy of the analytic function does not provide the clarification you need to utilize analytic functions, I'll provide examples to give you that x-ray vision into the analytic function.
Patrick Holmes, IPC - The Hospitalist Company
Session: 9 - 1:00 to 2:00
Application Development - All
Dan Hotka, Training Specialist
Session: 6 - 5:00 to 6:00
Application Development - Novice
This is a live demo presentation of new functions in the latest release of the Oracle Discoverer product. The speaker is an experienced trainer who will demonstrate a variety of new and neat features of this reporting/drill-down tool. Attendees will gain valuable insights to the many features of the latest version of Oracle Discoverer 10g.
John King, King Training Resources
Session: 9 - 1:00 to 2:00
Application Development - Novice
XML has quickly become the "Esperanto" of the IT industry. Oracle has been at the forefront of incorporating XML data into its database products and Oracle 10g breaks additional new ground. In this session, attendees will learn how to store/maintain/retrieve XML data in the Oracle Database in both structured and unstructured forms. Use of the XML DB WebDAV interface will be explored to show how Oracle data may easily be shared with non-Oracle applications.
John King, King Training Resources
Session: 2 - 10:30 to 12:30
Application Development - Intermediate
The features of Oracle 10gR1 and R2 extend the capabilities of the database in many ways. Attendees are introduced to new and improved features of Oracle 10g/9i that directly impact application development. Special emphasis is placed on features that reduce development time, make development simpler, improve performance, or improve deployment. Attendees will be better equipped to create applications that take full advantage of Oracle 10g and Oracle9i.
Peter Koletzke, Quovera
Session: 7 - 9:00 to 10:00
Application Development - All
Peter Koletzke, Quovera
Session: 9 - 1:00 to 2:30
Application Development - All
This presentation explains view layer technologies and describes how to develop them using Oracle JDeveloper 10g. It reviews the principles of the MVC design pattern as a context for the view layer discussion. The presentation also discusses JSP, UIX, and JSF architectures, code libraries, coding styles, benefits and drawbacks, key features, and intended uses. In addition, it provides conclusions about which style is best for specific situations. The presentation will also demonstrate how to develop a web application using JDeveloper.
Peter Koletzke, Quovera
Session: 11 - 3:45 to 4:45
Application Development - Novice
This presentation explains some best practices for making applications run most efficiently. It discusses what to focus on when tuning queries and INSERT, UPDATE, and DELETE operations and provides tips for SQL optimization such as breaking up complex queries and using materialized views. It also describes several techniques you can use to make PL/SQL more efficient such as BULK COLLECT and FORALL. On the tools side, the presentation discusses techniques for tuning Oracle Forms applications in client/server and web deployments. In addition, the presentation mentions a number of best practices you can use to make J2EE applications run quickly, such as application module tuning parameters for Oracle's JDeveloper ADF Business Components code. Oracle's current focus on implementing database and development features based on the Java language may have you thinking that you need to learn Java. However, if you are familiar with PL/SQL, your first view of Java may be a bit discouraging because its object-oriented core makes it look very different. This presentation explains the basic concepts of and terms used in Java to PL/SQL developers who have had little or no exposure to Java. It provides an overview of the language and reviews the concepts of object orientation upon which Java is based. It also discusses the fundamental Java code structures--classes and methods--as well as control statements, exception handling, datatypes, and variables.
Peter Koletzke, Quovera
Session: 10 - 2:15 to 3:15
Application Development - Novice
James Koopmann, Pine Horse
Session: 1 - 9:00 to 10005
Application Development - Intermediate
No presentation to download.
SQL is the primary method to extract information from your database. But how many of us really feel comfortable and confident writing SQL? This presentation begins with simplistic SQL statements to form a firm foundation \ and then progressively tackles more complex SQL writing techniques. If you are new to Oracle, need a refresher on SQL, or want to see those higher level techniques in action, then this session is for you.
Steve Kosten, Raytheon Company
Session: 10 - 2:15 to 3:15
Application Development - Novice
Aspect-Oriented Programming (AOP) is a new programming technique that is gaining momentum in the industry. It is a technique that is not intended to replace Object-Oriented Programming (OO) but rather supplement it. This presentation will provide an introduction to Aspect-Oriented Programming using AspectJ and the AspectJ plug-in for JDeveloper. Code samples for applications using traditional techniques and AOP techniques will be provided.
Robert Mason, EchoStar Communications
Session: 6 - 5:00 to 6:00
Application Development - All
Aspect-Oriented Software Development (AOSD) is a new paradigm that transcends conventional Object-Oriented Software Development. This presentation explores the use of AspectJ to persist data using Oracle 10g. Topics include a brief overview of Aspect's (AOSD), database connection and transaction control with Oracle 10g, object loading and cache management, synchronization of object states with database objects, and exception handling. Since a persistence aspect has unique failure points in comparison to other types of aspects, these differences will be highlighted in the presentation. Best practices for coding objects to support AOP persistence will also be reviewed.
Gregory Matus, Greg Matus and Associates
Session: 6 - 5:00 to 6:00
Application Development - All
The transition from PL/SQL to Java is much more than just learning a new syntax; it is primarily a transition from procedural programming to object-oriented thinking. Find out what it takes to make this significant leap and why it's worth the effort.
Lynn Munsinger, Oracle Corporation
Session: 11 - 3:45 to 4:45
Application Development - All
No presentation to download.
Oracle Application Development Framework (Oracle ADF) simplifies J2EE development by minimizing the need to write code that implements design patterns and application infrastructure. Oracle ADF provides these implementations as part of the framework.
Lynn Munsinger
Session: 4 - 2:15 to 3:15
Application Development - All
Oracle JDeveloper 10g is Oracle's development environment for the next generation of J2EE-based SOA applications. JDeveloper covers the full development lifecycle from modeling to testing in a single IDE.
Lynn Munsinger
Session: 6 - 5:00 to 6:00
Application Development - All
There is no download for this presentation.
J2EE provides a platform that opens up a whole range of opportunities to Forms and Designer developers. This presentation looks at the Oracle Application Development Framework (ADF) for developers familiar with Oracle Forms and Designer.
Kevin Closson and Mogens Norgaard, Miracle
Session: 1 - 9:00 to 10:00
Application Development - All
Presentation Not Yet Available
Mogens Norgaard, Miracle
Session: 11 - 3:45 to 4:45
Application Development - Intermediate
No presentation to download.
Chris Ostrowski
Session: 2 - 10:30 to 12:00
Application Development - Intermediate
Previous versions of JDeveloper used an arduous process for developing and deploying portlets. This presentation will focus on the ease with which developers can develop and deploy portlets in the latest versions of JDeveloper and the Oracle Application Server. Attention will be paid to the JDeveloper wizards and the Application Developer Framework (ADF).
Michael Reed and Marshall Presser, Oracle Corporation
Session: 11 - 3:45 to 4:45
Application Development - Intermediate
Jon Arnold, Denver Public Schools
Session: 6 - 5:00 to 6:00
Data Warehousing - Novice
This presentation will introduce the functional components of Oracle Warehouse Builder version 10g (10.1). It will also demonstrate, step-by-step, how to build a simple mapping with some standard transformations. In addition, it will validate, deploy, and execute the mapping to extract, transform, and load data from the source to the target area.
Bradley Brown, TUSC
Session: 4 - 2:15 to 3:15
Data Warehousing - All
Real-time data warehousing requires real-time access to operational systems and to a shared repository of dimension data. Users can then use the data warehouse environment for strategic reporting and trending as well as tactical operational reporting. Some data warehouse implementations attempt to address the need for real-time reporting by introducing an "operational data store" into the architecture, which provides an integrated view of operational data. Operational data stores commonly do not store much historical data, limiting their potential usefulness. This presentation demonstrates a virtual data warehouse, which will provide you with the best of both worlds.
Brad Cowdrey, Oracle Techniques for Integrating and Querying Unstructured Data
Session: 6 - 5:00 to 6:00
Data Warehousing - All
No presentation to download.
Ron Engels, Denver Public Schools
Session: 10 - 2:15 to 3:15
Data Warehousing - All
No presentation to download.
Repository-based metadata management like that available in Oracle Warehouse Builder is clearly the way to deal with the volumes of information that is necessary to run a data warehouse environment effectively. But how do you manage the repository? The Corporate Information Factory at Denver Public Schools draws data from the district's disparate source systems into an Operational Data Store and a Data Vault before final transformations into data marts. This presentation details the practices DPS has implemented to be able to keep track and make sense of the mountains of metadata stored throughout the enterprise.
Bonnie O'Neil, PPC
Session: 8 - 10:30 to 11:30
Data Warehousing - Intermediate
No presentation to download.
Almost two decades ago professionals in the data management industry started discussing the concept that data is an asset of the enterprise - a radical thought at the time. This presentation represents a case study done with a media company that has been in the yellow page printing business for decades. Recently the CEO had publicly stated that their data was a "competitive asset," yet, a metrics or quality improvement program was not in place. Some subjects discussed are: the challenges faced by the enterprise, how data was determined as "valuable," and the critical success factors
David Fuston, IRUS Group
Session: 1 - 9:00 - 10:00
Data Warehousing - Novice
Based on implementations and project analysis of several DW/OLAP/BI systems, this presentation will offer some very practical guidelines on assessing your BI/DW readiness and chance for project success. This will entail a discussion of the underlying architecture that has been used in Oracle EDW 4.1 (Oracle Applications 11.5.8 and below), Jaros Analytics (Oracle Applications 10.7, 11.0.3, and 11i), DecisionPoint Software (Oracle Applications 10.7, 11.0.3, and 11i), Noetix NETS (Oracle Applications 10.7, 11, and 11i), and Cognos Performance Applications (Oracle Applications11 and 11i, PeopleSoft EnterpriseOne 8, and PeopleSoft World 7). During this discussion, we will contrast and compare these DW approaches to the use of Discoverer 9i and 10g, BIS (11.5.8 and below), DBI (11.5.9 and above), and the other Oracle intelligence modules.
Tim Gorman, SageLogix
Session: 8 - 10:15 to 11:45
Data Warehousing - Intermediate
Partitioning is crucial to data warehouses, but how do you use this complex functionality effectively? What other major features of Oracle does partitioning enable, and how and why? This presentation is the result of long practical experience in logical and physical database design for data warehouses, driven by the combination of business requirements and systems requirements. It will provide straight answers and solid guidelines to best utilize Oracle DW features to ensure success.
Kent Graziano, Denver Public Schools
Session: 3 - 1:30 to 2:00
Data Warehousing - Intermediate
Do you have a need to automate an effective change data capture process in an Oracle Database but you have non-Oracle source systems? Do your operational systems have no auditing or logging at all making change detection virtually impossible (without a bit by bit comparison)? This short technical session will show you how easy it is to do change data capture (CDC) against any dataset using good ol' DECODE in a view. The presenter will discuss the actual SQL code to use and explain how it works to detect changes in that data when compared to a data warehouse table.
Ralph Hughes, Ceregenics
Session: 2 - 10:30 to 12:30
Data Warehousing - Intermediate
This presentation will begin with an introduction to EAV, which stands as a valuable alternative to 3rd Normal Form and dimensional data modeling. Next we will consider how to make an EAV warehouse metadata-driven, so that ETL can automatically adapt to changes in the source data. We will then examine the crucial time and cost-saving improvements in warehouse architectures and development lifecycles that such a self-adapting ETL makes possible, finishing with a look at the real-world EAV implementations the presenter has built in the healthcare, manufacturing, and defense industries.
Niklas Iveslatt, SageLogix
Session: 3 - 12:30 to 2:00
Data Warehousing - All
Having a defined optimizer statistics management strategy and tool to implement it with is essential for running your database at maximum performance. There is a lot to optimizer statistics management and this presentation will cover best practices as well as topics like table monitoring, global statistics, partitioned tables, partitioned indexes, and statistics recovery.
Keith, Laker, Oracle Corporation
Session: 5 - 3:45 to 4:45
Data Warehousing - Intermediate
So you've designed and built a relational data warehouse. Now what? Your users are hearing about all the great things they can do with OLAP. They want to do forecasting. They want to do trend analysis, what-if analysis, and many more business-driven activities. We will discuss and show how Oracle BI Warehouse Builder 10gR2 allows you to design a complete end-to-end solution which satisfies both the infrastructure needs of the IT department and the analysis needs of the end users. In this session, we will show how you can design an OLAP system, load any data into the OLAP cubes, and enable analysis by generating example forecast measures.
Keith Laker, Oracle Corporation
Session: 10 - 2:15 to 3:15
Data Warehousing - Intermediate
We spend time and money designing, building, securing, and backing up data stores. However, we often forget that a key element of any system is the quality of the data (especially when our data comes from many different data sources). If business decisions are made on inaccurate data, these decisions turn into costly business mistakes. This session will show you how Oracle Warehouse Builder 10gR2 seamlessly blends data profling, data cleansing, and data enrichment technologies directly into the data integration process allowing you to identify, measure, and dramatically improve your data quality before it can ever impact your business.
Jeff Meyer, Dever Public Schools
Session: 10 - 2:15 to 3:15
Data Warehousing - All
No presentation to download.
Bonnie O'Neil, PPC
Session: 1 - 9:00 to 10:00
Data Warehousing - All
A large media/advertising company just went through a big conversion/migration and lots of confusion resulted concerning terms, both logical and physical. What's the best way to get people speaking the same language? Launch a dictionary quickly! Find out how you can do this and capture terms from the business people directly. Find out how we used the notion of wikipedia to do a corporate dictionary, but with an attitude: we have added Governance Lite which allows us to authorize a term. This talk will illustrate how one company launched a user-authored dictionary and is also in the process of doing the same with knowledge artifacts.
George Peck, The Ablaze Group
Session: 9 - 1:00 to 2:00
Data Warehousing - Intermediate
No presentation to download.
Compare and Contrast: How does Oracle's Business Intelligence (BI) toolset compare to industry leader Crystal Reports for reporting and analysis? This fast-paced, live-product presentation will compare Oracle Reports and Discoverer against Business Objects' latest reporting/analysis tool, Crystal Reports XI. See how the products compare in such areas as ease-of-use, flexibility, presentation, speed, and distribution scenarios. Increase your knowledge and productivity in just one hour by attending this valuable presentation.
Michael Ault, Burleson Consulting
Session: 5 - 3:45 to 4:45
Database Administration - Intermediate
This presentation highlights the "heavy hitter" issues commonly seen in Oracle databases.
Chip Briggs
Session: 8 - 10:30 to 11:30
Database Administration - All
No presentation to download.
Recovery Manager (RMAN) concepts will be described and demonstrated along with audience participation questions: configuration; hot and cold backup; various recovery scenarios, including media failure, corruption, and accidental oops (e.g., drop user, rm, truncate table, and utl_file).
Donald Burleson
Session: 11 - 3:45 to 4:45
Database Administration - Advanced
Presented by the author of High-Performance SQL Tuning by Oracle Press, this presentation is indispensable for all Oracle professionals who must understand how to adjust their CBO for optimal performance in their environment.
Donald Burleson
Session: 2 - 10:30 to 12:00
Database Administration - Advanced
Kevin Closson, PolyServe
Session: 5 - 3:45 to 4:45
Database Administration - All
No presentation to download.
Now there is scalable, modular, high performance NAS for Oracle 10g RAC and non-RAC with no single point of failure--without replication. This proof of concept shows that the new HP StorageWorks Enterprise File Server Clustered Gateway is the only scalable, highly available option when NAS is the chosen storage model for Oracle. This presentation focuses on a proof of concept of a single clustered gateway serving Oracle 10gR2 RAC, Oracle 10gR1 and Oracle9i non-RAC simultaneously to include all database files, cluster-ready services, and Oracle home and external tables. Oracle 10gR2 performance results with both OLTP and DSS workloads will be covered. With the HP Enterprise File Server Clustered Gateway, the question is no longer SAN or NAS. Depending on application needs, the customer's choice is always the right choice.
Randy Cunningham, IBM Global Services
Session: 6 - 5:00 to 6:00
Database Administration - All
Oracle developers and database administrators are frequently stymied by requirements to delete many rows from very large tables. Typical problems include extensive locking of other application updates, undo errors, lengthy runtimes, and adverse system performance. The root causes of these problems is briefly explained. Several strategies to organize delete operations for top performance and minimum contention are presented, as well as strategies that avoid or minimize the impact of a massive delete operation.
Carol Dacko, University of Michigan
Session: 7 - 9:00 to 10:00
Database Administration - All
No presentation to download.
Kirtikumar Deshpande, Verizon Information Services
Session: 6 - 5:00 to 6:00
Database Administration - All
Oracle9i Database Release 2 introduced Oracle Streams as a solution for information sharing. Using Oracle Streams you can propagate data, transactions, and user-defined events in a stream of information within a database, or from one database to another. In this session, you will learn how to use Oracle Streams for data replication in a distributed environment. We will discuss the main components of Streams, which include capture, propagation, apply, event staging, and the rules engine.
Allan Edwards, Integra Technology Consulting
Session: 3 - 1:30 to 2:00
Database Administration - All
No presentation to download.
Carel-Jan Engel, DBA!ert
Session: 2 - 10:30 to 12:00
Database Administration - Intermediat
No presentation to download.
After the dust settles from your initial disaster recovery, you need to return to business-as-usual processing as fast as possible. Your redundant site is suddenly in the limelight and needs its standby instantiated--it too needs a backup. Mistakes, more likely in the brief post-disaster periods as stress levels and pressure mount, must be avoided. Robust and s ymmetric Data Guard environment builds will help you and your team better cope with such disasters. This mini-tutorial will discuss such builds, how to monitor your high availability (HA) deployment, and how to perform switchovers and failovers in a rapid and controlled manner. Illustrations and live demonstrations are included.
Carel-Jan Engel, DBA!ert
Session: 7 - 9:00 to 10:00
Database Administration - Intermediate
No presentation to download.
Management often asks for high availability "rules of thumb" metrics with which, perhaps, they can judge their infrastructure or simply strive to adhere to. Bad news is...there aren't any. High availability (HA) is not a technology-driven solution. It's an organizational challenge. High Availability Inside Out will prepare you for your HA challenge using an HA risk matrix template, some real life HA bloopers, and provide problems for every solution until you are prepared for the lot.
John Garmany, Burleson Consulting
Session: 10 - 2:45 to 3:15
Database Administration - All
John Garmany, Burleson Consulting
Session: 3 - 1:30 to 2:00
Database Administration - All
Kyle Hailey, Embarcadero Technologies
Session: 9 - 1:00 to 2:00
Database Administration - Advanced
Of all the releases, Oracle 10g has done the most to address performance and manageability issues. Thus, it is no surprise that there are a number of new tables, views, and algorithms. This presentation will present and simplify the otherwise possibly overwhelming amount of information available and bring to the forefront the details that will impact and improve DBAs' lives for performance tuning and monitoring. Topics covered will include new statistics, wait events, time model, active session history, SQL statistics, and automated performance tuning.
Kyle Hailey, Embarcadero Technologies
Session: 11 - 3:45 to 4:45
Database Administration - Intermediate
Average Active Sessions is a natural extension of Oracle's now famous and revolutionary wait interface. Now with Oracle 10g, Enterprise Manager (EM) has a clear, easy presentation of waits via the average active session measurement. Average active session is used as the pillar from which all other tuning decisions are made in Oracle's EM 10g. Learn how this new feature works, how it relates to the wait interfaces, how it revolutionizes tuning, how it can be used for SLAs, charge back, and load balancing, and how it can be extended in the industry to other databases, operating systems, and application code.
Stephen Haisley, Oracle Corporation
Session: 1 - 9:00 to 10:00
Database Administration - Intermediate
Very little is documented or presented on how to optimize Oracle backup, restore, and recovery operations. If slowness occurs during the restoration or recovery process, it is usually under much pressure and time limitations. This presentation aims to show where the bottlenecks arise when backing up, restoring, and recovering part or all of the database. Appropriate diagnostic techniques will be shown, with some simple examples, that will highlight current slowness and why it occurs. Areas of correction will be detailed, along with how to further monitor the progress.
Dan Hotka, Training Specialist
Session: 2 - 10:30 to 12:30
Database Administration - Intermediate
This presentation will focus on things within your control when working with packaged applications where you cannot tune using traditional methods. The speaker will focus on indexing structures, how to tell if Oracle is going to use an index, and stored outlines, as well as advanced init.ora settings.
Scott Jesse, Oracle Corporation
Session: 10 - 2:15 to 3:15
Database Administration - All
Windows is one of the most popular platforms for Oracle database servers. This session will cover ways to avoid common pitfalls and provide a set of best practices for using the Oracle Database on Windows. Both RAC and single instance database deployments will be discussed. In addition, the session will talk about Oracle's support for the new Windows x64 (AMD64 and EM64T) platform.
James Koopmann, Pine Horse
Session: 3 - 12:30 to 2:00
Database Administration - Intermediate
No presentation to download.
With today's exploding world economy, multinational communication is essential. Databases must not only store different character sets but also present information in a comfortable format and order for individuals from every locale. This presentation is an introduction, but not light on content, that explores how to globalize your databases and communicate effectively across the globe. If you ever wanted to go multilingual and did not know where to start, start here. Attendees will get a picture of what globalization of a database is all about. They will walk away with the areas in Oracle that need their attention for configuration, both on the client side as well as the database server.
Bryan Merchant, Corporate Express
Session: 5 - 3:45 to 4:45
Database Administration - Intermediate
In today's ever changing IT environment, a DBA must not only know the database and application, but also about their server, storage, and network. How do you view the CPU, swapping, and blocked processes from a single command? Which tool will allow you to see disk utilization and Storage Array CPU utilization? This session will explore these and other tools along with questions DBAs will need to ask in order to continue to improve upon their skills and their overall productivity within their environment.
Timothy Mishek
Session: 7 - 9:00 to 10:00
Database Administration - Novice
Across the IT community, almost all agree that protecting the data is the most important function of a database administrator. Unfortunately, some assume that as long as the backups are running, the job is done. Backing up your database is only the beginning. This session will focus on the basics using both traditional methods and Oracle's RMAN as a complete backup solution. If you are new to database administration or an experienced IT professional needing a refresher, this session will help give you the confidence needed to prove that your backups are really working!
Jeff Needham, Scale Abilities
Session: 4 - 2:15 to 3:15
Database Administration - Advanced
No presentation to download.
Raymond Obuch, U.S. Geological Survey
Session: 2 - 10:30 to 12:30
Database Administration - Intermediate
This presentation will cover topics such as hardware configuration, Linux operating system installation and configuration, Oracle installation and configuration, ArcSDE 9 installation and configuration, and system performance. It will also give the user a "jump start" toward the migration of a Sun Solaris Oracle ArcSDE environment to a Dell Linux Oracle ArcSDE environment. In addition, this presentation will discuss the migration of thousands of ArcSDE layers into the new environment as well as performance metrics studied through ESRI's ArcGIS TOFINO tool set extension.
Raj Pal, EchoStar Satellite
Session: 3 - 12:30 to 2:00
Database Administration - Novice
RMAN is an integral part of today's Oracle database integrity. There are many options that will restore and recover the Oracle Database to a consistent state for you, but they do not offer proactive corruption checking and ease of recovery from it. This presentation tells the story of RMAN's acceptance at a large and diverse telecommunications company with dozens of mission-critical, zero-downtime applications. The presentation centers around a nearly unrecoverable disaster without RMAN to a nearly perfect recovery 1.5 years later with it.
Tanel Poder, Independent Consultant
Session: 8 - 10:15 to 11:45
Database Administration - Intermediate
Have you ever wondered whether there are additional diagnostics and performance data gathering tools available in addition to conventional 10046 tracing and V$ views in Oracle? Yes, there are-and there are many. This session concentrates on some of those additional tracing and diagnostics mechanisms, which allow us to gather detailed information about Oracle behaviour when conventional methods aren't sufficient or some specific problem needs to be solved.
Marshall Presser, Oracle Corporation
Session: 8 - 10:15 to 11:45
Database Administration - All
What's new? Plenty! While the basic product remains the same, there are many new features available in 10gR2, including the ability to use Cluster Ready Services to provide high availability for non-Oracle applications. In addition, we will explore the cluster verification utility, the load balancing advisory, enhancements to automatic storage management, cloning of RAC environments, and general performance improvements. For those not familiar with RAC or are a bit rusty, we'll start with a brief overview of the product.
Bert Scalzo, Quest Software
Session: 9 - 1:00 to 2:30
Database Administration - Intermediate
Attendees will learn a collection of tips, tricks, and techniques to optimize Oracle Server performance on LINUX. Topics include Oracle parameter file settings, LINUX kernel versions, settings, and compilation switches, plus file system and compiler options. The demo database used netted a 650 percent improvement for a 200 concurrent user, TPC benchmark. In lay terms, a six minute runtime for what had previously taken 50 - with no hardware changes. Finally, hardware versus software RAID issues are examined. Attendees should be DBAs or very senior developers familiar with both Oracle Database and operating systems management issues in either a LINUX or other UNIX environment.
Bert Scalzo, Quest Software
Session: 1 - 9:00 to 10:00
Database Administration - Advanced
This presentation will focus on the trials and tribulations encountered while recently setting up a 10 node Linux Oracle RAC cluster. Some issues discussed include optimial Linux configuration, optimal ASM configuration, optimal instance configuration, and os/database monitoring techniques. The key points being stressed are that sometimes the obvious answwers do not scale well-without some old fashioned elbow grease being applied. Attendees should be DBAs with both Oracle and Linux experience, with some RAC experience helpful.
Roger Schrag, Database Specialists
Session: 1 - 9:00 to 10:00
Database Administration - Intermediate
Oracle has a strict read-consistency model that sets it apart from other database products such as Microsoft's SQL Server. This raises the question: Just how much slower will a report run if a batch update job is running at the same time? In this presentation we will look briefly at how Oracle implements the read-consistency model, and then we will focus on quantifying the performance cost. We will look at reproducible examples, TKPROF reports, and v$ views in order to measure how much slower a query runs when the tables being read are undergoing concurrent updates. Would it be faster to run the update jobs and the report jobs sequentially instead of at the same time? You will have the tools to answer questions like this after attending this session.
Roger Schrag, Database Specialists
Session: 5 - 3:45 to 4:45
Database Administration - Intermediate
Our company uses an Oracle database and an application developed in-house to manage information regarding customer databases that we support. Agents running on our customers' servers transmit performance metric data every five minutes. Backend jobs on our server written in PL/SQL parse the data, load it into a data warehouse, and evaluate it. A web-based front end written in mod-PL/SQL allows customers and our staff to review the data and generate reports. In this presentation, we will discuss our company's experience moving this system from Oracle8i to 10g. In particular, we will look at changes in execution plans (for better or for worse), management of resources such as memory and disk I/O, and what some of the advisors in Oracle 10g had to say.
Craig Shallahamer, OraPub
Session: 9 - 1:00 to 2:00
Database Administration - All
Oracle performance analysis has come a long way in the last 20 years. First there was the "just add more resources" approach and tuning the blatantly poor SQL. Then there was ratio analysis followed by wait event analysis. Finally, response time analysis (RTA), in a way, closed the loop. What is so key about RTA is that it brought together and detailed the two elements of response time: service time and queue time. But over the past couple of years, while people talk about Oracle timing and response time analysis, they focus only on the wait interface. And this unhealthy focus on the wait interface is where the modern performance myths lie in wait.
Terry Sutton, Database Specialists
Session: 7 - 9:00 to 10:00
Database Administration - All
For years Oracle has been telling us to use the dbms_stats package instead of the analyze command to gather statistics to be used by the Oracle optimizer. But there are many options to dbms_stats, and your choice of which options to use can dramatically affect your results, both in accuracy of statistics and performance of the statistics gathering operation itself. In this presentation, we will discuss the effects of the various choices. The focus here will be on actual experience and performance, not on what the documentation says, along with detailed examples. We will examine the behavior in both Oracle9i and Oracle 10g. While, by default, statistics are gathered automatically in 10g, often the default choices are not the best route to take. Those attending the session should have some experience with gathering optimizer statistics.
Kyaw Than, Jefferson County Government
Session: 1 - 9:00 to 10:00
Database Administration - Intermediate
This presentation will show how to set up and use your Linux PC as a primary workstation for Oracle Database management and administration. Open-source software can be installed on Linux for many of the administrative tasks carried out by a DBA, and the freely available unixODBC manager, together with Oracle's Instant Client, are enablers for this technology. A working knowledge of Linux is assumed in the interests of covering more ground on the software utilities themselves.
Jon Warnick, Double Eagle Group
Session: 10 - 2:45 to 3:15
Database Administration - Intermediate
No presentation to download.
When the database machine is running at or near 100% utilization, what happens? Do users tell the DBA to "just fix it"? Does the DBA rush to add an index or collect statistics (again)? Does the DBA kill some long-running jobs? CPU usage spikes caused by large reports or runaway code can cause end users to experience slow performance and DBAs to experience brain damage. The Resource Manager allows the DBA to stop the brain damage by proactively segmenting work into higher and lower priority queues, thus allowing high-priority work to continue to perform acceptably.
Graham Wood, Oracle Corporation
Session: 4 - 2:15 to 3:15
Database Administration - All
This presentation will detail the implementation of the new Active Session History (ASH) feature in Oracle 10g and how it can be used to investigate performance problems. The presentation will include examples of both use and misuse of ASH. Can it really replace both Statspack and SQL*Trace? For the Oracle 10g DBA, sifting through diagnostic ASHes will become a important part of day-to-day work.
Graham Wood, Oracle Corporation
Session: 8 - 10:30 to 11:30
Database Administration - All
This presentation will discuss the new performance diagnosis features in Oracle 10g Release 2 that builds on the infrastructure of Release 1. Major new features include a full session history in EM, an ASH report, and an AWR Compare Period report.
Michael Mesaros, Oracle Corporation
Session: 4 - 2:15 to 3:15
Network Administration - All
Many organizations today are moving toward enterprise portals as gateways to all of their enterprise applications. To ensure portal manageability and usability, however, implementers need to give special consideration to the identity management infrastructure. For example, many organizations discover during portal deployment a requirement to consolidate user identities from a variety of directories, databases, and applications. With this identity consolidation comes the need to deploy the administrative tools required to support user self-service and delegated administration. If heterogeneous applications are to be consolidated behind the enterprise portal, a single sign-on solution that can support a variety of application environments is required. Finally, if these portals are going to be made available to users in other companies or agencies, they need to provide the ability to support modern, XML-based standards for identity federation such as SAML and Liberty.
Don Bergal, Confio Software
Session: 5 - 3:45 to 4:45
Technology Management - All
Conventional performance management and database tuning leads to finger pointing between owners and developers of Oracle and Java systems. This is due to the lack of visibility into the exact causes of bottlenecks on the tiers of Web, J2EE, and Oracle servers. Conventional technologies monitoring the JavaServer treat the database as a black box without identifying details of how Oracle impacts Java processes. This session will cover how wait-time methods can be used to track detailed end-to-end transaction performance in a multitier system, showing the interaction between Oracle databases and the Java applications they serve.
John Garmany, Burleson Consulting
Session: 1 - 9:00 to 10:00
Technology Management - All
This presentation focuses on securing your Linux server against outside attacks, while still providing access to those needing to connect. Many Oracle servers are directly connected to the internet and protecting those severs is critical. Even if you place the server behind a firewall, you must still provide access for maintenance while keeping out the bad guys. Luckily Linux and Unix provide a power utility that will do just that! Secure Shell, or ssh, allows you to access your server from the internet with an encrypted connection while insuring that the script kiddie with a password-cracking tool is kept out.
Kent Graziano, Denver Public Schools
Session: 9 - 1:00 to 2:30
Technology Management - All
Tired of crappy data models and whiney data modelers? Need to deliver a high-quality design in a short period of time? Need a better way to enforce standards? Trying to be more "agile" in our approach we have adopted another concept from the agile world (and others): peer reviews. This presentation will discuss the actual modeling and design process we follow and give you a checklist of questions to ask in any model review session. This is a "take no prisoners" approach that has left many a would-be data modeler in a withering heap, but in the end we have solid models and designs that deliver value.
Suraj Krishman, Oracle Corporation
Session: 5 - 3:45 to 4:45
Technology Management - All
No presentation to download.
Steve Lemme, Computer Associates
Session: 7 - 9:00 to 10:00
Technology Management - All
No presentation to download.
Foremost in the minds in business executives today is how to meet new regulatory compliance and corporate governance. New laws are changing the way companies collect, retain, and manage information. DBAs need to understand what is happening in the corporate business world and how it will directly impact their role.
Steve Lemme, Computer Associates
Session: 9 - 1:00 to 2:00
Technology Management - All
No presentation to download.
The complexity of managing databases has increased so significantly some are considering outsourcing as their only relief. New regulations are driving IT governance, increasing the pressure on IT as ways are sought to reduce costs and still effectively manage the myriad of databases supporting business. Auditors, consultants, ITIL, COBIT, ISO, Six Sigma - what is an Oracle DBA to do? This presentation focuses on the new business challenges, best practices approach to managing relational databases, and where and how database administrators should be educating themselves and spending their time to be successful in business.
Bonnie O'Neil, PPC
Session: 4 - 2:15 to 3:15
Technology Management - Intermediate
No presentation to download.
Mark Pelzel, TUSC
Session: 5 - 3:45 to 4:45
Technology Management - All
No presentation to download.
Oracle Collaboration Suite is a tightly-intertwined combination of Oracle's most effective technologies. Leveraging database technologies, application server components, industry standard protocols, and collaborative devices, the suite delivers unique value to any business practice when implemented with an eye on strategic goals. A greater understanding of all the components of OCS will enable businesses to evolve to higher levels of efficiency.
Craig Shallahamer, OraPub
Session: 2 - 10:30 to 12:30
Technology Management - All
When a bunch of new users are going to be added to a system, it's the DBA who is quickly asked, "That's not going to be a problem, is it?" And when performance begins to degrade, it's the DBA who hears about it...and was supposed to prevent it. This presentation will lead you through the process of understanding the essentials of forecasting performance. As you'll discover, you don't have to be a math whiz to forecast Oracle performance. All it takes is some basic knowledge and a little time.
Bradley Brown, TUSC
Session: 6 - 5:00 to 6:00
Web, Internet/Intranet - All
JDeveloper 10g is an amazing development environment. Each new version gets closer to rivaling Oracle Forms. Now with the Oracle Application Developer Framework (ADF), which includes TopLink and Struts, you can quickly and easily develop a GUI/HTML-based web application using this point-and-click, drag-and-drop development tool. In one hour you'll learn how to quickly develop an application using JDeveloper 10g.
Jeff Eberhard, Triumph Gear Systems
Session: 4 - 2:15 to 3:15
Web, Internet/Intranet - Novice
Energize your users' data by deploying it to the web. Develop and deploy database-centric web applications using Oracle's HTML DB. This presentation is a beginner's view of HTML DB, covering the basics of installing and configuring HTML DB. It will also demonstrate how development is done using the browser interface. Examples of finished projects using HTML DB will be given.
Debra Elliott
Session: 7 - 9:00 to 10:00
Web, Internet/Intranet - Intermediate
No presentation to download.
Poudre Valley Health System uses Oracle Portal version 9.0.4.1 as the web infrastructure for an internal suite of applications as well as the external Health System web site. For both internal and external content it is desirable to know both usage and performance statistics. However, with the introduction of Oracle9iAS WebCache in 9iAS Portal Release 2, all of the prebuilt reporting and charting portlets were removed from Portal. In the interim, Oracle has published technical notes on how to make use of data collected by the performance logging service of mod_plsql. This presentation will outline the steps taken by PVHS to implement mod_plsql performance monitoring and how it has been customized to capture usage statistics for both our internal and external sites.
Susan Lee
Session: 3 - 1:30 to 2:00
Web, Internet/Intranet - Novice
Application Server 10g configuration can be a nightmare for the uninitiated. Reinstalling is not necessarily the answer after all! This presentation will cover basic architecture and configuration of Oracle Application Server 10g, focusing on how the various components communicate with each other. Security configurations using SSL and non-SSL are described in both single- and multi-tier environments.
Dustin Marx and William Jackson
Session: 4 - 2:15 to 3:15
Web, Internet/Intranet - All
Ruby is a language that has been around for many years, but recent excitement over the Rails framework has produced new and renewed interest in it. This presentation will introduce Ruby on Rails and how this language and framework can be used to rapidly produce dynamic web sites. Special attention will be paid to setting up Rails to work with an Oracle Database and accessing the Oracle Database with Rails and its Active Record subframework. Other topics that will also be discussed include using convention rather than configuration, overriding Rails' conventions for use with legacy database schemas, using and overriding Rails' scaffolding, and Rails' support for easier use of XMLHttpRequest (often called AJAX or Asynchronous JavaScript and XML).
Chris Ostrowski, TUSC
Session: 7 - 9:00 to 10:00
Web, Internet/Intranet - Intermediate
This presentation will explore the latest features of Oracle's Application Server including new management features, functional enhancements, and Oracle's focus on Service-Oriented Architecture (SOA). If internet access can be provided, a live demonstration of new features will also be shown.
Chris Ostrowski
Session: 10 - 2:45 to 3:15
Web, Internet/Intranet - Novice
OracleAS Instant Portal gives end users the ability to create and implement professional looking portals quickly, easily, and securely. This presentation will introduce you to this tool and show you how quickly you can implement a Portal.
Olivier Ricordel, Oracle Corporation
Session: 4 - 2:15 to 3:15
Web, Internet/Intranet - All
One of the most powerful ways to extend portals is using Java and web services. Oracle Portal allows developers of all levels to leverage the latest web technologies. In this session, you will learn how Oracle Portal empowers business users to pull data into their portals from sources such as web services and XML, and visualize them without limits. We will demonstrate how easily you can integrate MVC-based applications built with Struts and the Application Development Framework (ADF) into your portal.
Harry Wong
Session: 6 - 5:00 to 6:00
Web, Internet/Intranet - All
No presentation to download.
Creating, managing, and publishing information through your portal is more important than ever, as self-service and professionally managed portals become increasingly interconnected. This session reveals the powerful content management and templating features coming in the next release of Oracle Portal. Rich with demonstrations that illustrate Oracle Portal's new features in action, this presentation shows how you can use the new functionality to satisfy real-life use case requirements.
Vendors have no presentations to download.
Paul Cyphers
Session: 6 - 5:00 to 6:00
Business Process Execution Language (BPEL)--Wave of the Future
Virgil Flack
Session: 5 - 3:45 to 4:45
Maintaining Your Oracle Applications in Less Time with the Simplified ACME Approach
Alex Givens
Session: 1 - 9:00 to 10:00
Eliminating Bottlenecks in theFinancial Period Close Process
Chris A. Johnson
Session: 7 - 9:00 to 10:00
Disk is the New Tape ... Almost
Ben Scheerer
Session: 8 - 10:30 to 11:30
Take command of Your Database Infrastructure--Introducing the Latest in
Database Management Technology from CA
Chris Sheik
Session: 9 - 1:00 to 2:00
Establishing Functional Business Policies to Manage and Retain Oracle Data
Bill Nugent and Jennifer Sikora
Session: 10 - 2:15 to 3:15
High Availability Solutions for Oracle Databases Using GoldenGate Software
Randy Cleveland and Janna Whitcomb
Session: 4 - 2:15 to 3:15
Oracle Applications Run Better with F5