Home
Maximum Availability Series
Automated Storage Management (ASM)
Data Guard
Dynamic Reconfiguration
Flashback
Grid Control
Online Redefinition
Real Application Clusters (RAC)
Resumable Transactions
DBA Series
11g New features for DBAs
Audit Vault
Disaster Prevention and RMAN
Managing Terabyte Databases
Oracle Security Workshop
Sarbanes-Oxley & HIPAA Compliance
Developer Series
11g New Features for Developers
Advanced Queuing and Streams
Array Processing and Bulk Binding
Exception Handling
Procedures, Functions, & Packages
Security and Fine Grained Access Control
SQL and PL/SQL Tuning
SwingBench Installation & Configuration
Triggers
Fusion Middleware Series
Oracle Application Server
Oracle Identity Management
Independent Classes
Interviewing and Hiring Oracle Pros
Oracle for DB2/UDB DBAs & Developers
Oracle for Informix DBAs & Developers
Oracle for SQL Server DBAs & Developers
Oracle for Sybase DBAs & Developers
UNIX, Linux and vi
Evening Workshops
Constraints
Exception Handling
Functions & Pipelined Table Functions
Interviewing
Linux and UNIX Skills
Loops Cursors and Array Processing
Materialized Views
Sarbanes-Oxley - HIPAA Compliance
Triggers
Tuning SQL and PL/SQL
Writing PL/SQL Packages
Writing Stored Procedures
|
|
11g Dynamic
Reconfiguration
|
 |
Why Dynamic Reconfiguration is
important to your operations.
- An integral part of a
high availability strategy
- Changing hardware
changes optimizer assumptions
- Resizing memory and
optimizing memory usage
- Resizing and optimizing
the undo tablespace
- Reconfiguring storage
dynamically without affecting availability
|
The PSOUG's Dynamic
Reconfiguration class is part
of our Maximum Availability series and is presented as a
hands-on evening workshop.
How is PSOUG's Dynamic Reconfiguration class different, and we think better,
than anyone else's? To be honest we think it may be the
only one that exists. What we have done is pull together the
most important capabilities for dynamically reconfiguring
an on-line production database while meeting your Service
Level Agreement (SLA)
All student's learn the
material on their own server with Oracle Unbreakable Linux
4 and the 11gR1 database and all labs are hands-on in a class with
no more than 7 other students.
During the class students learn the concepts, architecture,
implications, how to reconfigure the system, and when it is and
is not best practice to do so. The
syllabus, below, shows the topics covered as well as the
fact that this class is hands-on: Not slow death by
PowerPoint. $100/person.
|
|
Day 1
|
| 8:00-8:30am |
Registration |
Join us for coffee and pastries while you register. |
| 8:30-9:30am |
Discussion 1 |
Oracle's
Dynamic Reconfiguration capabilities allow a DBA to dynamically accommodates various changes to hardware and database
configurations while keeping the system available
for end users in compliance with application
Service Level Agreements.
|
| 9:30-11:00am |
Lab 1 |
SPFILE
Params, alter system and alter session
This hands-on workshop focuses on the use of the
dynamic nature of parameter setting with an SPFILE
to change memory allocation, optimizer
configuration, undo tablespace retention targets,
and other facets of implementing a maximum
availability architecture.
We will have a RAC Cluster available so that
students can practice these skills in both
stand-alone and RAC environments. |
| 11:00-12:30am |
Lab
2 |
Automated
Storage Management
One big piece of the dynamic reconfiguration
puzzle is using ASM to reconfigure storage. ASM
can add volumes, drop volumes, create failover
groups, and more without taking the system
off-line. We will practice these skills on our
lab's NetApp F270c Filer. |
|
|
Instructors |
Dan Morgan is an Oracle Ace Director, a
10g and 11g Beta tester for Oracle, and the instructor of
the Oracle program at the University of Washington since
its inception in 1999. He began his IT career in 1969 with
an IBM 370/145, punch cards, and Fortran IV, and though he
will vigorously deny it, wrote COBOL for a decade before
moving into Oracle about when version 6 hit the market.
In addition to Dan's work at the university he is the
Education Chair of the Puget Sound Oracle Users Group, a
member of UKOUG, and a member of the British-American
Chamber of Commerce in Seattle. He is also a frequent
lecturer at training events and at conferences and has
presented at Oracle OpenWorld on RAC (2005), at Seattle
OracleDay (2004-2007), at numerous government and
corporate training events including Apple Computer,
Argonne National Laboratory, Boeing Commercial Airplane
Group, Dow Jones & Company, Lawrence Livermore
National Laboratory, NASA, T-Mobile, US Navy at Pearl
Harbor, and Weyerhaeuser to name but a few and presented
on Streams and Change Data Capture at UKOUG in 2006.
Dan Morgan is the Morgan behind the "Morgan's
Library" website that contains the many demos he has
created for his University of Washington classes as well
as for his frequent lectures. He is the former publisher
of MacTech Journal, has presented Oracle technical
lectures in the US, Canada, Great Britain, and Japan.
Morgan is also the author of this course.
|
|
