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
Applications Series
E-Business Suite
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 New
Features for DBAs
|
 |
Why should I care about the
new features? Everything is running just fine.
- Meet service level
agreements
- Disaster recovery
- Disaster avoidance
- Improved performance and
scalability
- Enhanced security
- Sarbanes-Oxley, FACT,
and HIPAA compliance and auditing
- Enhanced productivity
- Lower cost of management
|
|
The PSOUG's 11g New Features
can be taught as a 1, 2, 3, 4, or 5 day course depending
upon the features included and the amount of time devoted
to hands-on workshops. Our emphasis is not on what you
could licsense but rather on what you have already
licensed. The syllabus, below, shows the topics covered as
well as the fact that this class is taught live in the
database: Not slow
death by PowerPoint. $450/student per day.
|
|
Day 1
|
| 8:30-9:00am |
Registration |
Join us for coffee and pastries while you register. |
| 9:00-9:30am |
Discussion
1 |
Physical
Layout Changes
In 11g Oracle has made changes to the basic to the
physical layout of the database. Initialization
parameters that have existed for more than a
decade are deprecated. |
| 9:30-10:00am |
Lab 1 |
Physical
Layout Review Lab
The backup and recovery lab gives students the
ability to implement block change tracking and
perform level 0 and level 1 (incremental) backups. |
| 10:00-10:30am |
Discussion
2 |
Flashback
With 10g Oracle introduced 6 different flashback
technologies and the recyclebin. In 11g
three of these have been expanded and extended
with Flashback Archive. |
| 10:30-11:00am |
Lab
2 |
Flashback
Archive Lab
Students will have an opportunity during this lab
to gain hands-on familiarity with one or two of
the new flashback technologies. Open labs at the
end of the day provide students the ability to
further explore these or any other topics covered. |
| 11:00-12:00pm |
Discussion
3 |
Maintenance
Many new technologies have been introduced that
make database maintenance easier, faster, and more
capable. This discussion will cover Consumer
Groups, Contexts (including setting modules and
action), the new DBMS_SCHEDULER built-in package,
Resource Management, and the creation of database
services with the DBMS_SERVICES package. This
discussion will take SOA from the realm of
marketing hyperbole to usable technology |
| 12:45-2:00pm |
Lab
3 |
Resource
Management and Consumer Groups Lab
The Database Resource Manager provides the ability to prioritize work within the Oracle system. High priority users get resources, so as to minimize response time for online workers, for example, while lower priority users, such as batch jobs or reports, could take longer. This allows for more granular control over resources and provides features such as automatic consumer group switching, maximum active sessions control, query execution time estimation and undo pool quotas for consumer groups.
This lab gives students hands-on experience create
consumer groups and implementing plans and plan
directives. |
| 2:00-3:00pm |
Lab
4 |
Job
Scheduling with DBMS_SCHEDULER Lab
The DBMS_JOBS built-in package has been deprecated
in favor of the far more capable SCHEDULER. In
this lab students will gain hands on experience
translating a job from DBMS_JOBS to DBMS_SCHEDULER
and learn to use the Scheduler to improve upon the
capabilities of much of what has traditionally
been done with shell scripts. |
| 3:00-4:00pm |
Lab
5 |
Services
and SOA Lab
In this instructor led lab we implement database
services and implement them using System
Event Triggers. In later labs these services will
be used to implement tracing and resource
management. |
| 4:00-5:00pm |
Open
Lab |
Open
Lab
This lab is an opportunity for students to
continue work, with instructor support, on any of
the day's topics. |
|
|
Day 2
|
| 8:30-9:00am |
Registration |
Join us for coffee and pastries while you register. |
|
| 9:00-9:30am |
Discussion
4 |
Storage |
| 9:40-10:30am |
Lab
6 |
Transportable
Tablespaces
The fastest, most efficient, method of moving
data from database to database is with
transportable tablespaces. This hands-on session
will consist of students creating tablespaces,
creating and loading tables with indexes, and
transporting their tablespaces to databases
belonging to other students. |
| 10:30-11:30am |
Lab
7 |
Resumable
Transactions
Resumable transaction are transactions that
can be restarted, rather than creating a failure,
due to space management issues. This hands on lab
will create resumable transactions, locate failed
transactions, and restart them. |
| 11:30-12:30pm |
Lab
8 |
Space
Management
Oracle has created the DBMS_SPACE built-in
package to support space management. In this
hands-on lab we will work with this package's most
important procedures and pipelined table
functions. |
| 1:15-2:15pm |
Discussion
5 |
Maximum
Availability Architecture
This discussion will focus on the essential
ellements of creating maximum availability.
We will discuss Data Guard, dynamic
reconfiguration, online redefinition, and Real
Application Clusters (RAC). |
| 2:15-3:00pm |
Discussion
6 |
Compliance
& Security
Compliance and security are topics on which
one could teach a one month class. In this
discussion we will review those features already
built into the SE and EE Oracle databases and that
do not involve new licensing. Along with other
topics we will review the DBMS_CRYPTO and
DBMS_DDL packages, DDL and System Event
Triggers, Fine Grained Access Control, and Valid
Node Checking and how they can be used to meet
Sarbanes-Oxley, FACTA, HIPAA, Basel II, and PIPEDA
requirements. |
| 3:00-3:30pm |
Lab
9 |
Valid
Node Checking
Valid node checking has been in Oracle for a
very long time and has become more important for
security with the move away from client-server and
to application servers. In this lab students will
use this method to allow and block access from
other students to their databases. |
| 3:30-4:00pm |
Lab
10 |
Feature
Usage
One essential aspect of compliance is
monitoring your feature usage of your Oracle
database in conjunction with your license. In this
hands-on lab students work with the two Feature
Usage packages and learn how to leverage them to
monitor usage of internally developed features. |
| 4:00-5:00pm |
Open
Lab |
Open
Lab
This lab is an opportunity for students to
continue work, with instructor support, on any of
the day's topics. |
|
|
Day 3
|
| 8:30-9:00am |
Registration |
Join us for coffee and pastries while you register. |
| 9:00-9:45am |
Lab
11 |
Row
Dependencies
Now, by using the ROWDEPENDENCIES keyword and
the new ORA_ROWSCN pseudocolumn we can gain
valuable information to help with auditing and
compliance. This workshop focuses on these
capabilities and integrating them with various
forms of Flashback technology. |
| 9:45-10:30am |
Lab
12 |
Fine
Grained Auditing
Compliance, with all regulatory and internal
requirements, often focuses on knowing the
providence of information as well as when it has
been viewed and by which system users. This
hands-on FGA lab will teach the implementation and
deployment of auditing for SELECT, INSERT, UPDATE,
and DELETE statements. |
| 10:30-12:00pm |
Discussion
7 |
Tuning
The alphabet soup has gotten thicker. This
discussion will shine a bright light on ADDM, ASH,
and AWR. What they are, how they work, and how
they can be leveraged effectively.
We will also discuss the changes made to the
COMMIT statement and the implications to system
performance of cursor sharing and the collection
of dictionary and system optimizer statistics. |
| 1:00-2:00pm |
Lab
13 |
Advanced
Rewrite
Tuning SQL can be infinitely more difficult
when that SQL is embedded in a commercial
application and you can't change it. Well couldn't
change it. With the new DBMS_ADVANCED_REWRITE
package and some work snooping around the SGA it
is possible to identify the statements and have
Oracle rewrite them inside the optimizer. This lab
is 100% hands-on. |
| 2:00-3:00pm |
Lab
14 |
Advisor
& SQLTUNE
With 10g and the Grid
Control Tuning Pack we now have the new
DBMS_ADVISOR and DBMS_SQLTUNE packages. This lab
will quickly bring DBAs up to speed on how to use
them to find "best solutions" for
intractable tuning problems. |
| 3:00-4:00pm |
Lab
15 |
Monitoring
and Tracing
It used to be that our
databases were client server. We could identify
users by user-id and session, trace them, and kill
them when they perfected the infinite loop. Now
with the DBMS_MONITOR we have a single interface
that allows us to trace sessions or services,
trace applications or modules. This lab is hands
on and allows DBAs to solve a real-world problem. |
| 4:00-5:00pm |
Open
Lab |
Open
Lab
This lab is an opportunity for students to
continue work, with instructor support, on any of
the day's topics. |
|
|
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.
|
|
