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
Partitioning
Sarbanes-Oxley & HIPAA Compliance
Developer Series
11g New Features for Developers
Advanced Queuing and Streams
Array Processing and Bulk Binding
Exception Handling
Oracle Forms
Partitioning
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
Sarbanes-Oxley - HIPAA Compliance
Triggers
Tuning SQL and PL/SQL
Writing PL/SQL Packages
Writing Stored Procedures
|
|
11g Partitioning
& Subpartitioning
|
 |
Ten years ago we talked
megabytes, five years ago gigabytes, today almost everyone
has terabytes of data. In 11gR1 Oracle has extended the
definition of a tablespace to include Petabytes and
Exabytes. The trend is not going to change. Databases are
getting bigger: A lot bigger.
This change makes possessing the skills for managing large databases
more and more important. Here is what we cover in our one
day, hands on, partitioning class:
- Hash partitioning and
subpartitioning
- Interval partitioning
- List partitioning and
subpartitioning
- Range partitioning and
subpartitioning
- Partitioning Index
Organized tables
- Partitioning with LOB
segments
- Partitioning by
Reference (foreign key)
- Virtual column
partitioning
- Altering partitions
- Merging partitions
- Dropping partitions
- Indexing partitions
including the use of the
DBMS_INDEX_UTL built-in package
- Tuning with paritioning
- Partition pruning
This one day class is $500/person.
|
|
[an error occurred while processing this directive]
|
|
Syllabus
|
| 8:30-9:00am |
Introductions |
Join us for coffee and pastries while you
complete your registration.
To attend this class you must register at least
one day in advance. |
| 9:00-10:00am |
Discussion |
Partitioning
Concepts and Architecture
The discussion focuses on the issues related
to working with and maintaining very large
databases and the concepts and architecture of
partitioned and composite partitioned tables.
The instructor will demonstrate the basic
techniques with heap and index-organized tables as
well as with tables containing LOB segments. |
| 10:00-11:30am |
Lab
1 |
Hands-on
Partitioning
This lab is designed to give students an
opportunity to work with all aspects of building
partitioned tables under the
guidance of the instructor. Students will build
the following partitioned tables:
- Hash partition
- Interval
partition
- IOT partition
- List partition
- LOB partition
- Range partition
- Referential
partition
- Virtual column
partition
With each table
type students will have an opportunity to load the
table with data and observe its behavior using
EXPLAIN PLAN and Autotrace.
|
| 11:30-12:30pm |
Lunch |
Lunch |
| 12:30-1:30pm |
Lab
2 |
Hands-on
Composite Partitioning
This lab is a hands-on opportunity for
studnets to build composite partitioned tables under the
guidance of the instructor. Students will build
the following tables:
- List List
- List Range
- Range Hash
- Range List
- Range Range
With each table
type students will have an opportunity to load the
table with data and observe its behavior using
EXPLAIN PLAN and Autotrace.
|
| 1:30-2:30pm |
Lab
3 |
Partition
Alteration
This hands-on lab is designed to give students an
opportunity to work with the ALTER TABLE statement
using the tables built in Labs 1 and 2. Lab work
will include:
- Moving
partitions and subpartitions
- Merging
partitions and subpartitions
- Modifying a
subpartition template
- Modifying the
list of a list partition
- Converting a
partition to a stand-alone heap table
- Partition
renaming
- Partition
splitting
|
| 2:30-3:15pm |
Discussion |
Indexing
Strategies
In this instructor led discussion consisting
of a combination of lecture and live-demo students
students will learn about indexing strategies for
partitioned and composite partitioned tables. |
| 3:15-4:30pm |
Lab
5 |
Partition
Indexing
In this lab students will work through
exercises demonstrating "best practices"
for indexing partitioned tables and gain
experience with both global and local indexes and
their implications for management and performance.
Students will use DBMS_INDEX_UTL to create
indexes. |
|
|
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.
|
|
