|
Rampant IOUG Collaborate 2006 Conference
Speakers
Rampant TechPress is honored to have the
following authors accepted for sessions at the IOUG 2006
conference in Nashville Tennessee. The
IOUG Collaborate 2006 Conference is the largest and most
highly-respected Oracle conference in America. This IOUG
2006 conference has a who's Who of the top names in the Oracle
industry, a no-not-miss conference for all Oracle professionals.
Rampant TechPress authors have been chosen for 19 sessions at
the IOUG 2006 conference, a record for any Oracle publisher in
the world.
-
Mike Ault - Author of “Oracle9i
RAC”, “Oracle 10g grid & RAC”, “Conducting the Oracle job
Interview”, “Oracle Tuning Powerscripts”, “Oracle Disk I/O
Tuning”, “Oracle RAC and Grid with Solid-state disk”
-
Robert Freeman - Author of
"Oracle Replication”
-
Don Burleson – Author of “Oracle
Tuning: The Definitive Reference”, “Oracle Silver Bullets”,
“Creating a self-tuning database”, “Conducting the Oracle
Job Interview”
-
John Garmany – Author of “Easy
Oracle SQL” and “Easy Oracle PL/SQL”, and “Oracle
Replication”
-
Arun Kumar – Author of “Easy
Oracle Automation”
-
Daniel Liu – author of “Oracle
10g new features”
-
Dave Moore – author of “Oracle
Utilities”
-
Arup Nanda – author of “Oracle
privacy security auditing”
-
Madhu Tumma – Author of “Oracle
Streams” and “Oracle 10g Grid & RAC”
Mike Ault
Mike Ault
is is a Senior Oracle Consultant with
Burleson Consulting, and one
of the leading names in Oracle technology. The author of
more than 20 Oracle books and hundreds of articles in national publications,
Mike Ault has five Oracle Masters Certificates and was the first popular Oracle author with his landmark
book "Oracle7 Administration and Management". Mike also
wrote several of the "Exam Cram" books, and enjoys a
reputation as a leading author and Oracle consultant.
| |
Welcome to my Nightmare - The common performance errors
in Oracle Databases |
| |
Ault, Michael R.
|
| |
Intermediate
|
| |
Developer |
| |
Tuesday, Apr 25, 2006 |
| |
9:45 AM - 10:45 AM |
| |
Gaylord Opryland
Resort - Canal A |
| |
512 |
| |
As a Oracle database
tuning and implementation consultant I spend a great
deal of time examining clients systems for performance
issues and making specific recommendations how these
performance issues can be solved. In this presentation I
distill out the things I see most often and how to
correct them to get the best performance from your
Oracle system. |
Don Burleson
Donald
K. Burleson is one of the world’s top Oracle
Database experts with more than 20 years of full-time DBA
experience. He specializes in creating database
architectures for very large online databases and he has worked
with some of the world’s most powerful and complex systems.
| |
Oracle predictive modeling |
| |
Burleson, Donald K.
|
| |
Advanced
|
| |
DBA |
| |
Sunday, Apr
23, 2006 |
| |
8:30 AM - 4:30
PM |
| |
Gaylord
Opryland Resort - Bayou C |
| |
U3 |
| |
Those who
cannot remember the past are condemned to repeat
it, and this is especially true for those who
use Oracle Discoverer and Oracle data mining for
analyzing historical data and identifying
significant correlations. Oracle professionals
are now applying the techniques of predictive
modeling to Oracle performance data and using
the gold mine of information in STATSPACK and
AWR to develop Oracle tuning models.
This paper will examine the types of data
stored inside STATSPACK and AWR and examine
techniques for trend identification and
predictive modeling. Using these techniques
Oracle professionals remove the guesswork from
change to the Oracle instance and provide a
framework for gathering evidence to justify
database changes.
This is an indispensable presentation for any
Oracle developer and DBA who assumes
responsibility for making system-wide Oracle
database changes
|
| |
Oracle10g Wait Event Tuning with the Automated
Session History Tables |
| |
Burleson, Donald K.
|
| |
Intermediate
|
| |
DBA |
| |
Monday, Apr
24, 2006 |
| |
1:00 PM - 2:00
PM |
| |
Gaylord
Opryland Resort - Canal A |
| |
431 |
| |
Oracle 10g has
greatly improved the wait event information in
Oracle10g, providing the Oracle professional
with an unparalleled opportunity for detecting
and correct database bottlenecks. This
presentation will show the internal structures
of the ASH tables and highlight the important
wait events within the tables. The attendee will
see simple scripts for identifying the top wait
events over time, and see how to quickly
drill-down to find the cause of the bottleneck.
Best of all, this presentation will show how
to perform time-series wait event analysis.
Oracle bottlenecks are very transient and unique
combinations of events create unique
bottlenecks. This paper shows working scripts
that are used in real-world Oracle 10g databases
to detect repeating patterns of bottlenecks and
show hidden events that are often too transient
to see with real-time monitors. This
presentation is indispensable for the Oracle
professional who wants to know how to use ASH to
automate the tedium of
|
| |
Tuning Tips for Oracle Application Server 10g |
| |
Burleson, Donald K.
|
| |
All
|
| |
Application
Server & Web Services |
| |
Tuesday, Apr
25, 2006 |
| |
9:45 AM -
10:45 AM |
| |
Gaylord
Opryland Resort - Canal E |
| |
100 |
| |
Oracle
Application Server 10g has evolved into a
complex network of interrelated products. This
presentation will focus on managing the
interfaces between Portal, OHS, web cache and
the infrastructure server. From the author of
the Oracle Application Server 10g Administration
Handbook by Oracle Press, this presentation will
explore the improved management features of
9.0.4 and show actual examples of using the
Oracle Application Server 10g Enterprise Manager
console to perform Oracle Application Server 10g
tasks.
This session will focus on the techniques
used by Oracle professionals to detect and
correct performance bottlenecks in Oracle
Application Server 10g.
Topics will include monitoring techniques for
Oracle Application Server 10g including J2EE,
web cache, and the Oracle HTTP server. We will
also explore tuning techniques with a focus on
tuning the web cache, minimizing network traffic
between the Oracle Application Server 10g
servers, and infrastructure tuning technique
|
| |
Tuning Tips for Oracle Application Server 10g |
| |
Burleson, Donald K.
|
| |
All
|
| |
Application
Server & Web Services |
| |
Tuesday, Apr
25, 2006 |
| |
11:00 AM -
12:00 PM |
| |
Gaylord
Opryland Resort - Canal E |
| |
100 |
| |
Oracle
Application Server 10g has evolved into a
complex network of interrelated products. This
presentation will focus on managing the
interfaces between Portal, OHS, web cache and
the infrastructure server. From the author of
the Oracle Application Server 10g Administration
Handbook by Oracle Press, this presentation will
explore the improved management features of
9.0.4 and show actual examples of using the
Oracle Application Server 10g Enterprise Manager
console to perform Oracle Application Server 10g
tasks.
This session will focus on the techniques
used by Oracle professionals to detect and
correct performance bottlenecks in Oracle
Application Server 10g.
Topics will include monitoring techniques for
Oracle Application Server 10g including J2EE,
web cache, and the Oracle HTTP server. We will
also explore tuning techniques with a focus on
tuning the web cache, minimizing network traffic
between the Oracle Application Server 10g
servers, and infrastructure tuning technique
|
| |
Beyond Oracle10g – A look at the future of
Oracle in the 21st Century |
| |
Burleson, Donald K.
|
| |
All
|
| |
Architecture &
Infrastructure |
| |
Wednesday, Apr
26, 2006 |
| |
3:15 PM - 4:15
PM |
| |
Gaylord
Opryland Resort - Bayou C |
| |
215 |
| |
Oracle has
always been very predictable and this
presentation will explore Oracle’s long-term
commitment to improving Oracle in the 21st
Century. Combining Oracle new features with
changes in technology, this dynamic presentation
will explore how Oracle will change in the next
decade. The presentation will explore the new
technology movements such as server
consolidation, the death of client-server and
the new solid-state storage systems. We will
also explore the new Oracle features and examine
Oracle’s progress in automation, management and
monitoring.
We will examine the use of artificial
intelligence inside Oracle from its modest
beginnings with Oracle Expert to the new Oracle
diagnostic and recommendation engines. We will
look at the evolution of Oracle monitoring from
bstat-estat to the new 10g kernel-based monitors
and speculate about the advances in future
releases of Oracle.
|
|
Robert Freeman
Robert G. Freeman
is a Senior Oracle Consultant with
Burleson Consulting.
Freeman one of the most famous Oracle experts and author
of eight popular Oracle books, including Oracle9i RMAN Backup &
Recovery and the bestselling Oracle9i and Oracle 10g New Features books.
| |
Preparing the begining DBA for Collaborate06 |
| |
Freeman, Robert
|
| |
Beginner
|
| |
DBA |
| |
Sunday, Apr 23, 2006 |
| |
8:30 AM - 4:30 PM |
| |
Gaylord Opryland
Resort - Canal A |
| |
U6 |
| |
This full day session
will be designed to provide the begining DBA training on
administration of the Oracle Database. In addition, each
individual topic area will be assocaited with suggested
Collaborate06 sessions that will provide additional
detail on the topic at hand.
Oracle DBA topics covered in this session include
Oracle database architecture overview, Creation and
administration of Oracle Databases, and Backup and
Recovery of Oracle databases. |
John Garmany
John Garmany is a
Senior Oracle DBA
with Burleson Consulting. A graduate of West Point, an
Airborne Ranger and a retired Lt. Colonel with 20+ years of IT
experience. John is an OCP Certified Oracle DBA with a Master
Degree in Information Systems, a Graduate Certificate in
Software Engineering, and a BS degree (Electrical Engineering)
from West Point.
|
|
Being Regular with Regular Expressions |
| |
Garmany, John
|
| |
All
|
| |
Developer |
| |
Monday, Apr
24, 2006 |
| |
2:15 PM - 3:15
PM |
| |
Gaylord
Opryland Resort - Canal D |
| |
520 |
| |
This
presentation will explain the why and how of
using regular expression with Oracle. Unix SAs
know the power of matching with regular
expression and now the Oracle DBA and Developer
can put that power to use. But regular
expressions are not the only (of even the best)
answer in all situations. We will cover your
regular expression options in SQL, PL/SQL and
Java. While most DBAs do not use Java, it does
provide a rich and powerful regular expressions
capabilities that SQL and PL/SQL do not have.
Improper use of regular expression can have a
large negative impact on database performance.
The presentation will explain the pros and cons
of each method and when they can best be
utilized to provide you with high performance
matching capability. |
|
Arun Kumar
Dr. Arun Kumar
R. is an expert in architecting, implementing, and
trouble-shooting large-scale, highly complex systems using
Oracle technologies. Dr. Kumar has more than a decade of
experience in Oracle Database Administration, including
multidimensional, decision support systems and ERP software.
Dr. Kumar has worked on a wide variety of projects and
environments ranging from client-server, E-Business to managed
services across multiple relational database systems in
telecommunications, retail and health care industries.
|
|
Proven Strategies for Successful Upgrades to
Oracle Database 10g |
| |
Kumar R., Arun
|
| |
All
|
| |
DBA |
| |
Monday, Apr
24, 2006 |
| |
10:30 AM -
11:30 AM |
| |
Gaylord
Opryland Resort - Bayou B |
| |
429 |
| |
Oracle
Database 10g has been officially launched to the
public at the beginning of 2004 with a variety
of novel architecture changes over its previous
versions. It is the most complex and powerful
database ever created among competing database
technologies. So why are companies not fully
utilizing the improved features and benefits by
upgrading their databases to Oracle Database
10g? This paper will analyze the issues haunting
the upgrade to the new release and tested
strategies to mitigate the risks involved in the
upgrade process. This paper will also cover the
various steps involved in upgrading previous
versions of Oracle databases as well as
migrating from other database vendors to Oracle
Database 10g.
|
|
|
Better Database Insight with Advisory Framework |
| |
Kumar R., Arun
|
| |
Beginner
|
| |
DBA |
| |
Monday, Apr
24, 2006 |
| |
2:15 PM - 3:15
PM |
| |
Gaylord
Opryland Resort - Canal B |
| |
444 |
| |
Oracle
Database 10g has been built with utilities aimed
solely at automating and simplifying routine
database management tasks. The database has a
built-in sophisticated self-management
infrastructure to know more about its operation
and provide solutions to avoid any potential
problem during its operation. This is
accomplished through various server components,
which collects statistics automatically and
provide feedback about resource utilization and
performance. Using these advisors in Oracle
Database 10g, the DBA can get a better insight
about the database and its sub-components. This
paper will give detailed knowledge on making the
most of database advisors, insights on their
operation, and optimize the time spent on
performance tuning and maintenance efforts.
|
|
Daniel Liu
Daniel Liu is a senior Oracle Database
Administrator at First American Real Estate Solutions in
Anaheim, CA. He has many years of industry experience in
database administration and software development. He has
worked with large-scale databases in multi-platform
environments. His expertise includes Oracle database
administration, performance tuning, Oracle networking, and
Oracle Application Server.
|
|
Oracle Database 10g: Data Guard, Streams, and
RAC |
| |
Liu, Daniel
|
| |
Intermediate
|
| |
DBA |
| |
Sunday, Apr
23, 2006 |
| |
8:30 AM - 4:30
PM |
| |
Gaylord
Opryland Resort - Bayou E |
| |
U5 |
| |
This one-day
technical session is designed for Oracle
professionals to gain in-depth knowledge of
Oracle Database 10g’s top three
High-Availability solutions – Data Guard,
Streams, and RAC. It offers an introduction to
the basic concepts and architectures of the
three products. It discusses the requirements
and steps to setup each high availability
solutions. It provides the performance analysis
and implementation tips of the three products.
The session will help users to choose and
implement the right technologies to solve their
business problems.
|
|
|
Oracle 10g Data Pump: High-Speed Data Movement
Utilities |
| |
Liu, Daniel
|
| |
Intermediate
|
| |
DBA |
| |
Tuesday, Apr
25, 2006 |
| |
3:30 PM - 4:30
PM |
| |
Gaylord
Opryland Resort - Canal E |
| |
414 |
| |
Oracle
Database 10g has introduced the new Export and
Import Utilities – Data Pump. The new Data Pump
facilities are designed to be complete
replacements for the original Export and Import
utilities (exp and imp) and can perform tasks in
minutes that previously took hours or even days.
The presentation provides and overview of the
Data Pump Utilities in Oracle Database 10g. The
session offers an introduction to the basic
concepts and architectures of Data Pump. It
discusses in details on how to use the new Data
Pump Utilities: expdp and impdp. This session
also compares the original Export and Import
Utilities with the new Data Pump Utilities.
|
|
|
Oracle 10g Data Pump: High-Speed Data Movement
Utilities |
| |
Liu, Daniel
|
| |
Intermediate
|
| |
DBA |
| |
Tuesday, Apr
25, 2006 |
| |
4:45 PM - 5:45
PM |
| |
Gaylord
Opryland Resort - Canal E |
| |
414 |
| |
Oracle
Database 10g has introduced the new Export and
Import Utilities – Data Pump. The new Data Pump
facilities are designed to be complete
replacements for the original Export and Import
utilities (exp and imp) and can perform tasks in
minutes that previously took hours or even days.
The presentation provides and overview of the
Data Pump Utilities in Oracle Database 10g. The
session offers an introduction to the basic
concepts and architectures of Data Pump. It
discusses in details on how to use the new Data
Pump Utilities: expdp and impdp. This session
also compares the original Export and Import
Utilities with the new Data Pump Utilities.
|
|
|
Oracle 10g New Features for DBA |
| |
Liu, Daniel
|
| |
All
|
| |
DBA |
| |
Thursday, Apr
27, 2006 |
| |
8:30 AM -
12:30 PM |
| |
Gaylord
Opryland Resort - Canal C |
| |
U19 |
| |
Oracle
Database 10g, next-generation database, is the
industry's first designed for grid computing.
Grid computing reduces the cost of IT by
clustering servers together to act as a single
large computer, dynamically shifting server
resources between applications on demand. Daniel
Liu, the co-author of Oracle 10g New Features
for the DBA by Rampant TechPress, will introduce
the new features in Oracle Database 10g Release
1&2. Those topics include: new initialization
parameters, Automatic Storage Management (ASM),
Cross Platform Transportable tablespaces, new
SYSAUX tablespace, high-speed Data Pump utility,
extended Flashback functions, RMAN enhancements,
Column-level Virtual Private Database (VPD),
database tuning and performance improvement,
high availability improvements in Real
Application Clusters (RAC), Data Guard, Oracle
Streams, and more. The topics covered in this
seminar are primary for the database
administrators. |
|
Dave Moore
Dave Moore has over
13 years of experience in Information Technology - as a DBA
and as a developer specializing in Oracle, Java and PL/SQL. Dave has presented at OracleWorld and is a frequent
contributor to Oracle Professional and
DBAZine. He holds
a BS in Information Systems from Western Carolina University.
Dave lives with his wife and three children in Austin, Texas.
| Title: |
Oracle Trace Analysis on Steroids – An In-Depth Look at
Trace Analyzer |
| Speaker: |
Moore, Dave
|
| Expertise: |
All
|
| Focus Area: |
DBA |
| Date: |
Monday, Apr 24, 2006 |
| Time: |
10:30 AM - 11:30 AM |
| Venue/Room: |
Gaylord Opryland
Resort - Canal A |
| Paper Num: |
452 |
| Abstract: |
Forget all the
inferior Oracle tracing diagnostic tools. We’ve all used
autot in SQL*Plus and the tried and true tkprof. These
tools are useful in their own way but neither are as
powerful as Trace Analyzer. Available only via a
metalink download, this open source gem provides a gold
mine of information to the Oracle technologist. This
session will review everything that Trace Analyzer can
do and compare it to the other well known trace file
diagnostic tools. |
Arup Nanda
Arup Nanda is the recipient of the
coveted DBA of the Year 2003
award by Oracle Corporation. This award is among the most highly
respected in the database industry,
and each year only one of more than a quarter million Oracle
professionals are honored by this distinction. A decade of
experience as a DBA has
made Arup an expert in many Oracle areas including Oracle Design,
Oracle Modeling, Oracle Performance Tuning and Oracle
Backup & Recovery.
| Title: |
Secure your Oracle Database Infrastructure in Phases |
| Speaker: |
Nanda, Arup
|
| Expertise: |
All
|
| Focus Area: |
DBA |
| Date: |
Sunday, Apr 23, 2006 |
| Time: |
8:30 AM - 4:30 PM |
| Venue/Room: |
Gaylord Opryland
Resort - Bayou A |
| Paper Num: |
U1 |
| Abstract: |
Most DBAs are so
absorbed in the day to day administration of the
database that they tend to overlook some of the most
imprtant elements - security being one. With today's
environment with myriads of laws and regulations,
security is not just a nice-to-have anymore, it's a
requirement. So, how do you plan for a secure database
infrastructure without being overwhelmed?
This calls for a phased approach. This session will
show that tasks can be broken into four phases - done in
a day, in a week, in a month and finally six months. At
the end of each period, you will have accomplished
almost everything that is needed for an acpetablly
secured database. The attendees will learn from small
matters such as the permission flags of the oracle
executable to advanced topics like Virtual Private
Database. Special emphasis will be placed on regulations
such as HIPAA, SOX and GLBA. The courseware will include
tear-away cheatsheets to help the attendees remember
exactly what to do. |
Madhu Tumma
Madhu Tumma has been working as Software
Developer, IT
Manager, Database Administrator, and Technical
Consultant for about 18 years. He has worked on a wide
variety of projects and environments ranging from
mainframe, client-server, eBusiness to managed services. He
has provided consultancy to variety of clients on database
clusters, business continuity and high availability solutions.
|
|
A practical guide to ASM |
| |
Tumma, Madhu
|
| |
Intermediate
|
| |
DBA |
| |
Thursday, Apr
27, 2006 |
| |
11:00 AM -
12:00 PM |
| |
Gaylord
Opryland Resort - Bayou A |
| |
425 |
| |
Oracle has
provided the ASM (automatic storage management)
with its 10g database release two years ago.
While many of us were on sidelines and began
wondering if it is viable alternative for the
traditional file systems, 10gR2 has added some
more functionality with the release of command
line interface and other enhancements. No doubt,
ASM is here to stay.
This session discusses ASM role and utility.
Especially for RAC implementation, think ASM as
the clustered file system and volume manager in
a box. The main objective of this session is to
provide a practical guide for the use and
management of the ASM. This session goes beyond
the basics and covers some of the mainteance
issues one could face while handling the ASM
entities. It also discusses many best practices
and considerations.
|
|
|
A practical guide to ASM |
| |
Tumma, Madhu
|
| |
Intermediate
|
| |
DBA |
| |
Thursday, Apr
27, 2006 |
| |
12:00 PM -
1:00 PM |
| |
Gaylord
Opryland Resort - Bayou A |
| |
425 |
| |
Oracle has
provided the ASM (automatic storage management)
with its 10g database release two years ago.
While many of us were on sidelines and began
wondering if it is viable alternative for the
traditional file systems, 10gR2 has added some
more functionality with the release of command
line interface and other enhancements. No doubt,
ASM is here to stay.
This session discusses ASM role and utility.
Especially for RAC implementation, think ASM as
the clustered file system and volume manager in
a box. The main objective of this session is to
provide a practical guide for the use and
management of the ASM. This session goes beyond
the basics and covers some of the mainteance
issues one could face while handling the ASM
entities. It also discusses many best practices
and considerations. |
|
|
