RMOUG
Training Days 2006 Presentations
February 15-16, 2006
Colorado Convention Center
Denver, Colorado
Register Now | Schedule at a Glance | Sponsors & Exhibitors
Room
Block Information
RMOUG
has secured a room block at the Hyatt Regency Denver at the Colorado
Convention Center. The room rate is $175 per night. Please call
303.436.1234 to make your reservations, and indicate that you are with
RMOUG Training Days 2006.
Hotel
Information:
Hyatt
Regency Denver at the Colorado Convention Center
650 15th Street
Denver, CO 80202
Please
note these changes for Training Days 2006:
The following presentations have been added:
Carol Dacko, STATSPACK and the Production DBA
Allan Edwards,SOX 101 - intro to Sarbanes-Oxley from Administrator's
Perspective
John Garmany, Soup Up Your Syntax - Make the Move to SQL-99
John Garmany, Clone That Database - The Hot, the
Cold, the RMAN Way
Jeff Needham, Oracle Commodity Computing on the AMD64 Platform
Mogens Norgaard, Moans, Groans, and IT 2006?
Mogens Norgaard, No, We're STILL not Tuning the Right SQL
Statements!
Mogens Norgaard & Kevin Closson,
JSF on High - Availability in the 21st Century
The following presentations have been canceled:
Jon Arnold, OWB: Not Just for
Data Warehouses (An OWB Eye for the Designer Guy)
John Beresniewicz, Average Active Sessions
Praveen Gowdar,Debugging and Impact Analysis in Oracle Warehouse
Builder
Linda Ruff, Custom Oracle Financial Application
System for Mapping and Interfacing Various Data Sources into Oracle General
Ledger
Gaja Vaidyanatha, Oracle Performance Management—Oracle
Database 9i and Beyond
Presenters
Jon
Arnold, Denver Public Schools
Michael Ault, Burleson Consulting
John Beresniewicz, Oracle Corporation
(CANCELED)
Don Bergal, Confio Software
Chip Briggs
Bradley Brown, TUSC
Donald Burleson, Burleson Consulting
Kevin Closson, Polyserve
Brad
Cowdrey, Clear Peak Solutions
Randy Cunningham, IBM Global
Services
Carol Dacko, University of Michigan
Kirtikumar Deshpande, Verizon
Information Services
Paul Dorsey, Dulcian
Jeff Eberhard, Triumph Gear Systems
Allan Edwards, Integra
Technology Consulting
Debra Elliott, Poudre Valley Health
System
Carel-Jan Engel, DBA!ert
Ron Engels, Denver Public Schools
Daniel Fink
Lowell Fryman, Enterprise Integration
Solutions
David Fuston, IRUS Group
John Garmany, Burleson Consulting
Tim Gorman, SageLogix
Praveen Gowdar, DPS (CANCELED)
Kent Graziano, Denver Public
Schools
Kyle Hailey, Embarcadero Technologies
Stephan Haisley, Oracle Corporation
Sue Harper, Oracle Corporation
Steve Harris
, SageLogix
Rick Hata, Lockheed Martin
Patrick Dugan Holmes, IPC
Ann Horton, Oracle Corporation
Dan Hotka, Training Specialist
Ralph Hughes, Ceregenics
Niklas Iveslatt, SageLogix
Scott Jesse, Oracle Corporation
John King, King Training Resources
Peter Koletzke, Quovera
James Koopmann, Pine Horse
Steve Kosten, Raytheon Company
Suraj Krishnan, Oracle Corporation
Keith Laker, Oracle Corporation
Susan Lee, SageLogix
Steve Lemme, Computer Associates
Dustin Marx &
William Jackson, Raytheon Company
Robert Mason, EchoStar Communications
Gregory Matus, Greg Matus &
Associates
Bryan Merchant, Corporate Express
Michael Mesaros, Oracle Corporation
Timothy Mishek, SAIC
Lynn Munsinger, Oracle Corporation
Jeff Needham, Scale Abilities
Mogens Nørgaard, Miracle
A/S
Raymond Obuch, U.S. Geological Survey
Bonnie O'Neil, PPC, Data Warehousing
Chris Ostrowski, TUSC, Application
Development
Raj Pal, EchoStar Satellite
George Peck, The Ablaze Group
Mark Pelzel, TUSC
Tanel Poder, Independent Consultant
Marshall Presser, Oracle Corporation
Tuomas Pystynen, Deepbase Consulting
Sri Rajan, Churchill Software
Michael Reed &
Marshall Presser, Oracle Corporation
Olivier Ricordel, Oracle Corporation
Linda Ruff, SageLogix (CANCELED)
Bert Scalzo, Quest Software
Roger Schrag, Database Specialists
Craig Shallahamer, OraPub
Terry Sutton, Database Specialists
Kyaw Than, Jefferson County Government
Gaja Vaidyanatha, Embarcadero Technologies
(CANCELED)
Jon Warnick, Double Eagle Group
Harry Wong, Oracle Corporation
Graham Wood, Oracle Corporation
Back
to top
Presentations
by Author
Jon
Arnold, Denver Public Schools
Jon Arnold has been a member of RMOUG and ODTUG since 1995. He has served
on the RMOUG board. He has an M.S. from the University of Denver in computer
science and worked as an Oracle developer and DBA for 14 years. Jon is
a senior technical architect for Denver Public Schools.
Data Warehousing
OWB 101: Populating the Data Warehouse (ETL the Easy Way)
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.
Michael
Ault,
Burleson Consulting
Mike Ault is a well-known Oracle expert with over 15 years of Oracle experience.
Mike has written over 24 books concerning Oracle and has presented at
dozens of conferences. Mike is a frequent contributor to SELECT Journal.
Database
Administration
Welcome to My Nightmare—The Common Performance Errors in Oracle
Databases
This presentation highlights the "heavy hitter" issues commonly
seen in Oracle databases.
Back
to top
Don
Bergal,
Confio Software
Don Bergal is the chief operating officer at Confio and has over 15 years
of experience in the software, services, and data communications industries,
most recently with software developers Jabber, Inc., and Antepo, leading
companies in the XMPP Instant Messaging market. Prior to joining Jabber,
Don was a founding member of the management team at wireless data service
provider Wireless Telecom (acquired by Vaultus). Don earned a B.S. in
engineering from the University of Michigan and an M.B.A. from the Harvard
Business School.
Technology
Management
The Oracle Server: The Black Box in the J2EE World
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.
Back
to top
Chip
Briggs
Chip Briggs began his professional career as an MVS systems programmer
taking care of complex mainframe computers so other people could do their
work. Chip has been using Oracle since 1995 (version 6). His Oracle experience
started with providing application support for a vendor product and grew
to include production database administration on Unix and Windows NT/2000/XP/2003.
Along the way, Chip became an Oracle Certified Professional DBA for Oracle
7.3, 8, 8i, 9i, and 10g.
Database
Administration
RMAN 101 (with Crashes & Demos)
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).
Back
to top
Bradley
Brown,
TUSC
Bradley D. Brown is chairman of the board, chief architect, and cofounder
of TUSC. In 2002, he added the development and release of "Periscope,"
breakthrough software that successfully selects data from other data sources
(i.e., Microsoft Access, Sybase, SQL Server, DB2, etc.) to his list of
accomplishments. In December 2004, Brad added Oracle Application Server
10g, coauthored with Christopher Ostrowski, to the list of best-selling
Oracle books he has written in the past decade. In 2005 he released a
fifth title, Oracle HTML DB Handbook. Along with cofounders Richard J.
Niemiec and Joseph C. Trezzo, Brad won the Ernst & Young Entrepreneur
of the Year Award in 2001 in the category of "E-developer" and
was inducted into the Chicago-Area Entrepreneurship Hall of Fame in 1998.
Application
Development
Transforming Oracle Data into ANY Format Using XML
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.
Data Warehousing
Building a Virtual Data Warehouse
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 don’t 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.
Web, Internet/Intranet
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 one hour you'll learn
how to quickly develop an application using JDeveloper 10g.
Back
to top
Donald
Burleson, Burleson Consulting
Don Burleson is very active in the Oracle community and has written 32
books, published more than 100 articles in national magazines, and serves
as senior consulting editor for DBAZine and series editor for Rampant
TechPress. Don is a popular lecturer and teacher and is a frequent speaker
at OracleWorld and other international database conferences. As a corporate
database consultant, Don has worked with numerous Fortune 500 corporations
creating robust database architectures for mission-critical systems.
Application
Development
Oracle 10g SQL Tuning Secrets
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.
Database
Administration
Inside the Oracle 10g Cost-Based SQL Optimizer
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.
Back
to top
Kevin
Closson,
Polyserve
Kevin Closson is a chief software architect with PolyServe, Inc. His 16-year
career has included engineering, technical support, and application development
positions specializing in Oracle and clustered platforms. Previously Kevin
held positions within IBM, Sequent Computer Systems, and Veritas where
his main engineering focus was port-level throughput and scalability enhancements
of the Oracle server on high-end Unix® SMP and Clustered Systems.
Kevin holds patents in SMP locking algorithms and database caching methods,
is a frequent speaker at industry trade shows, and is a member of The
OakTable Network. In addition to book collaborations, Kevin's written
works have appeared in Oracle Magazine, Oracle Internals Magazine, and
SELECT Journal.
Database
Administration
Scalable, Fault-Tolerant NAS for Oracle—The Next Generation
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.
Back
to top
Brad
Cowdrey, Clear Peak Solutions
Brad Cowdrey is a partner and data warehouse architect with Clear Peak
Solutions, in Littleton, Colorado. He brings over 14 years of professional
experience in the IT industry with leadership expertise in the delivery
of enterprise data warehouse and data-driven solutions to the clients
he serves. His knowledge spans many technologies, with strength in relational
database, extract, transform, and load (ETL), OLAP, reporting, campaign
management, and data mining technology.
Data Warehousing
Oracle Techniques for Integrating and Querying Unstructured Data
Unstructured data, such as files and documents, is a largely untapped
resource in many organizations. Oracle supports the development of next
generation business intelligence (BI) solutions by providing functionality
to store, integrate, and query unstructured data alongside traditional
structured data in the relational database. This presentation will explore
how to integrate and query unstructured data with structured data using
practical examples, that include syntax and behavior. Learning from the
examples combined with a solid understanding of their data, attendees
will be able to apply strategies and approaches to leverage these Oracle
features.
Data Warehousing
Data Warehousing 101
The concepts, approaches, and uses of a data warehouse are 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 warehouse design, development, and use. With this background,
attendees will obtain a better understanding of the terminology, characteristics,
methodologies, and applications of data warehouse solutions.
Back
to top
Randy
Cunningham, IBM Global Services
Randy Cunningham performs Oracle database administration for clients of
IBM Global Services. He has worked with Oracle since version 4, and has
been consulting exclusively to Oracle clients for over 10 years. His primary
focus as a consultant is on the architecture and performance optimization
of ERP and data warehouse applications.
Database
Administration
Deleting LOTS of Data
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
Database Administration
STATSPACK and the Production DBA
Determining the cause of a performance problem after the fact has always
been difficult. This presentation will discuss a few examples of real
production performance problems and how STATSPACK assisted in the problem
determination. The use of the timed events summary from STATSPACK will
be the launching pad for the analysis. With this information, the analyst
will gain more confidence in diagnosing performance issues.
Back
to top
Kirtikumar
Deshpande, Verizon Information Services
Kirtikumar Deshpande works for Verizon Information Services as a senior
Oracle database administrator. He has over 25 years of IT experience in
various capacities, including over 11 years as an Oracle DBA. He coauthored
two Oracle Press books, Oracle Performance Tuning 101 and Oracle Wait
Interface—A Practical Guide to Performance Diagnostics & Tuning.
He is a frequent speaker at various Oracle conferences in the U.S. and
abroad.
Database
Administration
Oracle 10g Streams: Data Replication Made Easy
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.
Back
to top
Paul
Dorsey,
Dulcian
Dr. Paul Dorsey is the founder and president of Dulcian, Inc., an Oracle
consulting firm specializing in business rules and web-based application
development. He is the chief architect of Dulcian's Business Rules Information
Manager (BRIM®) tool. Paul is the coauthor of seven Oracle Press books
on Designer, database design, Developer, and JDeveloper, which have been
translated into nine languages. He is the president of the New York Oracle
Users’ Group and a contributing editor of the International Oracle
User Group’s SELECT Journal. Paul is also the founder and chairperson
of the ODTUG Business Rules Symposium, (now called Web Architecture Symposium),
and the J2EE SIG.
Application
Design
Repository-Based J2EE Development
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.
Application Development
Ultra High-Performance SQL and PL/SQL in Batch Processing
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.
Back
to top
Jeff
Eberhard, Triumph Gear Systems
Jeff Eberhard has been an Oracle DBA and developer for over 7 years and
has worked in the IT industry for over 11 years. He is an active volunteer
of UTOUG (Utah Oracle Users Group) and has previously presented at UTOUG
and RMOUG Training Days. Currently, he is an employee of Triumph Gear
Systems.
Web, Internet/Intranet
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 will also demonstrate how development is done
using the browser interface. Examples of finished projects using HTML
DB will be given.
Back to top
Allan
Edwards, Integra Technology Consulting
Allan Edwards is 21 Oracle veteran and President of Northeast Oracle User
Group. As Managing Partner at Integra Technology Consulting, Allan focuses
on solving strategic business problems through reasonable, practical application
of technology (often incorporating Oracle technology). Allan prefers business
challenges which are extreme in at least one of the following dimensions:
business criticality, scale/volume, performance, complexity, availability,
or cost/effectiveness.
Database Administration
SOX 101 - intro to Sarbanes-Oxley from Administrator's Perspective
SOX is an unknown beast and threat. The objective of this session is
to provide a concise introduction to the definition and history of SOX,
and some
key implications for database administrators and dba/application managers.
SOX
section 404, Internal Controls, will be emphasized.
Back
to top
Debra
Elliott,
Poudre Valley Health System
Debra Elliott works as a database administrator/programmer in the Information
Services Department at Poudre Valley Health System in Fort Collins, Colorado.
She has a master's degree in mechanical engineering from Colorado State
University and has worked in the IT/IS field for the last 6 years, supporting
and developing various types of business applications that use both Oracle
and SQL Server databases.
Web, Internet/Intranet
Case Study: Implementing Usage and Performance Monitoring in Oracle
Portal
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.
Back
to top
Carel-Jan
Engel, DBA!ert
Carel-Jan Engel is from the Netherlands and has worked in the IT industry
since 1982. His Oracle experience started in 1985, using version 4. He
has been an independent consultant since 1992, and specializes in high
availability, especially Oracle Data Guard. Carel-Jan is a member of The
OakTable Network.
Database
Administration
Struck by Disaster
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 symmetric
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.
Database
Administration
High Availability Inside Out
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.
Back
to top
Ron
Engels, Denver Public Schools
Ron Engels is metadata manager and a database administrator in the Department
of Technology Services at the Denver Public Schools. He has worked with
Oracle products for 6 years, dividing his time the last 3 between OLTP
maintenance and data warehouse implementation.
Data Warehousing
Oracle Warehouse Builder Best Practices
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.
Back
to top
Daniel
Fink
Daniel Fink is a senior Oracle Database engineer and member of The OakTable
Network. He has worked with Oracle for 10 years, starting with Oracle
7.0 Parallel Server on OpenVMS. His focus has been on production support,
internals, troubleshooting, and optimization.
Application
Development
Effective Use of DBMS_METADATA
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.
Application
Development
Oracle Optimization and Troubleshooting for Developers
"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.
Back
to top
Lowell
Fryman, Enterprise Integration Solutions
Lowell Fryman is founder of Enterprise Integration Solutions LLC, specializing
in training and services in the data integration industry. Lowell is a
Certified GIF™ Architect and has been recognized by Bill Inmon as
a contributor to a number of his books. He has developed technology best
practice courses and trained thousands of professionals in data warehousing,
data quality, project management, and enterprise application development.
Lowell has implemented enterprise metadata programs, technology evaluations,
and business intelligence Centers of Excellence for two major international
corporations.
Data Warehousing
Taking Data Quality Metrics to the Boardroom: A Case Study
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.
Back
to top
David
Fuston, IRUS Group
David Fuston is a principal consultant at the IRUS Group, Inc., a business
and technology provider. He has been a technical and functional consultant
since 1989, with experience in applications development, IT management,
and has held financial controller positions for Fortune 500 companies
such as Corning, Revlon, Ingersoll-Rand, BTR, and Siegel-Robert. David’s
core expertise includes customizations and extensions in Oracle applications
and functional skills in data warehousing, business intelligence, and
reporting. He is a nationally recognized technical author and IT conference
speaker. His educational background includes a B.S. in business administration
and an M.B.A.
Data Warehousing
Oracle Applications and Data Warehousing—An Oxymoron?
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.
Back
to top
John
Garmany, Burleson Consulting
John Garmany is a graduate of West Point and a retired Lt. Colonel with
more than 20 years of IT experience. John is an OCP Certified Oracle DBA
with a master's degree in information systems, a graduate certificate
in software engineering, and a B.S. degree in electrical engineering from
West Point. He is a senior consultant with Burleson Consulting and author
of the Oracle Replication Handbook and Easy Oracle SQL by Rampant TechPress,
Oracle 10g Application Server Handbook by Oracle Press, and Logical Database
Design by CRC Press.
Technology
Management
Feel Secure with SSH
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.
Database Administration
Soup Up Your Syntax - Make the Move to SQL-99
This presentation will be an introduction to the SQL-99 Syntax and
why you should use it.
Database Administration
Clone That Database - The Hot, the Cold, the RMAN Way
This session will discuss the options for cloning, moving, or rebuilding
an Oracle database.
Back
to top
Tim
Gorman, SageLogix
Tim Gorman began his IT career in 1984 as a "C" programmer on
UNIX and VMS systems, and now specializes in performance tuning applications,
databases, and systems, as well as data warehouse design and implementation,
backup and recovery, architecture and infrastructure, and database administration.
He joined Oracle Corporation in 1990 as a consultant and has worked for
SageLogix since 2000. Tim is coauthor (with Gary Dodge) of Essential Oracle8i
Data Warehousing (2000) and Oracle8 Data Warehousing (1998) from John
Wiley & Sons.
Data Warehousing
Scaling to Infinity—Partitioning Data Warehouses in Oracle
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.
Back
to top
Kent
Graziano, Denver Public Schools
Kent Graziano is the manager for enterprise data integration in the Department
of Technology Services at the Denver Public Schools in Denver, Colorado.
Kent is the past president of RMOUG, the past president of ODTUG, and
was the first dean of the IOUG University. He has over 21 years of software
and applications development experience, with the last 17 years devoted
to Oracle, Oracle Designer, data warehousing, and Oracle Discoverer. He
is a coauthor of The Data Model Resource Book and Oracle Designer: A Template
for Developing an Enterprise Standards Document.
Data Warehousing
Poor Man’s Change Data Capture: Using DECODE
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.
Technology
Management
Data Design Reviews: Using Extreme Humiliation to Insure Quality Data
Models
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.
Back
to top
Kyle
Hailey, Embarcadero Technologies
Kyle Hailey has been in the industry for a decade and a half and working
with Oracle for over 13 years, having spent time in support, porting,
benchmarking, and kernel development at Oracle. After creating tools to
improve high-end performance monitoring such as direct SGA attach and
interactive graphic displays of performance data, he recently made major contributions to the redesign of
the Oracle Enterprise Manager 10g performance pages, making them graphically
oriented and wait-interface centric. He now works at Embarcadero on their
suite of performance tuning and monitoring tools.
Database
Administration
Average Active Sessions—A New Tuning Paradigm
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.
Database
Administration
New Performance Tables, View, and Algorythms in 10g
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.
Back
to top
Stephan
Haisley, Oracle Corporation
Stephan Haisley originally joined the U.K. Oracle Worldwide Support group
in 1996 and has since worked in various technical support groups within
Oracle. Currently he is a member of the Center Of Expertise, a small group
within Oracle’s Support Services that specializes in complex problem
resolution and internals of the database kernel. Stephan spends much of
his time, when not teaching database internals classes or fixing customer
issues, trying to figure out why Oracle works the way it does and then
documenting it in a more readable manner.
Database
Administration
Optimizing Oracle Backup and Recovery Operations
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.
Back
to top
Sue
Harper, Oracle Corporation
Sue Harper is a product manager in the Database Development Tools group,
based in Reading U.K. Sue has been at Oracle since 1992, initially with
an Oracle subsidiary in South Africa. Her roles have been varied and include
being an instructor, consultant, course developer, and product manager.
As a product manager for the past number of years, she was very involved
with Designer and more recently focused on JDeveloper, helping customers
transition to this new technology space. Sue has now joined the Database
Development Tools group as a product manager with a focus on the new database
development tools emerging from this group.
Application
Development
Raptor: Introducing Oracle's New Graphical Database Development Tool
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 PL/SQL? 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.
Back
to top
Steve
Harris, SageLogix
Steve Harris is an accomplished software development professional with
over 15 years of J2EE architecture and development experience. He has
over 4 years of experience developing Oracle-based solutions utilizing
Oracle's JPDK and Portal and extensive real-world implementation experience,
resulting in solid best practices and methodologies.
Application
Development
Rapid Development Utilizing a Service-Oriented Architecture (SOA)
and the Oracle Application Server with Oracle Portal
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.
Back
to top
Rick
Hata, Lockheed Martin
Rick Hata is a senior software engineer with Lockheed Martin IT. Rick
has over 19 years of experience architecting, developing, and supporting
custom applications, and for the last 12 years has used Oracle products.
Application
Development
Anatomy of an Analytic SQL Function
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’ve 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 doesn’t provide the clarification you need
to utilize analytic functions, I’ll provide examples to give you
that x-ray vision into the analytic function.
Back
to top
Patrick
Dugan Holmes, IPC
Pat Holmes is vice president of technology for IPC-The Hospitalist Company,
a healthcare company that hires doctors that work in hospitals. He is
an expert in Oracle development, and has lectured extensively on various
Oracle developer topics, both as a classroom trainer and as a presenter
at numerous Oracle conferences including IOUG-Live, OOW, and ODTUG. He
is also president of the Los Angeles Oracle Users Group (LAOUG).
Application
Development
Cool Tools I Use: Demonstrating Useful PL/SQL and SQL Programming
Tools
This presentation demonstrates a number of “cool tools” that
make PL/SQL and SQL programming easier. The products demonstrated include:
Allround Automation’s PL/SQL Developer (a fabulous PL/SQL IDE, including
step-wise debugging!), TextPad (the best text editor!), ExamDiff Pro (great
for file comparisons), a Search-and-Replace tool, some very low-cost ERD
reverse-engineering and design tools, SQLWays (a great database migration
tool), File-Locator-Pro (finding files), V-The File Viewer (the best file-viewer!),
febooti (command-line email), Time-Target (batch-job scheduling), Quest’s
Formatter Plus (for reformatting PL/SQL and SQL), Snag-IT (best screen
capture!), WinTail (Windows “tail” utility), and other tools
and tips.
Back
to top
Ann
Horton, Oracle Corporation
Ann Horton is a senior principal consultant for Oracle Corporation's Software
Engineering Consulting team where she is currently focused on the development
of J2EE applications using Oracle's Fusion Middleware technologies, including
JDeveloper and the Oracle Application Server. Ann is a frequent presenter
at RMOUG and other Oracle user group conferences, and has extensive experience
training corporate and university students in Oracle technologies.
Application
Design
UML Modeling with JDeveloper 10.1.3
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.
Back
to top
Dan
Hotka, Training Specialist
Dan Hotka is a training specialist who has over 27 years in the computer
industry and over 22 years of experience with Oracle products. He is an
internationally recognized Oracle expert with Oracle experience dating
back to the Oracle version 4.0 days. Dan’s latest book is Oracle
10g on Linux by Oracle Press. He is also the author of Oracle9i Development
By Example and Oracle8i from Scratch by Que and has coauthored 6 other
popular books. He is frequently published in Oracle trade journals and
regularly speaks at Oracle conferences and user groups around the world.
Application
Development
Discoverer 10g Tips and Techniques
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.
Database
Administration
Tuning SQL When You Cannot Change the Code!
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.
Back
to top
Ralph
Hughes, Ceregenics
Ralph Hughes M.A., has been contracting on OLTP and OLAP projects since
1988 and has recently completed 4 years of data warehousing projects with
the pharma/bio med sector and defense contractors. He holds a Project
Management Professional (PMP) certificate from the Project Management
Institute and is the founder of the Denver chapter of the World Wide Institute
of Software Architects.
Data Warehousing
Accelerating Data Warehouse Development with EAV Data Modeling
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.
Back
to top
Niklas
Iveslatt, SageLogix
Niklas Iveslatt began his career in 1992 programming C++ and Assembler
on the Intel Platform. In 1995, he became involved in a database performance
tuning project and has been working on various Oracle projects in Europe
and the U.S. ever since. Niklas specializes in systems performance tuning,
high availability and Oracle Application Server solutions. Niklas is a
senior consultant at SageLogix, Inc., and has achieved both Oracle and
UNIX professional certifications.
Data Warehousing
Intelligent Optimizer Statistics
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.
Back
to top
Scott
Jesse, Oracle Corporation
Scott Jesse has worked for Oracle Support Services for nearly 10 years,
and is currently a member of the High Availability Advanced Resolution
Team. Scott is the coauthor of two Oracle Press Titles, including Oracle9i
for Windows 2000 Tips & Techniques and Oracle Database 10g High Availability
with RAC, Flashback, and Data Guard. In addition, Scott is a contributor
to a new magazine on Oracle technology called OraTips.
Database
Administration
Oracle Database on Windows: Best Practices
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.
Back
to top
John
King, King Training Resources
John King is a partner in King Training Resources, a firm providing instructor-led
training since 1988 across the United States and internationally. John
specializes in application development software on a variety of platforms.
He has worked with Oracle products and the database since version 4. John
develops and presents customized courses in a variety of topics including
Oracle, DB2/UDB, SOA, Java, XML, .NET, and C++. John presents frequently
at various industry conferences.
Application
Design
SOA What? Introduction to Service-Oriented Architecture
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.
Application
Development
Oracle 10g/9i for Developers: What You Need to Know
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.
Application
Development
Ready, Set, XML! Using Oracle XML Data
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.
Back
to top
Peter
Koletzke, Quovera
Peter Koletzke is a technical director and principal instructor for the
Enterprise e-Commerce Solutions practice at Quovera, in Mountain View,
California, and has over 20 years of industry experience. Peter has presented
at various Oracle user group conferences and has won many awards. He is
an Oracle Certified Master and coauthor, with Dr. Paul Dorsey, of the
Oracle Press (McGraw-Hill Osborne) books: Oracle JDeveloper 10g Handbook
and Oracle9i JDeveloper Handbook (also coauthored with Avrom Roy-Faderman),
Oracle JDeveloper 3 Handbook, Oracle Developer Advanced Forms and Reports,
Oracle Designer Handbook, 2nd Edition, and Oracle Designer/2000 Handbook.
Application
Development
JDeveloper 10g Web Application View Layer Alternatives
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.
Application
Development
Application Development Tuning Best Practices
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.
Application
Development
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 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.
Back
to top
James
Koopmann, Pine Horse
James F. Koopmann is founder of Pine Horse, Inc. (www.pinehorse.com),
and creator of www.dbcorral.com. He is dedicated to providing technical
advantage and guidance to companies within the database industry. Over
the years James has worked with a variety of database-centric software
and tools vendors as strategist, architect, DBA, and performance expert.
He is an accomplished author with articles appearing in publications including
Oracle Professional, Database Trends and Applications, DatabaseJournal.com,
and various vendor newsletters.
Application
Development
In the Beginning There Was SQL
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.
Database
Administration
A Primer on Globalization
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 didn’t
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.
Back
to top
Steve
Kosten, Raytheon Company
Steve Kosten is a senior software engineer working with Raytheon and has
10 years of experience in the software engineering field. He presented
at RMOUG Training Days 2005 and is a Java Certified Developer.
Application
Development
An Introduction to Aspect-Oriented Programming Using JDeveloper
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.
Back
to top
Suraj
Krishnan, Oracle Corporation
Suraj Krishnan has 12 years of experience in IT in the areas of database
administration, product development, and project management and has consulted
for several of the Fortune 1000 companies worldwide. He has a master's
in computer science and a master's in business administration. He currently
works for Oracle Corporation in the Advanced Product Support group.
Technology
Management
Security and Regulatory Compliance with Oracle
The last decade has seen a proliferation of regulations aiming at protecting
and enhancing security of data. It is imperative that organizations and
individuals responsible for architecting and implementing security fully
comprehend and leverage their existing Oracle investment. This presentation
expounds on the infrastructure provided by Oracle in terms of various
security and auditing features to not just satisfy regulatory compliance
but go beyond to develop a framework to manage risks in an e-business
environment.
Back
to top
Keith
Laker, Oracle Corporation
Keith Laker has worked for Oracle for 9 years, in both using and supporting
Oracle's various data warehousing and business intelligence solutions
and products. As part of Oracle Consulting, Keith has worked on many large
scale implementations for both U.K. and multinational companies. His last
position before moving to Product Management was as technical gold support
manager for EDS/Inland Revenue. Keith is now part of the Data Warehouse
Product Management Team based at Redwood Shores, is an active member on
the OTN forum community, and is also one-half of the BI blog team.
Data Warehousing
Transforming Data into Quality Information with Oracle Warehouse Builder
10gR2
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.
Data Warehousing
Climb to the OLAP Summit with Oracle Warehouse Builder 10gR2
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.
Back
to top
Susan
Lee, SageLogix
Susan Lee is a senior systems administrator/integrator at SageLogix, Inc.,
in Denver. She has extensive experience in a variety of platforms and
products and is now working on best practices for Oracle AS10g, implementing
complex solutions and architectures for multiple clients.
Web, Internet/Intranet
AS10g Configuration—The Nightmare That Became the Dream
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.
Back
to top
Steve
Lemme, Computer Associates
Steve Lemme is a director of product management at Computer Associates
International, Inc., (CA) for the Unicenter Database Management product
solutions. He joined CA in 1993 upon its acquisition of Platinum Technology
International, Inc., where he was responsible for product management and
marketing for distributed database tools. Steve is the author of Implementing
and Managing Oracle Databases and is an accomplished enterprise architect
and Oracle Master DBA, with more than 14 years of experience in distributed
database architecture and internet computing. He serves as a director
on the IOUG board, is vice president of the Arizona Oracle Users Group,
and is a monthly columnist for Database Trends and Applications magazine.
Technology
Management
What Does Sarbanes-Oxley Have to Do with the Management of Databases?
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.
Technology
Management
Religion, Revelation, Revolution! Best Practices and Projects for
Managing Databases
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.
Back
to top
Dustin
Marx & William Jackson, Raytheon Company
Dustin Marx, a senior software engineer and architect at Raytheon Company,
has been a regular presenter at recent RMOUG Training Days conferences.
Dustin's article "Add Some Spring to Your Oracle JDBC" was recently
published on Oracle Technology Network.
Web, Internet/Intranet
Riding Rails to Ruby and Riches
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).
Back
to top
Robert
Mason, EchoStar Communications
Robert Mason is an IT professional with 20 years of experience working
in various capacities, such as software engineering, database administration,
database architecture, and IT management. He is working towards his Ph.D.,
where his dissertation is in the area of AspectJ Persistence Testing.
Application
Development
Aspect-Oriented Software Development (AOSD) Using Oracle 10g
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.
Back
to top
Gregory
Matus, Greg Matus & Associates
Greg Matus is the chief instructor and curriculum developer with Greg
Matus & Associates, a high-end Oracle, Java, and XML training company.
Greg has been a developer for over 10 years, working as a consultant with
companies such as Motorola and the Gap, and as a Java, Oracle, and XML
instructor for U.S. government agencies and research facilities, state
universities, and corporations large and small, all across the U.S. and
Canada. Greg has presented at Oracle OpenWorld and at various user groups,
including ODTUG.
Application
Development
The Leap from PL/SQL to Java: More Than Just Syntax
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.
Back
to top
Bryan
Merchant, Corporate Express
Bryan Merchant is manager, Database Services, for Corporate Express. He
is an Oracle Certified Professional, has been working with Oracle since
Oracle 7, and is currently working primarily with Oracle9i and 10g. Bryan's
development background led him into the DBA environment.
Database
Administration
Not Just a DBA
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.
Back
to top
Michael
Mesaros, Oracle Corporation
Michael Mesaros is a director of product management for Oracle's Identity
Management and Security solutions. An 11-year veteran of Oracle, Michael
has held product management responsibilities for Oracle networking, groupware,
database security, and directory products. Prior to joining Oracle, he
was responsible for marketing computer-aided engineering design tools
for digital signal processing and control systems at Integrated Systems
Inc. (now Wind River Systems). Michael is a member of the Institute of
Electrical and Electronic Engineers and holds an M.S. in electrical engineering
from San Diego State University in San Diego, California. He also has
an M.B.A., a B.S.E. in electrical engineering, and a B.S. in cellular
Biology, all from the University of Michigan in Ann Arbor, Michigan.
Network Administration
Access and Identity Management for Enterprise Portals
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.
Back
to top
Timothy
Mishek, SAIC
With over 9 years of Oracle DBA and application development experience
from MCI, Channelpoint, and DMCare, Tim Mishek continues to be an active
IT professional with consulting, training, and educational projects. He
has experience with both database development and production support.
Currently Tim works for SAIC as an Oracle database administrator at the
Air Force Academy supporting users within the 10th medical group.
Database
Administration
My Database Backups Are Working? Really They Are!
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!
Back
to top
Lynn
Munsinger, Oracle Corporation
Lynn Munsinger is a principal product manager in the Java Tools Development
group at Oracle, specializing in EJB, TopLink, and ADF. She has been working
at Oracle since 1998, initially in product support, and then as a curriculum
developer for JDeveloper courses. She is the author of many Oracle University
courses, including, "Oracle 10g: Build J2EE Applications,”
and is a frequent presenter at user group and industry conferences.
Application
Development
Introduction to Oracle JDeveloper 10g
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.
Application
Development
Simplify J2EE Development with Oracle Application Development Framework
(ADF)
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.
Application
Development
J2EE Application Development for Forms and Designer Users
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.
Back to top
Jeff
Needham, Scale Abilities
Jeff Needham is the president of Scale Abilities, Inc., which provides
performance and architectural services to companies with extraordinary
requirements for their Oracle computing platforms. In conjunction with
the UK-based Scale Abilities, Ltd., Jeff is one of the original members
of the OakTable Network.
Database
Administration
Oracle Commodity Computing on the AMD64 Platform
This session will provide an overview of 64-bit Oracle commodity
computing.
Back to top
Mogens
Nørgaard, Miracle A/S
Mogens Nørgaard was a real DBA before joining Oracle Support in
Denmark for 10 years— ending up as head of Premium Services. He
cofounded Miracle A/S in 2000, which provides consulting, support, training,
and licensing advisory on Oracle and SQL Server in Denmark.
He was the first Oracle manager to standardize his group's performance
optimization methods exclusively upon Oracle's response time statistics.
He is one of the founders of the Danish Oracle User Group, the OakTable
Network, the Miracle Breweries A/S—and the BAARF movement.
Keynote
Moans, Groans, and IT 2006?
This keynote will provide the audience with a list of relevant IT-related
predictions for the year 2006, including some secret Gartner and IDC reports
that will (not) be published in the coming months regarding ERP and CRM
projects, the true meaning of the M in XML, Failure-Based IT (FBI), the
latest on processors, and much more.
Application Development
JSF on High-Availability in the 21st Century
Kevin Closson and Mogens Nørgaard will provide you with a tour-de-force
of the high-availability options that you can use today, apart from all
the good old things like standby databases, RAC, and disk mirroring.
Kevin was an architect on the Sequent computers, and today is leading
the development of Polyserve's CFS and knows more about Oracle's code
than most people on the Planet, while Mogens spends his time having lunches
with other directors or talking to other directors on his mobile.
Application Development
No, We're STILL not Tuning the Right SQL Statements!
Over the last 10 years, we have learned to follow the time (FTT), trace
the right things at the right interval, locate the heaviest SQL statement,
and so on. Unfortunately, in many cases this will still lead
you to focus on and tune the wrong SQL statements. This presentation will
also cover Groundhog Day Tuning, a scientific method widely used in the
Oracle community to very little effect.
Back
to top
Raymond
Obuch, U.S. Geological Survey
Raymond Obuch is an Oracle DBA for Energy Resource Surveys Team, USGS.
He has worked with Oracle since 1995, using his background in Unix administration,
network design, and enterprise architecture. Raymond is the USGS representative
for data management to the Department of Interior Enterprise Architecture
effort. He holds a master's of information systems management, a B.S.
in hydrology, and a B.S. in forestry.
Database
Administration
Oracle9i and ARCSDE 9 Deployment with Linux Red Hat Advanced Server
2.1 Operating System and Dell 2650 Server Architecture
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.
Back
to top
Bonnie
O'Neil, PPC
Bonnie O'Neil is senior technical consultant at Project Performance Corporation,
and is an internationally recognized expert on business metadata, data
architecture, and business rules. She is a regular speaker at many conferences
and was the keynote speaker at an international conference on data quality
in South Africa. Bonnie is the author of two database books including
Oracle Data Warehousing Unleashed, as well as over 40 articles and technical
white papers. She is a Certified CIF/GIF Architect and is a certified
trainer for Bill Inmon.
Data Warehousing
Of Wikipedia and Dictionaries: Dictionary on a Shoestring!
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.
Technology
Management
Data Archeology: A Day in the Life of an Integration Consultant
This presentation explores the complexities of integration from the semantic
perspective. An archeologist digs deep into the earth to find treasures,
but then he has to understand what these treasures are and if what he
has found is indeed a treasure, or just part of the earth. In the same
way, "data archeology" explores the data in depth and tries
to understand what is there and make sense of it. This presentation illustrates
that the problem is more than just pattern matching, and shows some solutions
using innovative tools.
Back
to top
Chris
Ostrowski, TUSC
Chris Ostrowski is a technical management consultant for TUSC and has
over 15 years of experience with Oracle technologies. He has presented
at numerous Oracle conferences including OracleWorld, IOUG, and ODTUG,
has been published in SELECT and SQL>Update magazines, and is coauthor
of the Oracle Press book, Oracle Application Server 10g Web Development.
Application
Development
Using JDeveloper to Create and Deploy Portlets
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).
Web, Internet/Intranet
OracleAS Instant Portal: An Introduction
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.
Web, Internet/Intranet
Oracle Application Server 10gR2 New Features
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.
Back
to top
Raj
Pal, EchoStar Satellite
Raj Pal works at EchoStar Satellite LLC as a production database administrator.
He has a B.Sc. in biology from Ontario, Canada, and 6 years of technical
and managerial IT experience using Oracle, Weblogic, and webMethods.
Database
Administration
RMAN and Overall Database Integrity
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.
Back
to top
George
Peck, The Ablaze Group
George Peck is president of The Ablaze Group, Inc., an Evergreen, Colorado-based
professional services firm. He has trained, consulted, and developed custom
software for large and small organizations throughout the United States,
Canada, the United Kingdom, and Puerto Rico. George works as both a trainer
and consultant with various Oracle-related business intelligence products,
including Crystal Reports, Crystal Enterprise, and Crystal Reports Server/BusinessObjects
Enterprise. He is author of six titles in the Crystal Reports: The Complete
Reference series, as well as Crystal Reports Professional Results.
Data Warehousing
Oracle Versus Crystal: A BI Shootout
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.
Back
to top
Mark
Pelzel, TUSC
Mark Pelzel is a senior management consultant with TUSC and has been serving
TUSC customers across the country for more than 10 years. Building on
a strong general development background including PL/SQL, Forms, Reports,
and web application development, Mark currently specializes in implementing
the wide variety of components delivered in Oracle Collaboration Suite.
As a Certified Advantage Partner and repeat Partner of the Year, TUSC
and Mark have partnered with Oracle for the past 4 years to implement
and advance Collaboration Suite for customers from 100 to more than 35,000
users.
Technology
Management
Leveraging Oracle Collaboration Suite to Optimize Business Performance
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.
Back
to top
Tanel
Poder, Independent Consultant
Tanel Poder is an independent consultant with over 10 years in the IT
industry and 7 years of Oracle experience. He is a frequent speaker at
various conferences such as OracleWorld, IOUG-A Live, UKOUG, and Hotsos
Symposium. He has experience building, tuning, and troubleshooting database
systems multiple terabytes in size and with several thousands of concurrent
users. Tanel is also one of the first Oracle Certified Masters in the
world.
Database
Administration
Advanced Research Techniques in Oracle
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.
Back
to top
Marshall
Presser, Oracle Corporation
Marshall Presser is a member of the Enterprise Technology Center at Oracle
Corporation. For the past 7 years he has specialized in Oracle Parallel
Server, Real Application Clusters, Data Guard, and high availability.
He has spoken on RAC at previous RMOUG Training Days.
Database
Administration
Oracle 10gR2 Real Application Clusters—What's New?
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’ll 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.
Back
to top
Tuomas
Pystynen, Deepbase Consulting
Tuomas Pystynen is an independent consultant specializing in Oracle Database
and Application Server products. He worked at Oracle Server Technologies
Division developing and testing Oracle8 and Oracle7 products from 1991
to 1997. He is also a member of The OakTable Network.
Application
Design
Implementing Efficient Search Pages
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.
Back
to top
Sri
Rajan, Churchill Software
Sri Rajan is vice president, Systems Engineering, Churchill Software,
with offices in San Francisco and London. Prior to Churchill, Sri held
technical leadership positions at Oracle Corporation and Hewlett-Packard.
At Oracle for over 8 years, Sri was director of Application Development
Tools and Application Server, spanning product management, product marketing,
technical marketing, and product engineering. He holds a master of science
degree in computer engineering, and a bachelor of science degree in electrical
engineering, both from Carnegie Mellon University.
Application
Development
Repurposing Oracle Forms Assets for a Service-Oriented Architecture
(SOA)
J2EE is widely recognized as a strategic enterprise application development
platform and new Service-Oriented Architectures (SOAs) are being heralded
as the platform for IT agility. This presentation examines the role that
Oracle Forms application software assets and domain-skilled Oracle Forms
developers can play within such application development initiatives. A
method for migrating business logic embedded in existing Oracle Forms
applications will be demonstrated and an approach to integrating and reusing
this code within other J2EE development frameworks such as Hibernate will
be outlined. The presentation will conclude with the benefits of adopting
services as building blocks for the assembly of new applications.
Application
Development
Web Services, Portals, and Business Processes (BPEL4WS) for Forms
Developers
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 communication, and an organization's implicit
workflow as implemented through constructs intrinsic to the programming
model of Oracle Forms. Newer IT initiatives represent an innovative approach
to expose module and application-specific business logic for standards-based
re-use for new J2EE-architected applications. This session explores the
opportunity of standards-based SOA in the context of proven, in-production
Oracle Forms applications.
Back
to top
Michael
Reed & Marshall Presser, Oracle Corporation
Michael Reed is a solution specialist at the Oracle Enterprise Technology
Center. He has 9 years of experience in various roles as a technologist
at Oracle. He currently specializes in Fusion Middleware (Oracle Application
Server), with a focus on high availability and scalability architectures
for the middle tier.
Application
Development
End-to-End High Availability for Your Oracle 10gR2 Database Applications
While Oracle 10g Real Application Clusters (RAC) provides a high availablity
(HA) and scalable database infrastructure, an end-to-end HA strategy for
your enterprise requires coordination between the database and the mid-tier
application server. With the advent of Oracle 10gR2 database and Oracle
Application Server 10.1.3, Oracle assists in this coordination with Fast
Application Notification (FAN) and Fast Connection Failover (FCF). This
session will include a brief discussion of RAC and the service architecture
underlying Oracle10gR2 and discuss ONS and FAN events as seen by both
the database server and subscribers in Oracle Application Server. Finally,
we’ll demonstrate setting up JDBC connection pools to take advantage
of FAN events to enable true application HA.
Back
to top
Olivier
Ricordel, Oracle Corporation
Olivier Ricordel is senior product manager in the Oracle Portal product
management team, guiding and evangelizing the portlet development tools.
Olivier joined Oracle in 2004 after more than five years at Autodesk,
where he worked in the CTO office of the Geospatial division, responsible
for bringing web services and XML open standards into the company portfolio
of products. Olivier started his career in 1996 as a business analyst
and software engineer for JP Morgan, working on the bank's first global
large scale fixed income trading application using the Java technology.
Olivier holds an M.S. degree in computer science.
Application
Design
Fuse Your Enterprise Business Applications with Your Portal
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.
Web, Internet/Intranet
Bring the Java World and Web Services into Your Portal
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.
Back
to top
Bert
Scalzo, Quest Software
Bert Scalzo is a product architect for Quest Software and a member of
the TOAD development team. He designed many of the features in the TOAD
DBA module. Bert holds several Oracle Masters, a B.S., M.S., and Ph.D.
in computer science, an M.B.A. and several insurance industry designations.
His key areas of DBA interest are Linux and data warehousing (he designed
7-Eleven Corporation's multi-terabyte, star-schema data warehouse). Bert
has written many articles and three books: Oracle DBA Guide to Data Warehousing
and Star Schemas, TOAD Handbook, and TOAD Pocket Reference.
Database
Administration
Optimizing Oracle Server Performance on LINUX
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.
Database
Administration
Lessons Learned During 10 Node Linux RAC Deployment
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.
Back
to top
Roger
Schrag, Database Specialists
Roger Schrag, OCP, has been an Oracle DBA and application architect for
over 15 years. He started at Oracle Corporation on the Oracle Financials
development team. In 1995, Roger founded Database Specialists, Inc. He
is a frequent speaker at Oracle OpenWorld, RMOUG, NoCOUG, and the IOUG
- Live conferences, where he has been voted into the Top 10 percent of
speakers many times. Roger is currently the director of Conference Programming
for the Northern California Oracle Users Group (NoCOUG).
Database
Administration
An Oracle 10g Upgrade Case Study: Looking at System Performance Before
and After the Upgrade
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.
Database
Administration
How Much Do Concurrent Updates Impact Query Performance in Oracle?
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.
Back
to top
Craig
Shallahamer, OraPub
A recognized Oracle server authority, Craig Shallahamer spent 9 years
at Oracle Corporation. He left Oracle in 1998 to start OraPub, Inc., a
company focusing on "doing and helping others do" both reactive
and proactive Oracle performance management. He has personally trained
over 1,000 DBAs on five continents in 13 countries. Craig is also the
key designer and engineer behind HoriZone, OraPub's performance forecasting
product.
Database
Administration
Modern Performance Myths or Wait Interface Deceit
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.
Technology
Management
Essential Performance Forecasting
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.
Back
to top
Terry
Sutton, Database Specialists
Terry Sutton has been an Oracle DBA for 12 years, and has worked in the
information technology area for 19 years. Since 2000, Terry has been a
senior staff consultant at Database Specialists, performing assignments
ranging from production database administration to emergency troubleshooting,
with a particular focus on Oracle Database performance tuning. He has
been a speaker at the RMOUG, NoCOUG, and IOUG-Live conferences, as well
as the Hotsos Symposium and various local user groups.
Database
Administration
What's Up with dbms_stats?
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.
Back
to top
Kyaw
Than, Jefferson County Government
Kyaw Than has worked for Jefferson County since 2003 as a Unix systems
administrator and Oracle DBA, with some Informix and Postgresql thrown
in as well. Prior to that, he worked for the Provincial Government in
Manitoba, Canada. He has been a DBA for the last 15 years, including a
long stint with Ingres, some MS SQL Server, then Oracle since Oracle 7.
Kyaw has been a presenter at 2004 and 2005 RMOUG Training Days and holds
a master's degree in computer science from Rangoon University.
Database
Administration
Employing Open-Source Software on Linux to Administer Oracle Databases
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.
Back
to top
Jon
Warnick, Double Eagle Group
Jon is a DBA with over 10 years of experience in development, production,
and system administration roles. He has developed database applications
for domestic and international clients.
Database
Administration
Managing Response Times at 100% CPU Utilization (Or How to Delay a
CPU Upgrade)
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.
Back
to top
Harry
Wong, Oracle Corporation
Harry K. Wong is principal product manager on the Content Management and
Publishing Team within Oracle Portal Product Management. His responsibilities
include managing the Oracle Portal Customer Advisory Board and guiding
development of portal lifecycle utilities, amongst other areas. A native
of Northern California, Harry began his career at INGRES Corporation as
a UNIX Porting Engineer. Harry holds a B.A. degree in computer science
from the University of California at Berkeley.
Web, Internet/Intranet
Unleash the Power of Portal Publishing
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.
Back
to top
Graham
Wood, Oracle Corporation
Graham Wood is an architect in database development at Oracle. Most of
his 20 years of Oracle experience have been spent in performance-related
areas including designing and tuning large high-performance systems, benchmarking
and building monitoring tools (such as Statspack). More recently, Graham
has worked as part of the Oracle 10g Manageability team tasked with simplifying
the process of tuning the operation of the database.
Database
Administration
Oracle Database 10g Release 2 Performance Diagnosis Feature Update
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.
Database
Administration
Sifting Through the ASHes: Performance Analysis with the Oracle 10g
Active Session History
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.