Training Days 2005 Presentation Summaries

Click on a link below to go to session category or presenter.

________________________________________________________________________________________________________________________

SESSION CATEGORIES:
Application Design
Application Development
Data Warehousing
Database Administration
Enterprise Systems
Professional Development
Technology Management
Web Internet/Intranet

OTHER CATEGORIES:
Keynote Speakers
Presenters by Name
Vendor Presentations

________________________________________________________________________________________________________________________

Keynote Speakers

 

Back-to-Top  or Names

Thomas Kurian
Session: Keynote
Oracle Corporation

Oracle Application Server 10g   Keynote Speaker  

This presentation will provide a detailed technical overview of the new features in Oracle Application Server and Internet Developer Suite 10g Release 2, the benefits they offer customers, and how customers can upgrade to Release 2. The session covers new features for J2EE, web services, enterprise portals, business process automation, security and identity management, wireless and RFID, forms and reports, and business intelligence and analytics. Understand how you can deploy and manage enterprise applications using grid computing technology and learn technical details of how to best utilize Release 2 with your Oracle database. The session also provides best practices for deploying your Application Server on the Windows and Linux operating systems and in a Microsoft .NET environment.

Thomas Kurian is senior vice president of the Oracle Server Technologies Division responsible for the research, development, and delivery of Oracle Application Server 10g for Oracle Corporation. He is responsible for shaping Oracle's first Application Server for the grid, including all technological aspects of the product development, product release process, product management, and business development. Thomas has been with Oracle for more than 7 years, holding various product management and development positions in Oracle's Server Technologies division. He holds a B.S.E. degree in electrical engineering, summa cum laude, from Princeton University and an M.B.A from Stanford University's Graduate School of Business. He serves as an advisory member on the boards of several international venture funds and software companies.

 

Back-to-Top  or Names

Jonathan Lewis
Session: Keynote
JL Computer Consultancy

Presentation Not Yet Available

Justification IS Required   Keynote Speaker  

Mistakes cost money. But with good research you can avoid the worst mistakes and realize big savings in time and money. So why is it so hard to find good information about Oracle in the public domain? How is it possible for so many people to keep repeating old errors so frequently? In this presentation, Jonathan Lewis will be discussing the problems of maintaining the balance between blind faith and fanatic skepticism.

Jonathan Lewis is a freelance consultant with more than 16 years of experience with the Oracle RDBMS. He has an international reputation as an expert in the workings of the database engine, and has been called in to deal with design or troubleshooting issues in most parts of the world. Jonathan is the author of Practical Oracle 8i-still one of the better books about how Oracle works despite being two versions out of date-and has also contributed to a couple of other books on Oracle. Apart from writing, Jonathan also presents single-day tutorials on various aspects of Oracle, a three-day intensive seminar on using Oracle effectively, and numerous short presentations to user groups around the world. He runs a web site containing the "Co-operative Oracle Users' FAQ," where most of his published material eventually arrives.

 

________________________________________________________________________________________________________________________

Presenters by Name

Back-to-Top

PRESENTERS:    Albach | Albach | Aliminatic | Ault | Ault/Burleson | Beresniewicz | Bergal | Bich | Briggs | Brown | Brown | Brown | Burleson | Burleson | Burleson | Burleson/Ault | Caffrey | Conn | Cowdrey | Cowdrey | Cowdrey/Hicsasmaz | Cunningham | Dacko | Deshpande | Dorsey | Dorsey | Eberhard | Engel | Engel | Engels | Fryman/O'Neil | Fuston | Fuston | Garmany | Garmany | Gautham/Niemiec | Givens | Goodman | Gorman | Gorman/Iveslatt | Graziano | Haba | Haisley | Harper | Harper | Harris | Harris | Hata | Hicsasmaz/Cowdrey | Hotka | Hotka | Hotka | Hotsinpiller | Hoxworth | Hughes | Hughes | Hutsell | Illingsworth | Inmon | Iveslatt/Gorman | Jackson | Jeunnette | Keller | Ketchie | Ketchie | King | King | King | Koletzke | Koletzke | Koletzke | Koopmann | Kosten/Marx | Kumar | Kurian | Larson | Lewis | Lewis | Lewis | Loewenthal | Lokitz | Maresh | Maresh | Martin | Marx | Marx/Kosten | McNeill | Meyer | Meyer | Meyer | Millsap | Mishek | Murphy | Niemiec | Niemiec/Gautham | Norgaard | Norgaard | O'Brien | O'Neil | Peck | Phu | Poder | Poder | Presser | Rajan | Rajan | Rajan | Ray | Schrag | Schrag | Still | Sutton | Swilley | Than | Thater | Thater | Thater/Wells | Tiller | Walker | Wells/Thater | Zaragoza

________________________________________________________________________________________________________________________

 

Application Design

 

Back-to-Top  or Names

Bradley Brown
Session: 9 - 1:30 to 2:00
Application Design - All

The Power of XML with Oracle

You've surely heard a lot about XML. Get ready to understand its power with XSU, XSQL, and XSLT. In this presentation you will 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. Join us-and feel the power. Oracle 10gAS provides a powerful utility to help you generate XML straight from data in your Oracle database-the XSQL processor. XML style sheets (a.k.a. XSLT with a file extension of XSL) allow you to manipulate XML into various usable forms. This presentation demonstrates just how easy it is to extract data and manipulate it into a variety of output formats.

 

Back-to-Top  or Names

Donald Burleson
Session: 5 - 3:45 to 4:45
Application Design - All

Oracle 10g Wait Event Tuning with the Automated Session History Tables

Oracle 10g has greatly improved the wait event information in Oracle 10g, providing the Oracle professional with an unparalleled opportunity for detecting and correcting database bottlenecks. This presentation will show the internal structures of the ASH tables and highlight the important wait events within the tables. Attendees will learn simple scripts for identifying the top wait events over time, how to quickly drill down to find the cause of the bottleneck, and how to perform time-series wait event analysis. This presentation is indispensable for the Oracle professional who wants to know how to use ASH to automate the tedium of manual monitoring and repair of wait event conditions.

 

Back-to-Top  or Names

Paul Dorsey
Session: 1 - 9:00 to 10:00
Application Design - Intermediate

The Object-Oriented SDLC and JDeveloper

JDeveloper is Oracle's flagship product for designing and building J2EE-based systems using OO design principles. So, what is the OO SDLC? How should the traditional OO software development lifecycle process be modified for the design of relational database systems? Merging OO and relational theory means that we are now building a new kind of system. Database design should be consistent with OO development but is more than just a persistent copy of the classes. What impact do the capabilities of JDeveloper (specifically ADF BC) have on the process? This presentation will address these questions and attempt to provide some answers and guidance for developers using JDeveloper to build object-oriented systems.

 

Back-to-Top  or Names

Greg Keller
Session: 12 - 5:00 to 6:00
Application Design - All

Leveraging Models for Services Oriented Data Integration

Business success depends on accurate, relevant, and readily accessible data. The demands on data professionals continue to grow with the increasing complexity of IT environments and exploding data volumes. To meet these increasing challenges, data professionals need an arsenal of next-generation solutions that facilitate proficient metadata use and rapid data integration. If data integration becomes a service within the IT infrastructure, data from disparate sources can be integrated and made available on-demand. A service-oriented approach not only accelerates data integration, but also captures and documents associated processes and operational metrics, easing the management burdens on IT organizations. Please join Embarcadero Technologies along with your peers for a free seminar and find out how to:

• Effectively use metadata to implement a model-driven data architecture
• Use models to improve collaboration between business and technology teams allowing technology to better facilitate business needs
• Drastically reduce the complexity of data integration by coupling data and its metadata
• Turn data integration into a service within your infrastructure making the process traceable and auditable
• Increase automation to reduce repeated tasks and introduction of human-errors through standards-based technologies

 

Back-to-Top  or Names

Peter Koletzke
Session: 3 - 1:30 to 2:00
Application Design - Novice

Top Tips for Oracle Designer

Oracle Designer provides an incredibly rich repository with elements you can use to store information about a development project. However, training and experience are required to fully understand Designer and overcome its huge learning curve. In addition, it helps to have a plan for using the product as well as practical techniques at your fingertips. This presentation will discuss and demonstrate top techniques which best maximize effectiveness as you work with Oracle Designer. Included are tips for how to learn the product, how to plan and strategize for a particular development need, how to run Designer utilities from the command line, and how to get the most out of the diagrammers and the Design Editor. The techniques mentioned in this presentation are equally applicable to Designer versions 2.1 through 10g.

 

Application Development

 

Back-to-Top  or Names

Ron Bich
Session: 12 - 5:00 to 6:00
Application Development - Novice

Oracle Discoverer V4
The Basics Uncovered and Administration Setup

Are you using Discoverer? Are you planning on using Discoverer? If you are, then join us for a tour on creating your first Discovery report using the Web Discoverer Desktop version. You will learn the keywords and the available help for creating your first report. After completing the report, we will look at examples of the Crosstab and Page-Detail Reports. Additional information on setting up an end-user layer and business area are included for the administration of Discoverer.

 

Back-to-Top  or Names

Chip Briggs
Session: 11 - 3:45 to 4:45
Application Development - All

Oracle 10g New SQL Features (with Demos)

The Oracle 10g new SQL features will be explained and demonstrated with audience participation questions. The presentation will cover regular expressions, model clause, partition outer joins, native numbers, connect by enhancements, collection type enhancements, MERGE enhancements, FLASHBACK enhancements, PURGE, SELECT versions, data pump, and SQL*Plus enhancements.

 

Back-to-Top  or Names

Bradley Brown
Session: 12 - 5:00 to 6:00
Application Development - All

Quick Web Development using JDeveloper 10g

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 this presentation, you will learn how to quickly develop an application using JDeveloper 10g.

 

Back-to-Top  or Names

Donald Burleson and Mike Ault
Session: 8 - 10:30 to 12:00
Application Development - All

Oracle 10g SQL Tuning Secrets

This presentation will look at real-world techniques for improving the speed of SQL queries with a focus on new Oracle 10g features. Topics will include new Oracle parameters that affect SQL performance, the use of hints to change SQL execution plans, SQL queries in more efficient forms, use of advanced techniques such as materialized views, replacing SQL with PL/SQL, the new automated CBO statistics collection; and the new Oracle 10g CPU costing approach. Attendees will see actual case studies to illustrate the performance differences with these approaches to SQL tuning and learn proven SQL tuning secrets that ensure optimal SQL execution.

 

Back-to-Top  or Names

Melanie Caffrey
Session: 1 - 9:00 to 10:00
Application Development - Novice

Blowing the Whistle on REF Cursors, Implicit Cursors, and Native Dynamic SQL: When and Why Each of These PL/SQL Constructs Comes In Handy

With increased numbers and types of client applications and interfaces, cursors are not just for simple procedural processing any more. REF cursors have given us the ability to avoid a lot of repetitive code we would otherwise have in order to process more than one cursor. Native Dynamic SQL (NDS) is used whenever the query isn't known until runtime, however, unlike its predecessor, DBMS_SQL, NDS does not permit array processing (though there are workarounds for this situation). This presentation provides an introductory overview to each type of PL/SQL construct. Tips and techniques are provided through lecture and sample code.

 

Back-to-Top  or Names

Paul Dorsey
Session: 7 - 9:00 to 10:00
Application Development - Intermediate

Avoiding Land Mines As You "Struts Your Stuff" Through J2EE Development Using JDeveloper

Struts provides an excellent architecture for managing web application logic. JDeveloper 10g has greatly simplified the process of incorporating Struts into your application development environment. Oracle has extended Struts to work seamlessly with its application development framework (ADF). This presentation will provide the basics of the Struts framework and how Oracle has extended Struts to work with the ADF. This architecture is quite powerful, but it is neither particularly intuitive, nor easy to learn; tips will be included to help participants avoid the pitfalls associated with using this new technology. Vendor Presentation - Quest Software

 

Back-to-Top  or Names

John Garmany
Session: 4 - 2:15 to 3:15
Application Development - Intermediate

Put Your Web Cache to Work!

Come hear how your application can utilize the incredible capabilities of the Oracle Web Cache. Caching web pages is just the start. Take the load off your application servers and databases!

 

Back-to-Top  or Names

Sue Harper
Session: 4 - 2:15 to 3:15
Application Development - Intermediate

Visual and Declarative J2EE Development with Oracle JDeveloper 10g and Oracle ADF

Oracle JDeveloper 10g introduces ADF, an application development framework that dramatically increases developer productivity and simplifies end-to-end application development. The framework helps developers create J2EE applications by solving business problems using a visual and declarative environment, bringing the power of J2EE to all developers.

 

Back-to-Top  or Names

Sue Harper
Session: 10 - 2:15 to 3:15
Application Development - Intermediate

Oracle JDeveloper for Database Developers and DBAs

Oracle JDeveloper 10g offers support to database developers, DBAs, and application developers alike. This presentation will explore online and off line database development using JDeveloper 10g. Online support includes creating database objects, editing and compiling PL/SQL code, running and debugging PL/SQL and Java stored procedures and more, while off line features also include database modeling.

 

Back-to-Top  or Names

Steve Harris
Session: 1 - 9:00 to 10:00
Application Development - Novice

Oracle Portal Development and Deployment Methodology for Success

Key factors in building a successful software solutions include using the right technology during development, having good testing processes, having a complete deployment and configuration management plan, and finally after it has gone to production having a maintainance plan. This session will discuss using a portal server to create an enterprise application that addresses all of the key development factors. By using a portal server to create our enterprise application we will be able to assemble functionality through loosely-coupled providers.

 

Back-to-Top  or Names

Steve Harris
Session: 9 - 1:30 to 2:00
Application Development - Novice

Oracle Portal Tip

This presentation provides the latest tip for Oracle Portal based on experience.

 

Back-to-Top  or Names

Rick Hata
Session: 9 - 1:30 to 2:00
Application Development - Intermediate

Analytic SQL Functions-Teaching an Old Dog New Tricks

Single row aggregation SQL functionality has been available for quite some time but multirow aggregation functionality using analytic functions has only been available since the Oracle8i database release. May of these hidden treats have been neglected and underutilized. This presentation will provide an explanation for several of the analytic SQL functions. It will also provide practical examples that may help simplify your approach to a solution or provide a new trick for an old nagging issue.

 

Back-to-Top  or Names

Dan Hotka
Session: 2 - 10:30 to 12:00
Application Development - Advanced

Advanced Index Topics

This presentation will go into considerable detail on how indexes work and which indexes are best for which application. The presenter is an Oracle expert who has authored/coauthored over nine books. It will explain how to design a good table/index relationship. This is a "must see" presentation for users doing any kind of Oracle performance tuning.

 

Back-to-Top  or Names

Dan Hotka
Session: 9 - 1:30 to 2:00
Application Development - Intermediate

Oracle/Unix Scripting Tips and Techniques

This presentation will illustrate many features of shell programming that are useful in the Oracle RDBMS world. It will demonstrate how to mix Oracle SUBSTR/INSTR to provide a unique string processing solution, how to use SQL to create SQL, and how to create datadriven SQL scripts. It will review a number of popular Unix commands and illustrate how to mix them with Oracle to provide unique solutions.

 

Back-to-Top  or Names

Judi Hotsinpiller
Session: 11 - 3:45 to 4:45
Application Development - Novice

Oracle9i PL/SQL Fundamentals

This presentation will teach attendees the basic principles of PL/SQL. You will learn how to create simple PL/SQL programs and how to use variable declaration, cursors, conditional logic, CASE, and Loops. Basic scope and exception handling will also be discussed, along with new features in Oracle9i and how to merge. Sample programs and code will be given to show practical applications of the skill set.

 

Back-to-Top  or Names

John King
Session: 2 - 10:30 to 12:00
Application Development - Novice

Oracle 10g/9i for Developers: What You Need to Know

Attendees will be introduced to the new and improved features of Oracle 10g that directly impact application development and some of the more important Oracle9i features they might have missed. Special emphasis is placed on features that can reduce development time, make development simpler, improve performance, or speed deployment. Specific topics include: new SQL statements, case/accent-insensitive query, regular expressions, expanded LOB storage, new data types (BINARY_FLOAT, BINARY_DOUBLE, SDO_GEORASTER), new statistical functions, Model clause, recycle bin, ISO Join options, CASE statement, outer join improvements, XML support, external tables, MERGE, object improvements, and expanded Java capabilities.

 

Back-to-Top  or Names

Steve Kosten/Dustin Marx
Session: 11 - 3:45 to 4:45
Application Development - Novice

An Introduction to Aspect-Oriented Programming (Using an AspectJ Plugin for JDeveloper)

Aspect-Oriented Programming (AOP), a new programming technique that is gaining momentum, is not intended to replace Object-Oriented Programming (OO) but to supplement it. Often when developing OO classes, the core functionality of a class can be defined with relatively few lines of code. The code then becomes more complex once "secondary requirements" are levied. While necessary for the class, the secondary requirements (cross-cutting concerns) are not the reason that the class is written. AOP attempts to modularize these cross-cutting concerns, making the code simpler to read, to maintain, and to develop. This presentation will provide an introduction to Aspect-Oriented Programming using AspectJ and the AspectJ plug-in for JDeveloper.

 

Back-to-Top  or Names

Justin Lokitz
Session: 7 - 9:00 to 10:00
Application Development - All

Oracle Spatial and Location Technologies

This presentation will focus on Oracle spatial and Oracle locator, which make location a native type within the Oracle9i database. Oracle locator is a feature of Oracle9i Standard and Enterprise Editions that provides spatial object type storage, indexing, and operations to support a variety of location-based services (LBS) and 3rd party GIS solutions. Oracle spatial is an option for Oracle9i Enterprise Edition that provides advanced spatial features to support high-end GIS and LBS solutions. It will also discuss MapViewer, an Oracle AS Java component used for map rendering and viewing geospatial data managed by Oracle spatial or locator.

 

Back-to-Top  or Names

Dustin Marx
Session: 6 - 5:00 to 6:00
Application Development - All

Better Java with JDeveloper 10g

JDeveloper 10g offers several tools developers can use to improve the maintainability, readability, and performance of the Java applications they write. These tools include the Memory, Execution, and Event Profilers as well as CodeCoach, Code Metrics, and Code Audit. This presentation will discuss each of these tools and the part each tool plays in developing more efficient and higher quality Java code. Various Java best practices, coding standards, and conventions will be discussed to better illustrate how JDeveloper enables developers to write and maintain Java code that meets these standards and conventions. The presentation will include a discussion of best practices related to performance optimization and code analysis and improvement and sample code.

 

Back-to-Top  or Names

Jennifer McNeill
Session: 4 - 2:15 to 3:15
Application Development - All

Converting Oracle Forms and PL/SQL to J2EE

To understand if migration makes sense, companies need to be aware of the advantages and disadvantages of moving applications from Oracle Forms to new open-standard technologies. This presentation will discuss those advantages and disadvantages to help companies make appropriate migration decisions.

 

Back-to-Top  or Names

Cary Millsap
Session: 10 - 2:15 to 3:15
Application Development - Intermediate

Profiling Oracle: How It Works

Conventional Oracle "tuning" methods are outrageously complex, and they don't work. For more than three decades, good software developers have known how to optimize computer-executed tasks using a simple method that works every time. This presentation will describe how to use this method in an Oracle environment and demonstrate the method's use with an example

 

Back-to-Top  or Names

Sri Rajan
Session: 2 - 10:30 to 12:00
Application Development - Intermediate

Reengineering Oracle Forms Business Logic for SOA Through J2EE and Web Services

There is no download for this presentation.

Mission-critical Oracle Forms applications represent an organization's information assets by capturing business functions in complex business logic that have matured over many tens to hundreds of person-years. Historically, this trusted business logic has been tightly coupled with the Oracle Forms framework, cross-module intercommunication, and an organization's implicit workflow as implemented through constructs intrinsic to the programming model of Oracle Forms. Newer IT initiatives, such as Service-Oriented Architectures (SOA) and web services represent an innovative approach to expose module and application-specific business logic for standards-based re-use for new J2EE-architected applications. This session will explore the opportunity of standards-based SOA in the context of proven, in-production Oracle Forms applications.

 

Back-to-Top  or Names

Sri Rajan
Session: 9 - 1:30 to 2:00
Application Development - Intermediate

Applied Testing Architectures to Prove Correctness of Enterprise J2EE Applications

Presentation Not Yet Available

The traditional 2-tier, OLTP, rich-client applications adopted by nearly all Global 1000 enterprises in the 1990s are now being leveraged to support N-tier J2EE technologies. The shift of enterprise computing from client/server to N-tier J2EE has provided vastly improved component reusability for better business agility. However, N-tier J2EE architectures have imposed increasing strains on testing methodologies, architectures, and programs to prove the functional validity of new J2EE applications that conform to Service- Oriented Architectures (SOA). This presentation will examine popular testing architectures being considered today for both thinclient and thick-client N-tier J2EE architectures and apply these techniques to a practical example of testing Oracle Forms applications reengineered for pure J2EE architecture.

 

Back-to-Top  or Names

Steven Ray
Session: 10 - 2:15 to 3:15
Application Development - Intermediate

PL/SQL Debugging: Going Beyond DBMS_OUTPUT

There are several ways to debug PL/SQL. One popular way presented in many books is to use DBMS_OUTPUT. Unfortunately, there are several limitations to this method. This presentation will show a better kind of DBMS_OUTPUT with far fewer restrictions.

 

Back-to-Top  or Names

Jeff Walker
Session: 9 - 1:30 to 2:00
Application Development - All

21st Century Applications

We stand at the threshold of the greatest growth in software history. Extraordinary innovation is about to unleash a new generation of applications - launching a near 100% replacement cycle for existing legacy systems. This next applications generation will change commerce and businesses globally and the financial sector will be the epicenter. Those who are first to embrace 21st Century Applications will have a decided competitive advantage

 

Data Warehousing

 

Back-to-Top  or Names

Brad Cowdrey
Session: 6 - 5:00 to 6:00
Data Warehousing - All

Data Warehousing 101

The concepts, development, and uses of a data warehouse are somewhat different than those of a traditional application. This presentation will explore the terminology and elements of a data warehouse from methodologies to star schemas to "type 2" dimensions. In addition, it will cover the basics of the way these systems are designed, developed, deployed, and used. With this background, attendees will obtain a better understanding of the terminology, characteristics, development approaches, and applications of warehouse-related solutions.

 

Back-to-Top  or Names

Brad Cowdrey
Session: 11 - 3:45 to 4:45
Data Warehousing - All

Oracle SQL Analytic Features - All

Oracle provides a set of analytic SQL features that can be applied to the data warehouse and other reporting environments with ease. Once the features are demystified they become very useful tools in the business intelligence environment. This presentation will explore each feature in detail using real-world examples that include syntax, behavior, and performance (where appropriate). The results of the examples, combined with a solid understanding of the data in a data warehouse, will allow attendees to apply strategies and approaches to leverage the new SQL analytic features.

 

Back-to-Top  or Names

Ron Engels
Session: 7 - 9:00 to 10:00
Data Warehousing - All

Son of Big Green Thingy - All

Building the infrastructure to support an enterprise data warehouse can be a daunting task. But once a solid foundation is in place, your organization will be well situated to create flexible, extensible structures that meet not its immediate information needs but its future needs as well. This presentation will review the foundation the Denver Public Schools developed for its data warehouse initiative and present the modifications and additions the district has made to its infrastructure as the project has developed. This is a nuts-and-bolts presentation that delves into the specific Oracle tools used to develop and manage each process, giving concrete examples and demonstrations where appropriate.

 

Back-to-Top  or Names

Tim Gorman
Session: 3 - 1:30 to 2:00
Data Warehousing - Intermediate

Scaling to Infinity-Partitioning Data Warehouses in Oracle

Partitioning is crucial to data warehouses, but how do you decide how to partition? This presentation is the result of a lot of practical experience in 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 the crucial features to ensure data warehousing success. Data warehouses that utilize partitioning effectively often succeed, while data warehouses that are not designed to use partitioning effectively often die painfully.

 

Back-to-Top  or Names

Kent Graziano
Session: 2 - 10:30 - 12:00
Data Warehousing - Advanced

Agile Methods and Data Warehousing

Most people will agree that data warehousing and business intelligence projects take too long to deliver tangible results. Often by the time a solution is in place, the business needs have changed. This presentation will attempt to look at some of the principles behind the Agile Manifesto and see how they might be applied in the context of a traditional data warehouse project. The goal is to determine a method or methods to get a more rapid (2-4 weeks) delivery of portions of an enterprise data warehouse architecture.

 

Back-to-Top  or Names

Hasan Hicsasmaz and Brad Cowdrey
Session: 3 - 1:30 to 2:00
Data Warehousing - All

Data Mining Options in Oracle 10g

Oracle 10g provides a little used, but powerful, set of Oracle data mining capabilities (ODM) built into the off-the-shelf Enterprise product. ODM allows complex data mining steps such as data exploration, data preparation, data analysis, model building, and model scoring to take place within the database. This presentation will demonstrate the ODM options available and apply the ODM techniques to several real-world and simulated data sets.

 

Back-to-Top  or Names

Ralph Hughes
Session: 8 - 10:30 to 12:00
Data Warehousing - Intermediate

Optimal Data Architecture for Clinical Data Warehouses

Biotech is widely expected to be a major growth industry in the coming century, and the clinical trials that provide the source data for their regulatory submissions to market new drugs are rapidly evolving. How do you warehouse source data that never stops changing? This challenge can be met with a little-used data abstraction technique called entity-attribute-value (EVA). This presentation will introduce the EVA data modeling paradigm, explore its ramification upon the technical and business architectures of a warehouse project, and present the results of a benchmark project built using Oracle 10g. It will also discuss how the EVA architecture could be applied to some other important and more common warehousing challenges.

 

Back-to-Top  or Names

Steve Illingsworth
Session: 1 - 9:00 to 10:00
Data Warehousing - All

Get the Bigger Picture with OLAP-Enabled Oracle BI 10g - Unified, Strategic, and Extensible

This presentation will be a demonstration of the latest Oracle technology (including prerelease software) used to build a complete business intelligence system including extraction, transformation, and loading of data, construction of OLAP and relational targets, ad-hoc query and analysis of relational and OLAP data, the construction of a business intelligence dashboard (Portal), and enterprise reporting. Attendees will also see query and analysis directly from Microsoft Excel.

 

Back-to-Top  or Names

Bill Inmon
Session: 8 - 10:30 to 12:00
Data Warehousing - All

Bridging the Gap Between Structured and Unstructured Data - All

For years now, there have been two types of systems-unstructured systems and structured systems. In recent days, the notion of bridging the gap has become popular. By integrating structured and unstructured data, a whole new world of possibilities opens up. This presentation is about those possibilities and the technical issues surrounding them.

 

Back-to-Top  or Names

Niklas Iveslatt/Tim Gorman
Session: 10 - 2:15 to 3:15
Data Warehousing - Intermediate

Using STATSPACK as a Performance DW

STATSPACK has been unfairly maligned due to the single report that is provided with it. In fact, it is a powerful versatile performance management tool capable of far more than what that single report provides. Like a data warehouse, the time-variant data in the STATSPACK repository can be mined in a variety of manners to analyze trends and identify problems and anomalies. As with a data warehouse, the perspective is high-level, but for some problems the data is sufficient for a solution. For most other problems, the data is only sufficient to point the way toward a solution. As with a data warehouse, data is transformed into information. This presentation shows discusses very briefly how STATSPACK should be operated, and then delves mostly into how analysis can be performed. The amount of information stored within STATSPACK should be an eye-opener for everyone.

 

Back-to-Top  or Names

Mark Ketchie
Session: 3 - 1:30 to 2:00
Data Warehousing - All

Leveraging Master-to-Master Replication for Efficient Workload Balancing and Data Distribution - All

This session will discuss how to reduce system outage time and costs by easily and cost-effectively distributing large Oracle data volumes and workloads across a number of masters and distributed database applications. Attendees will learn why master-to-master topology wins over other replication methods, how to rapidly put master-to-master replication into practice, how to overcome the challenges of migrating to a master-to-master solution, and the criteria for selecting a master-to-master replication solution.

 

Back-to-Top  or Names

Mark Ketchie
Session: 9 - 1:30 to 2:00
Data Warehousing - All

The Advantages and Disadvantages of Block-based and Transaction-based Replication

With Oracle playing a greater role in SAN environments as a result of recent connectivity enhancements relating to fiber optics, transaction-based replication coupled with block-based replication is fast becoming the solution of choice for many customers. This session will discuss how block-based and transaction-based replication complement one another, which situations call for blockbased or transaction-based replication, and the advantages and disadvantages of block-based and transaction-based replication.

 

Back-to-Top  or Names

John King
Session: - 1:30 to 2:00
Data Warehousing - Intermediate

No Bikinis? Working with SQL's Model - Intermediate

Oracle 10g adds the SQL Model clause making complex calculations easier to create and use. Model is an extension to the SQL select statement defining a multidimensional array by mapping query columns into three groups: partition, dimension, and measure columns. Without Model, creating complex calculations in SQL can be complex, often requiring joins and unions to provide intertable/ inter-row references. These complex calculations are often not efficient and are difficult to maintain. The Model clause's ability to create inter-linked formulas makes complex SQL computations easier to read and more efficient. This presentation will demonstrate the creation and use of SQL using the Model clause.

 

Back-to-Top  or Names

Jeffery Maresh
Session: 2 - 10:20 to 12:00
Data Warehousing - Intermediate

Materialized Views in Action

Materialized views are a powerful data warehousing feature that can greatly improve summary query response time. In theory, they are easy to implement. In practice, there are many nuances that will result in poor performance if overlooked. This presentation is for intermediate and advanced developers and DBAs who already have a basic understanding of materialized views, but want to learn how to optimize them for peak performance and functionality. The following topics will be discussed: how to choose the correct summary level for materialized views, materialized view partitioning and indexing strategies, optimal structure and management of materialized views on very large data warehouse tables, troubleshooting queries that use materialized views, and the most commonly encountered bugs and how to deal with them.

 

Back-to-Top  or Names

Jeffery Maresh
Session: 8 - 10:30 to 12:00
Data Warehousing - Intermediate

Supercharging Star Transformations

The star transformation is a data warehousing join methodology used in dimensional data warehouses. While the feature has been available in Oracle for several years now, many developers still don't use it because they feel it is too difficult to implement, or because of poor performance. This presentation will help attendees understand the practicality of star transformations over other join methodologies and explain how to optimize them to achieve peak performance. A real-world schema is used to illustrate the performance differences between conventional join methods and the corresponding star transformation. The presentation continues with a useful discussion about properly configuring the database and monitoring to achieve optimal star transformation performance. Lastly, the presenter will show how to tune poorly performing queries.

 

Back-to-Top  or Names

Jeffrey Meyer
Session: 11 - 3:45 to 4:45
Data Warehousing - All

Data Vault-What's the Combination?

What is a data vault and why should I use it? The answer is that a data vault is a concept that has been pioneered by Dan Linstedt of Coreintegration. In this presentation, you will learn how a data vault allows data warehouses to move to the next level of scalability and ease of use.

 

Back-to-Top  or Names

George Peck
Session: 8 - 10:30 to 12:00
Data Warehousing - Intermediate

Crystal Reports Professional Results-Reporting Fine Points

Learn fine points, tips, and tricks to make the most of Crystal Reports, the absolute market-leading Oracle reporting tool. Presented by a seasoned author and repeat RMOUG speaker, this dynamic presentation will send you back to your office with dramatically increased reporting productivity. Learn simple and advanced report design techniques, including: using watermarks and placing charts alongside data, "Greenbar-like" reporting with every other line shaded, helpful "all or specific item" parameters, formulas that show multivalue and range parameter field items on the report, sorting and grouping based on parameters, and speeding up SQL-based reports with SQL expressions. Bring your own Crystal Reports questions and problems to the session for discussion and resolution!

 

Back-to-Top  or Names

Nghia Phu
Session: 11 - 3:45 to 4:45
Data Warehousing - Intermediate

Using the Oracle Metabase Plus Language to Build and Deploy Mappings and Workflows

If you are using Oracle Warehouse Builder (OWB) and want to be productive and avoid doing repetitive work manually, then the Oracle Metabase Plus language (OMB Plus) is just right for you. This session will demonstrate the use of OMB Plus to produce, copy, and deploy hundreds of mappings and workflows that will be used to extract/load data from the source to your data warehouse.

 

Back-to-Top  or Names

Ravi Gautham and Rich Niemiec
Session: 4 - 2:15 to 3:15
Data Warehousing - All

The Ten Essentials of a Successful Oracle RAC Implementation - All

Attend this session to learn how to architect a successful implementation of Real Application Clusters (RAC). Experts who have been involved in dozens of RAC implementations will share their wisdom and help you avoid rookie mistakes. Among the top ten essentials to be covered: minimizing instance recovery problems; storage networking considerations; avoiding cluster's kryptonite (Split Brain); optimal VERITAS Cluster Server service group configurations; and storage configurations for availability, performance, and utilization.

 

Back-to-Top  or Names

William Thater/Author: April Wells
Session: 10 - 2:15 to 3:15
Data Warehousing - Intermediate

Demystifying Data Warehouse Design

Presentation Not Yet Available

Data warehousing is often considered to be one of those mythical places where only wizards and witches go to perform their magic. Data warehouses can provide the opportunity to bring untold riches in information and knowledge mined from seemingly innocuous data to the coffers of the corporate kingdom. But what, exactly are these things called schemas as they refer to the data warehouse and what can all of the different structures bring to the kingdom? This presentation will discuss the Star schema and the Snowflake schema as two of the most popular and often used schemas and present you with a better understanding of what each means and some of their ramifications. It will also look at a few of the alterations on the theme, what it means to be staring at a galaxy in your data warehouse, what it means to find yourself in a blizzard, and what exactly a star flake is.

 

Database Administration

 

Back-to-Top  or Names

Robert Albach
Session: 1 - 9:00 to 10:00
Database Administration - Intermediate

Optimizing Oracle9i Instance Memory

Presentation Not Yet Available

DBAs are always aware that memory is the most critical system resource. Effective utilization of memory is a must for optimal system performance because memory access is faster than accessing data directly from disk. Resizing SGA and PGA memory components benefits the administration of memory resources for optimal performance. This presentation takes a closer look at these features, explains how they work, and makes recommendations for best practices for optimizing total instance memory. The presentation will give an overview of Oracle9i instance memory and take a holistic approach to instance memory management. The following concepts will also be covered: dynamic SGA, automatic SQL, execution management, and Oracle advisories and their use in resizing.

 

Back-to-Top  or Names

Mike Ault
Session: 2 - 10:30 to 12:00
Database Administration - Intermediate

Comparison of Solid-State Disks to ATA Disks with Oracle9i - Intermediate

In this presentation, the performance characteristics of the solidstate arrays is compared to industry-standard SCSI and ATA arrays. Performance for inserts, index builds, and queries will be compared. Methods to determine if SSD is a good fit for your system will be shown.

 

Back-to-Top  or Names

John Beresniewicz
Session: 4 - 2:15 to 3:15
Database Administration - All

Metric Baselines: Detecting and explaining performance events using Enterprise Manager 10gR2

Oracle Enterprise Manager enables administrators to set fixed metric value thresholds for purposes of generating alerts on problem situations, something that has been particularly difficult for a number of reasons. Release 10gR2 Oracle Enterprise Manager introduces a new feature for detecting and alerting on unusual instance performance events. Metric thresholds can be dynamically and adaptively determined by the system, producing higher-quality performance alerts with less administrative overhead. The presentation will introduce this new feature and discuss some technical details of its implementation.

 

Back-to-Top  or Names

Randy Cunningham
Session: 4 - 2:15 to 3:15
Database Application - Intermediate

Cloning Oracle Databases

Duplicating an entire database structure into a separate, usable copy- "cloning"-can be valuable for testing, production support, and static reporting databases. In this presentation, attendees will find out how cloning compares to other replication methods such as Oracle's export/import utilities, transportable tablespaces, advanced replication, and Oracle Streams; understand when cloning is appropriate; and learn the pitfalls and challenges that can be encountered when cloning a database. Several cloning techniques will be surveyed including simple cold database copies, hot database cloning, the RMAN DUPLICATE command, and use of SAN split mirrors. Working scripts will also be presented.

 

Back-to-Top  or Names

Carol Dacko
Session: 5 - 3:45 to 4:45
Database Administration - Intermediate

Feature Creatures!

The introduction of the cursor sharing peeking feature in Oracle9i has presented some peculiar issues in production systems. Explain plans that do not match how Oracle actually executed the statement will be explored in this presentation. In addition, automatic SQL Memory Management has provided its own set of challenges. There are other parameters beside the pga_aggregate_target parameter that can determine how much memory is used for SQL statements. Various tests of the other important parameters will be presented, along with the test results

 

Back-to-Top  or Names

Kirtikumar Deshpande
Session: 2 - 10:30 to 12:00
Database Administration - Intermediate

Understanding Automatic Undo Management and Flashback Query

Oracle9i introduced Automatic Management of Undo (rollback) segments. In this presentation, attendees will learn what undo segments are, how Oracle uses them, what about them is automatic, and what is not. It will discuss how Oracle9i attempts to minimize "snapshot too old" errors and how Oracle9i leverages the Automatic Undo Management to offer yet another new feature called "flashback query," which can be used to view data as it existed at a past point in time. A demonstration of the flashback query feature will show how non-DBA users can use it to recover data from accidental modifications, track data changes, and compare current data with past data.

 

Back-to-Top  or Names

Carel-Jan Engel
Session: 5 - 3:45 to 4:45
Database Administration - Advanced

Data Guard Performance

Oracle Data Guard can protect your database from data loss, but at what cost? Apart from licensing, what is its resource consumption, how can you manage that? Will day-to-day work suffer from performance degradation when Data Guard is put into service? This presentation will lead you through the parameters that cover Data Guard's performance and protection level. It will discuss the network-related issues that will influence the performance of your Data Guard configuration. The presentation helps you to determine what protection level is within your reach, and at what (performance) cost.

 

Back-to-Top  or Names

Carel-Jan Engel
Session: 9 - 1:30 to 2:00
Database Administration - Intermediate

Implementing Data Guard

Implementing Data Guard on various platforms like Linux, Solaris, and Windows at approximately 30 sites has led to a set of guidelines and best practices in implementing this Oracle feature for high availability. The guidelines will help you to set up a HA configuration that can help you survive disasters that might, but hopefully never will, strike your data center.

 

Back-to-Top  or Names

John Garmany
Session: 8 - 10:30 to 12:00
Database Administration - Intermediate

Indexes-The Good, the Bad, the Wrong Type - Advanced

Supercharge your database with Indexes. Attend this session and learn how to properly use and monitor indexes without overwhelming your database. Get the right index on the right data to make your database run more efficiently.

 

Back-to-Top  or Names

Gary Goodman
Session: 4 - 2:15 to 3:15
Database Administration - All

SQL*Net Message...From Client is your top contributer to response time - now what?

This presentation will highlight the risk of overlooking the "SQL*Net Message" family of timed events when diagnosing performance issues. It will discuss where the inappropriate "idle" label came from and how data collection mistakes will hide a SQL*Net Message problem from you. It will also explore several common issues that result in severe performance problems and discuss the remedy options for each.

 

Back-to-Top  or Names

Nicole Haba
Session: 12 - 5:00 to 6:00
Database Administration - Intermediate

Managing Oracle Application Server with Oracle Grid Control

Managing a dynamic application server environment can be a challenge. The administrator needs a management system that simplifies administration and provides fast access to status and performance data. The management system must also be flexible and web-enabled. Oracle Enterprise Manager 10g provides such a management system for the Oracle Application Server. Enterprise Manager manages the application server's configuration files, gathers performance data from each component, monitors and alerts administrators to potential problems, and performs administrative operations. Oracle Enterprise Manager also allows you to manage your entire Oracle environment, including web applications, databases, and hosts.

 

Back-to-Top  or Names

Stephan Haisley
Session: 11 - 3:45 to 4:45
Database Administration - Intermediate

I Think My Database Is Hung...Systemstate What?

When a database is reported as "hung" to Oracle Support Services, they always request a number of things, namely a series of System State or HangAnalyze dumps. The trace files generated from these events are not very easy to understand, nor is the information that can be gleaned from them. This presentation will demystify why these trace files (systemstate AND hanganalyze) are useful. It will cover the following topics: how to generate these trace files, why support always requests them, how to provide a basic understanding of state objects, and how to interpret these trace files by the use of some examples.

 

Back-to-Top  or Names

Dan Hotka
Session: 12 - 5:00 to 6:00
Database Administration - Intermediate

A Close Look at Oracle 10 New Features for DBAs

This presentation will discuss many of the new features of the Oracle 10 database. The presenter has considerable experience in the development of Oracle-based applications. This presentation is a MUST for developers and DBAs who regularly design and support Oracle-based applications.

 

Back-to-Top  or Names

John King
Session: 12 - 5:00 to 6:00
Database Administration - Novice

XML Survival Skills for DBAs

XML (eXtensible Markup Language) has quickly become significant to the information industry. Today, configuration files and data are being provided using XML to facilitate portability. Oracle is among the vanguard of software vendors who are building XML into its products. This session will examine the concepts and facilities of XML and how they are being implemented in Oracle. DBAs need to understand the basic nomenclature of XML, how international standards apply, what applications people will be using XML for, how XML is supported by Oracle's database and other tools, and finally, the DBA's role in supporting XML-using applications. Session attendees will be able to begin implementing XML solutions in their home environments.

 

Back-to-Top  or Names

James Koopmann
Session: 5 - 3:45 to 4:45
Database Administration - Intermediate

Zeroing In on Performance in Oracle 10g

Past performance tuning efforts and techniques have left DBAs and developers alike scratching their heads wanting more. Oracle 10g provides much of the technical statistics we have always wanted. This presentation will take a look at how DBAs and developers can use their time efficiently and quickly to determine their performance issues. Various techniques will be shown, along with invaluable SQL scripts on how to properly detect database contention issues.

 

Back-to-Top  or Names

Arun Kumar
Session: 4 - 2:15 to 3:15
Database Administration - Intermediate

DBA on Autopilot with Oracle Database 10g

Oracle Database 10g has come up with a lot of features to automatically self-administer the database. This presentation will help you learn more about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), Automatic SGA Management (ASM), Automatic Storage Management (ASM), and SQL Advisors. You will hear how the 10g Automatic Workload Repository collects important Oracle performance statistics and how the 10g Automatic Database Diagnostic Monitor (ADDM) pinpoints performance problems and makes tuning recommendations. The discussion will include easy disk and file management with the 10g Automatic Storage Management and SQL Tuning Advisor.

 

Back-to-Top  or Names

Matt Larson
Session: 6 - 5:00 to 6:00
Database Administration - All

Resource Mapping: A Wait Time-Based Methodology for Performance Analysis

Resource mapping is a process for database performance optimization, based on wait time analysis, that has achieved performance improvements over 35 percent and an ROI over 800 percent in large Oracle environments. Industry leaders now recommend wait time (or wait event)- based analysis as the best practice for database performance management. This presentation will cover the technical foundations of resource mapping and describe how this wait time-based procedure can be used to make optimization decisions that are aligned with business priorities. Aimed at production DBAs and SQL developers, the presentation includes practical examples, case studies, and specific requirements to achieve the desired database performance improvement.

 

Back-to-Top  or Names

Jonathan Lewis
Session: 5 - 3:45 to 4:45
Database Administration - Intermediate

Gathering Statistics: How Often and How Precise

There are endless arguments on the internet about the frequency with which statistics should be collected, and what sample size is most appropriate. Good statistics help the Cost Based Optimizer choose the most appropriate join order, and the most effective access mechanism by allowing it to work out how many rows will be produced by each step of an execution path. But how can you acquire "good enough" statistics as cheaply as possible? This presentation will help you decide when you can avoid work, and when you have to work hard on statistics. An important feature of the presentation is the explanation of what a histogram really is, and how histograms can sometimes be used to work around bad design decisions.

 

Back-to-Top  or Names

Jonathan Lewis
Session: 7 - 9:00 to 10:00
Database Administration - Intermediate

Rebuilding Indexes-How, Why, and When

If your system budget is unlimited, you may be able to afford to waste resources doing a huge amount of unnecessary work on the off-chance that it might improve somebody's performance issues. On the other hand, you may be in that vast fraction of the DBA population that has to support a system on a limited budget and overloaded hardware. If you fall into the latter camp, you will probably want to avoid adding the extra burden of doing jobs that consume resources without adding benefit. If so, this presentation will give you the truth about the rationale, methods, and costs of rebuilding indexes.

 

Back-to-Top  or Names

Scott Martin
Session: 10 - 2:15 to 3:15
Database Administration - Advanced

Index Organized Tables-Are They Right for You?

By storing non-key values along with the key values in an index, Oracle can dramatically decrease the work needed to perform certain queries when compared to a standard B-Tree implementation. This presentation will not only cover how Oracle implements IOTs, but will also walk through detailed examples using IOTS, backed by statistics and explain plans. It will also cover the effects on performance of the overflow table and secondary indices created on IOTs. You will leave knowing when and when not to consider using IOTs in your applications.

 

Back-to-Top  or Names

Timothy Mishek
Session: 10 - 2:15 to 3:15
Database Administration - Intermediate

Real World Solutions Using the Perl DBI

How many times do we get tasked with something in our DBA lives where we need a monitoring solution, DDL generated, loading flat files into a database, or the generation of a quick report? The Perl DBI just might be the solution for your DBA needs. This session will concentrate on how to get started using Perl to do just that and more.

 

Back-to-Top  or Names

Jeffrey Meyer
Session: 3 - 1:30 to 2:00
Database Administration - Intermediate

Cloning an Oracle Database-It's Easier Than You Think

This presentation will detail the steps necessary to clone an Oracle database. It will alert you on what to watch out for. Finally, it will answer the question "Does the OS really make a difference?"

 

Back-to-Top  or Names

Jeffrey Meyer
Session: 7 - 9:00 to 10:00
Database Administration - All

True Costs of Poor Planning

This presentation will detail the steps necessary to clone an Oracle database. It will alert you on what to watch out for. Finally, it will answer the question "Does the OS really make a difference?"

 

Back-to-Top  or Names

John Murphy
Session: 6 - 5:00 to 6:00
Database Administration - Intermediate

Data Retention-More Value, Less Filling - Intermediate

Traditional data management has focused on the "getting data in" portion of the data lifecycle with very little visibility being given to the disposing of low-value data. Recent changes in data accountability have forced companies to develop procedures to adhere to published retention policies and be able to prove appropriate disposal of data assets. Data management needs to incorporate practices that are in sync with formalized data retention policies. This presentation will describe several aspects of data retention and how organizations can develop compliance processes.

 

Back-to-Top  or Names

Rich Niemiec
Session: 12 - 5:00 to 6:00
Database Administration - Intermediate

Tuning Oracle 10g: Tuning Oracle has Radically Changed

This presentation is a look at tuning Oracle 10g. It will take a brief look at Oracle over the years and demonstrate its current direction with 10g. It will also look at RAC and how it can prepare you for moving to grid computing. It will then look at how Enterprise Manager lets you manage the entire environment and some other tuning features. This session will cover statspack tuning in detail, showing how to use statspack to evaluate and fix issues related to the top 5 wait events, load profile, instance efficiency ratios, wait events, latch waits, top SQL, instance activity, and file i/o issues. Lastly, it'll look at some helpful V$ views and X$ tables that can help as well when you need to dig deeper.

 

Back-to-Top  or Names

Mogens Norgaard
Session: 6 - 5:00 to 6:00
Database Administration - Intermediate

Stop Analyzing

Presentation Not Yet Available

Any cost-based optimizer takes into account statistics about the database objects and the system, parameter settings, and rules and constants (heuristics) in the database software. If one or more of those elements change, there's a good chance the execution plan under one or more SQL statements will change. The question then becomes stability versus improvement/declination. This presentation will show how to detect, diagnose, and repair these situations.

 

Back-to-Top  or Names

Mogens Norgaard
Session: 7 - 9:00 to 10:00
Database Administration - All

How to Tune SQL Scientifically, Not by Guess and Grimacing

You may download the following for this presentation.

"SQL Tuning for Managers and Other Dummies"

This presentation will cover the two scientific (therefore repeatable and predictable and quantifiable) methods you can use, and show you the three things you need to know, to make anything run as fast as you want (or as your business needs require).

 

Back-to-Top  or Names

Tanel Poder
Session: 3 - 1:30 to 2:00
Database Administration - Intermediate

Automatic Segment Space Management Internals - Intermediate

This session concentrates on internal implementation of Oracle's Automatic Segment Space Management (ASSM), giving an understanding of potential benefits and drawbacks in using ASSM in high concurrency environments in Oracle versions 9i and 10g. ASSM in RAC environment issues are also discussed. Finally, a comparison is done between freelist and automatic segment space management, and general recommendations are made.

 

Back-to-Top  or Names

Tanel Poder
Session: 10 - 2:15 to 3:15
Database Administration - Intermediate

Small Tables Also Need to Be Tuned!

This session will concentrate on heavily accessed small and medium tables such as lookup tables or tables modified in very highconcurrency environments. Attendees will see how saving one-tenth of a millisecond in an extremely often-executed query can result in a huge savings in overall ETL or batch job speed. This presentation was originally presented at Hotsos Symposium in 2004, but has evolved to include the latest information. Topics to be addressed are optimizing tight loops, optimizing reading from small tables, CBO issues with very small tables, speeding up DUAL access, ways for spreading hot blocks, and benchmarks.

 

Back-to-Top  or Names

Marshall Presser
Session: 8 - 10:30 to 12:00
Database Administration - Intermediate

Oracle Real Application Clusters 10g

People build commercial clusters to solve three primary problems: availability, scalability, and cost. In this 90-minute presentation, we will see how Oracle 10g Real Application Cluster technology addresses these issues. The presentation will start with some basic clustering principles, discuss the architecture of Oracle 10g, discuss best and worst practices, and finish with a demonstration. While no previous knowledge of clustering is assumed, some basic knowledge of Oracle architecture is.

 

Back-to-Top  or Names

Roger Schrag
Session: 7 - 9:00 to 10:00
Database Administration - Intermediate

Speeding Up Queries with Semi-Joins and Anti-Joins: How Oracle Evaluates EXISTS, NOT EXISTS, IN, and NOT IN

Optimizing the SQL usually gives the most significant results when DBAs are called upon to "make the system run faster." Using tools like Statspack or Enterprise Manager, it is often easy to find the slow SQL. But how do you make the queries run faster? That is the challenge! This presentation will discuss the semi-join and the antijoin, two powerful SQL constructs Oracle offers for use in your quest for faster queries. It will define these two terms, discuss when and why you might want to use the [NOT] EXISTS or [NOT] IN constructs, and demonstrate how you can use optimizer hints and make minor query changes in order to enable Oracle to use some very powerful and efficient access paths. Attendees should be very familiar with execution plans and join methods in order to get the most out of this presentation.

 

Back-to-Top  or Names

Roger Schrag
Session: 1 - 9:00 to 10:00
Database Administration - All

Use EXPLAIN PLAN and TKPROF to Tune your Applications

In this presentation we'll discuss an overview of the EXPLAIN PLAN and TKPROF functions built into the Oracle server and learn how developers and DBAs use these tools to get the best performance out of their applications. We'll look at how to invoke these tools both from the command line and from graphical development tools. In the remainder of the session we'll discuss how to read and interpret Oracle execution plans and TKPROF reports. We'll look at lots of examples so that you'll come away with as much practical knowledge as possible.

 

Back-to-Top  or Names

Jared Still
Session: 11 - 3:45 to 4:45
Database Administration - All

Perl and the Oracle DBA

Some of the topics included in this presentation are metrics, passwords, Excel spreadsheets, and environment variables. Demonstrations include use of a Perl-based password server, custom script development for spreadsheets already in Excel format, and using Perl to manage the environment variables on multi-homed Windows servers.

 

Back-to-Top  or Names

Terry Sutton
Session: 7 - 9:00 to 10:00
Database Administration - Intermediate

Oh No, I Can't Recover! Now What?

You've lost a datafile on your production database, so you restore from your backup. But you discover you're missing some archived redo logs made since the backup, and Oracle won't let you open the database. Are you out of luck? Are you out of business? While every DBA knows there is a big problem here, is the problem totally insurmountable? Can any data be saved? You may be able to extract some (maybe even most) of your data. This presentation will demonstrate a method which may allow you to retrieve data from your database. Though the data won't be perfect, it may be better than having no data at all.

 

Back-to-Top  or Names

Kyaw Than
Session: 1 - 9:00 to 10:00
Database Administration - Intermediate

Synchronizing Database and Application Server Backups Across Multiple Hosts

Backing up an Oracle database may require coordination across multiple servers if the application is multitiered. For example, application servers and web servers may need to be shut down before carrying out the Oracle backup. Upon completion, all servers will also have to be started up in the correct order. This presentation will show how the sequencing of backups and shutdowns can be accomplished through the use of semaphores. Because the implementation is in Perl, this method can be used across any Unix / Linux platform, and should also work in Windows environments.

 

Back-to-Top  or Names

William Thater
Session: 3 - 1:30 to 2:00
Database Administration - Novice

Profiles, Passwords, and Roles! Oh My! A Beginning DBA's Look at User Management

With the advent of SOX and HIPPA, a greater emphasis is being placed on proper user management. This presentation is a beginning DBA's look at the process of user management, including the proper creation of profiles, roles, and password security. User management doesn't begin with creation of the user, but with the proper design and creation of roles to provide proper data access, profiles to limit resource usage and help compliance with security policies, and password management to help ensure security.

 

Back-to-Top  or Names

William Thater
Session: 6 - 5:00 to 6:00
Database Administration - Novice

It's Broke! Fix It Now! A Novice DBA's Guide to Troubleshooting User Complaints

You get the phone call from a user claiming there's a problem with the database; what do you ask? What do you look at first? How can you tell where the problem is? This presentation will look at some tips on how to go about troubleshooting user complaints to pinpoint the problem's location and nature.

 

Back-to-Top  or Names

Ambrose Zaragoza
Session: 9 - 1:30 to 2:00
Database Administration - Novice

Upgrading Oracle Financials from 11.5.8 to 11.5.9

This presentation will discuss an Oracle Financials upgrade from 11.5.8 to 11.5.9 on a single Windows 2K Server.

 

Enterprise Systems

 

Back-to-Top  or Names

Lowell Fryman and Bonnie O'Neil
Session: 5 - 3:45 to 4:45
Enterprise Systems - All

Metadata: What You Don't Know IS Killing You!!

Most organizations don't understand the processes and rules behind how their businesses are run. This lack of understanding can kill their business, and even send top executives to jail; and in certain circumstances, like the Space Shuttle, even kill people. It is amazing how much organizations don't know about their data, and it is also amazing that in light of this, they are still able to do business. This talk deals with a wide range of subjects such as data quality, semantics, service oriented architecture, compliance and business rules, and how metadata ties all of these together to foster greater understanding and enable the running of your business more effectively.

 

Back-to-Top  or Names

David Fuston
Session: 2 - 10:30 to 12:00
Enterprise Systems - All

BIS and Discoverer EUL in 11.5.9

This training session will concentrate on installation prerequisites, setup and configuration, and implementation steps for BIS and Discoverer EUL in an 11.5.9 environment. It will highlight the strengths and weaknesses of standard BIS EUL and how to modify it to get what you need in Discoverer. It will also identify the underlying 9i database and patches necessary as a starting point, address a rapid install, and end with a discussion and demonstration on how you would modify the standard EUL to stay within the realm of Oracle metalink support using the Discoverer Administrator tool.

 

Back-to-Top  or Names

David Fuston
Session: 11 - 3:45 to 4:45
Enterprise Systems - All

Oracle Applications Reporting-How Can I Get What I Need?

Most organizations find after their Oracle Apps implementation that their reporting solution does not provide the level or degree of information they want or they discover that the reporting products they acquired are not best suited for the information they need to produce. This presentation will discuss the causes and results, alternative strategies for solutions, approach methodologies, and ways to avoid these reporting frustrations by using a matrix of Oracle products to match the user requirements. During this discussion, the features and functionality of Financial Statement Generator (FSG), Oracle Sales Analyzer (OSA), Oracle Financial Analyzer (OFA), Enterprise Planning and Budgeting (EPB), Business Intelligence System (BIS), Daily Business Intelligence (DBI), Balanced Scorecard (BSC), Discoverer, and Reports will be addressed.

 

Back-to-Top  or Names

Bill Jackson
Session: 1 - 9:00 to 10:00
Enterprise Systems - Novice

J2EE Security and You-An Introduction to Terms, Techniques, and Architectures

Are you confused by J2EE security? Want to learn more about LDAP, JAAS, OID, and JCE without hearing that dreaded phrase, "Hire a specialist"? This presentation will cover the basics of J2EE security from terminology and role-based permissions to LDAP directories and encryption. This high-level overview will familiarize you with the issues and architectures without a lot of code, deployment descriptors, and other low-level details

 

Back-to-Top  or Names

George Loewenthal
Session: 6 - 5:00 to 6:00
Enterprise Systems - Intermediate

Building 10g RAC on Linux and Firewire-Based Storage

Building an Oracle 10g RAC development system can be done inexpensively. This presentation will provide an excellent environment to learn and understand RAC before committing thousands of dollars. You can use a pair of old PCs and a few hundred dollars in additional hardware to build a RAC system. Learn how to utilize Oracle's cluster file system (OCFS) instead of using raw partitions and utilize firewire-based storage instead of high-end storage to save costs.

 

Back-to-Top  or Names

Bonnie O'Neil
Session: 12 - 5:00 to 6:00
Enterprise Systems - All

Metadata, Business Rules, and Semantics: Toward a Unified Theory of Information Intelligence

This session will present how multiple areas of our discipline can be brought together to solve many important problems that IT systems present, not the least of which is data quality. A proper understanding of data is key for accurate decisions to be made. This presentation will cover different approaches to metadata design, along with case studies. The following key points will be covered: lack of proper understanding of data causes horrendous errors; metadata, used properly, can help alleviate data quality problems; semantics, which includes business rules, is a key factor in data intelligence; and proper definitions are critical. This session also explains how this "Unified Theory of Information Intelligence" can be used with SOA and/or web services to translate to different data formats and be used with data warehouses to create marts.

 

Professional Development

 

Back-to-Top  or Names

Janet Burleson
Session: 3 - 1:30 to 2:00
Professional Development - All

Ace Your Oracle Job Interview

No presentation to download.

When applying for a job, you may have to pass a tough telephone screening before you even get a chance at a face-to-face interview. Attend this presentation and learn from a manager what to expect and what managers are looking for in a telephone interview. The on-site interview is also challenging, as the interviewer will use tools to quickly access your demeanor, technical skills, and personality. Find out what unobtrusive questions you might be asked, what the manager is "really" asking, and the most appropriate responses.

 

Back-to-Top  or Names

Janet Burleson
Session: 3 - 1:30 to 2:00
Professional Development - All

For Managers Only: Secrets for hiring the best Oracle Professional

Presentation Not Yet Available

Using proven interview and screening techniques, this presentation will reveal the secrets of resume evaluation, telephone screening, and top job interview questions. By using unobtrusive measures, you can quickly and accurately assess important non-technical factors, such as personality and the applicant's ability to work as a team player.

 

Back-to-Top  or Names

Tamara Swilley
Session: 6 - 5:00 to 6:00
Professional Development - All

Feng Shui for Success-Managers and Independent Consultants

This presentation is designed for persons who are in management positions or working as independent IT consultants, but all can benefit. The presentation will cover how to optimize energy flow around the office and the home to heighten success, recognition, and income, including special tips for people who work from home or are starting a home business! It will cover the most auspicious setup of furniture, including desk position, to super charge your business, bring new opportunities, and lock-in steady income. Managers will learn new leadership skills, new ways to take command, and how to get the recognition you deserve. Special Feng Shui secrets will be orally transmitted; unique techniques that you will not hear anywhere else. Don't miss this presentation, it could change your entire career!

 

Technology Management

 

Back-to-Top  or Names

Janga Aliminatic
Session: 7 - 9:00 to 10:00
Technology Management - Novice

Oracle Application Server 10g Overview

In an enterprise environment, there is a huge demand for a highly available and scalable enterprise architecture for global application implementation to support 24/7 worldwide customers. In the Oracle Application Server 10g (OracleAS) architecture, design customers are expecting highly available, scalable, and secured deployment for their enterprise applications, including web tier, app tier, and data tier components. The bottom line is that there should not be any single point of failure at any time, in any tier, and with any component. This session explains how to install multiple Portal/IM (Identity Management) mid-tier servers using a Load Balance Router (LBR) to provide a highly available and scalable architecture for OracleAS 10g Portal, wireless, and infrastructure components. It also covers high availability setup for back-end MR and multiple OID installations.

 

Back-to-Top  or Names

Candi Hoxworth
Session: 12 - 5:00 to 6:00
Technology Management - All

Knowledge Development and the Effects on Enterprise Data

No presentation to download.

• Current challenges facing database and systems in the organization
• Definition of knowledge in context
• A new knowledge model
• Overview of Ontology Development
• Overview of knowledge bases and A1 technologies
• Overview of how these integrate for ongoing data issues

 

Back-to-Top  or Names

Ralph Hughes
Session: 4 - 2:15 to 3:15
Technology Management - All

How to Architech and Manage an Application Development Project

Presentation Not Yet Available

Project manager and lead architect are distinct roles in a development project, but senior technologists are often asked to do both. When combined, large portions of what they should be doing typically get neglected, creating an enormous risk to the project. This presentation will examine the issues faced by the managing architect and begin to solve them by acknowledging that there are two separate lifecycles at work in any one project, each needing its own methodology. It will look at international standards defining the very distinct methodology and work product of each. Finally, given the two roles and two lifecycles, it will examine their interface and overlaps, searching for the means to avoid pitfalls and ensure the project's chances for success.

 

Web, Internet/Intranet

 

Back-to-Top  or Names

Samuel Conn
Session: 5 - 3:45 to 4:45
Web, Internet/Intranet - All

Toward Semantic Web Content Using Oracle In-Engine XML Generation from Relational to Object-Relational Mappings

This presentation builds on the concepts of the Semantic Web to show how Oracle9i Object-Relational technology and the XML generator function can be used to implement features on the next generation web. Semantic Web definition, history, and evolution will be discussed to consider the treatment of how information can be linked in such a way as to be easily accessed and processed by machines, as well as by people. Illustrations and examples of how Oracle's Object-Relational data structures and Oracle's XML generator and query capability can be used within the framework of the Semantic Web will be presented and explained, with a view of the future development work that lies ahead.

 

Back-to-Top  or Names

Jeff Eberhard
Session: 10 - 10:30 to 12:00
Web, Internet/Intranet - Novice

Web-erize User Data with HTML DB

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 wil also demonstrate how development is done using the browser interface. Examples of finished projects using HTML DB will be given.

 

Back-to-Top  or Names

John Jeunnette
Session: 8 - 10:30 to 12:00
Web, Internet/Intranet - Intermediate

A Hidden Gem: The PL/SQL Web Toolkit

Oracle's current focus on implementing database and development The PL/SQL Web Toolkit provides a thin client (just a browser) application development environment for dynamic generation of HTML from the database. This presentation includes practical tips and techniques showing how to take advantage of the PL/SQL Web Toolkit to develop robust, scalable web-based applications.

 

Back-to-Top  or Names

Peter Koletzke
Session: 12 - 5:00 to 6:00
Web, Internet/Intranet - Novice

I Love the Java Jive: J2EE Overview for Oracle Technologists

Lately, Oracle has been spending a large amount of time and resources implementing concepts published in the Sun Microsystems Java 2 Platform, Enterprise Edition (J2EE) specifications. As Oracle customers, we must have a handle on the technology and options available in this relatively new world if we are to take advantage of current and future technologies. J2EE offers a myriad of possibilities and a dizzying number of new acronyms. The objective of this presentation is to explain these to the Oracle technologist who understands the "traditional" world of relational database design, development, and administration. It will discuss web deployment alternatives such as servlet and JSP pages, Java client alternatives, .NET vs J2EE, and Oracle's product offerings in the Java space.

 

Back-to-Top  or Names

Peter Koletzke
Session: 8 - 10:30 to 12:00
Web, Internet/Intranet - Novice

Introduction to Java-PL/SQL Developers Take Heart!

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 objectoriented core makes it look very different. Also, you may be wondering about Java's strengths and weaknesses and where it fits in the industry. This presentation will explain to PL/SQL developers who have had little or no exposure to Java, the basic concepts of and terms used in 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.

 

Vendor Presentations

Some vendors have no presentations.

 

Back-to-Top  or Names

Quest Software

Understanding Your Oracle Workload with Quest Central - Performance Analysis

Robert Albach

There is no summary for this presentation.

 

Back-to-Top  or Names

AppWorx

Application Automation in an Oracle IT Environment

Alex Givens       Session: Vendor Presentation

Off-the-shelf and custom applications are the critical components in most IT organizations. Efficient processing of those applications is the best way to ensure the efficiency of the business. This presentation will discuss ways to automate, integrate, and accelerate the processing of applications in an Oracle IT environment.

 

Back-to-Top  or Names

Churchill Software Services

JAutomator: Transforming Oracle Forms to Service Oriented Architecture (SOA)

Sri Rajan      Session: Vendor Presentation

The J2EE architecture presents as many technology, skill, and adoption challenges as it does benefits to open, standards-based freedom-of-choice computing. For Oracle Forms customers migrating to SOA, a set of computing concepts that have been around for over 20 years, J2EE becomes a first step toward standards-based openness. A successful migration of any legacy application to J2EE and SOA must solve the deep-rooted learning skills adoption issue while exploiting open, best-of-breed technology. This presentation will examine design patterns, frameworks, and the best of client/server to define the criteria for successful Oracle Forms-to-SOA migration projects. It will leverage JAutomator, Churchill's enterprise-grade, entirely software-driven Oracle Forms-to-SOA migration framework, requiring no consulting services, to illustrate these design principles of SOA in action.

 

Back-to-Top  or Names

Confio Software

Confio DBFlash: Have a Big Impact on Your Oracle Performance

Don Bergal      Session: Vendor Presentation

Confio DBFlash for Oracle is performance improvement software that delivers a 35% performance gain to unlock the hidden value of your Oracle database. Automating a Wait Time-based analysis, DBFlash identifies the SQLs and Oracle resources that are holding back your database. This presentation highlights the results achieved by customers using DBFlash, and delivers examples of how it can be applied to solve the toughest Oracle performance problems.

 

Back-to-Top  or Names

Dynamic Solutions International

Accelerate Database Performance with Solid State Disk

Woody Hutsell      Session: Vendor Presentation

Would you like to improve application performance without rewriting all of your applications or replacing your existing infrastructure? By storing heavily accessed data on SSD, you can improve system performance significantly...and at a price that will make you wonder why you waited so long. Please join us to learn how a little bit of SSD can radically change the way you process data.

 

Back-to-Top  or Names

NetApp

How to Back Up/Restore a 1TB Database in Less Than a Minute

Maury Tiller      Session: Vendor Presentation

Utilizing features within storage subsystems today, DBAs can reduce backup windows to seconds while decreasing the time it takes to recover from costly mistakes. This discussion will cover thes