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
Oracle Forms
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
New Objects
Partitioning
Sarbanes-Oxley - HIPAA Compliance
Triggers
Tuning SQL and PL/SQL
Writing PL/SQL Packages
Writing Stored Procedures
|
|
11g Resumable
Transactions
|
 |
|
High availability is not
something that can be achieved with one or two built-in
capabilities. A RAC cluster with DataGuard replication can
still fall on its face if you run out of disk space or an
application exceeds its space quota.
The Resumable Transactions
workshop is a hands-on lab in which students learn to
implement resumable transactions for tables, clusters,
indexes, tablespaces, and partitions. This 3 hour evening workshop is priced at only
$100/person.
|
|
Syllabus
|
| 5:45-6:00pm |
Registration |
Join us for coffee
while you register. |
| 6:00-7:00pm |
Discussion |
Resumable
Transactions and High Availability
This discussion covers the concepts and
technologies required to put together a
high-availability architecture of which Resumable
Transactions is just one component.
We cover the error and object types that can
trigger a resumable transaction and skills
required to make use of this built-in capability
including:
- AFTER LOGON
system event triggers
- ALTER SESSION
- ALTER SYSTEM
- UTL_MAIL
|
| 7:00-8:00pm |
Lab 1 |
Manual
Declaration of Resumable Sessions
In this hands-on lab we use ALTER SESSION and
ALTER SYSTEM to create resumable sessions and test
them in situations such as NO MORE SPACE and SPACE
QUOTA EXCEEDED with tables and indexes. |
| 10:30-10:45am |
Lab 2 |
Automating
the Declaration of Resumable Sessions
In this hands-on lab we automate the creation,
monitoring, and handling of resumable sessions
using AFTER LOGON system event triggers, space
auditing, and notification with UTL_MAIL. |
|
|
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.
|
|
