Upgrading to Oracle11g
Training
© 2007-2012
by Burleson Consulting
* Learn the most important
11g new features and when to use them.
* Understand how to leverage the automatic DBA features.
* See how the Automated Workload Repository (AWR) places important
tuning information at your fingertips.
* Use the Automated Session History (ASH) tables to quickly find
performance bottlenecks.
* Understand how to use the Automatic Database Diagnostic Monitor
(ADDM).
* Learn how to implement the SQLTuning and SQLAccess advisor
tools.
|
|
Unlike some mediocre
Oracle 11g upgrade training, this course examines all Oracle11g
new features with an eye on those features that are the most
important to Upgrading to Oracle11g.
This Oracle 11g upgrade training is special because
this course is taught by a veteran Oracle Certified DBA with years of full-time experience.
 |
|
Oracle Database 11g
New Features
Get started fast with
Oracle11g enhancements
John Garmany, Steve Karam, Lutz
Hartmann, V. J. Jain, Brian Carr
ISBN 978-0-9797951-0-7
|
This upgrading to 11g training course is designed for practicing
Oracle professionals who have basic experience with Oracle. Prior
experience with Oracle is not required, but experience using Oracle
database is highly desirable.
|
This upgrading to Oracle 11g training class was designed by Donald K. Burleson, an acknowledged
leader in Oracle database administration. Author of more than
30 database books, Burleson was chosen by Oracle Press to write
five authorized editions, including Oracle High-Performance SQL
tuning. Burleson also served as the Editor for the
premier book Oracle 11g
New Features for the DBA by Rampant TechPress. Burleson Consulting instructors offer
decades of real world DBA experience in Oracle features, and they
will share their Oracle secrets in this intense Oracle new
features training.
Course Duration
This is an
intensive 2-day Oracle 11g Upgrade overview. This
course is a comprehensive overview of Oracle11g, taught by a
leading Oracle11g trainers.
Upgrading to 11g Training Course
2-Day Syllabus
11g upgrade training - Copyright © 2010 by
Donald K. Burleson
DAY
1
New Features for
Database Creation and Deletion
-
SYSAUX
Tablespace
-
Automated Storage Management
Configuration
-
Automated RAC Services
Configuration
-
Simplified Upgrade for RAC and
OPS Databases
-
Drop Database
Database Tuning and
Performance Improvements
Database Resource Manager
Improvements
-
Database
Resource Manager Overview
-
Adaptive
Consumer Group Mapping
-
Fixed CPU
Quota
-
Integration of Resource Manager and
Profiles
Tuning
Improvements
-
Buffer
Cache Flushing - User Initiated
-
Automated
Checkpoint Tuning
-
CPU
Costing
-
Dynamic
Sampling
Tuning Transaction
Recovery
-
Easy
Transaction Recovery Monitoring
Oracle Enterprise Manager
Changes
-
Overview
of the changes
-
SQL
Reporting
-
New
Performance Overview Charts
Single-Set Aggregates in DML Returning
Clause
New and Updated Optimizer
Hints
Wait Model
Improvements
-
Overview
of enhancements
-
Changes
and updates
Application
Tuning
-
SQL Access
Advisor
-
Materialized View Tuning API - The new TUNE_MVIEW
API
New Static Data Dictionary
Views
-
Overview
-
List of
Views and Explanation
New Dynamic Performance
Views
Static data dictionary views have new
columns
Dynamic performance views have new
columns
Oracle11g New Features for
Tablespace Management
Temporary Tablespace
·
Temporary Tablespace Group
Overview
·
Temporary Tablespace Group
Benefits
·
Examples
Rename Tablespace
·
Tablespace Rename
Overview
·
Tablespace Rename
Benefits
·
Examples
Bigfile Tablespace
·
Bigfile Tablespace
Overview
·
Bigfile Tablespace
Benefits
·
Extended ROWID
Format
·
Examples
Automated Storage Management (ASM)
·
Automated Storage Management
Overview
·
Automated Storage Management
Benefits
·
ASM Disk
Group
·
ASM Disk
·
ASM Files
·
ASM
Instance
New Oracle11g Table and Index
Features
Creating a Sorted Hash
Cluster
Partitioning
Improvement
-
Overview
of Improvements in Partitioning
-
Global
Partitioned Indexes - Hash Partitioning
-
Enhancements for Partitioned Index-Organized
Tables
- List Partitioning
- LOB Support
- Global Index Maintenance
-
Local
Partitioned Indexes Manageability
Improvements
-
Enhanced
Partition Management in Enterprise Manager
Enhanced Bitmap Index Performance and
Space Management
|
|
DAY 2
New Oracle11g DML Features: Insert, Update and
Delete
Single-Set Aggregates in DML Returning
Clause
Upsert through SQL Interrow
Calculations
New Oracle11g SELECT
features
SQLAccess
Advisor
Materialized View Tuning
API
Grouped Table Outer
Join
Increased Number of Aggregates per
Query
SQL Interrow
Calculations
Remote Stored Functions in SELECT
Statements
Native Net Over Fast
Interconnects
Native Net Over
TCP/IP
Case-Insensitive and Accent-Insensitive
Query and Sort
Enhanced
Collections
Enhanced CONNECT BY
Support
Oracle Expression
Filter
SQL Regular
Row Timestamp
Improved Features:
MERGE, EXTERNAL TABLES, MINSERT
Asynchronous Change
Data
Cross-Platform Transportable
Tablespaces
Enhanced Table
Functions
External Tables
Unload
Enhanced MERGE
Functionality
New Oracle11g
Initialization Parameters
Type of Initialization Parameters
Twenty New Parameters
CREATE_STORED_OUTLINES
DB_ALLOWED_LOGIN_VERSION
DB_FLASHBACK_RETENTION_TARGET
DB_RECOVERY_FILE_DEST
DB_RECOVERY_FILE_DEST_SIZE
DDL_WAIT_FOR_LICKS
INSTANCE_TYPE
LDAP_DIRECTORY_ACCESS
LOG_ARCHIVE_CONFIG
OSM_DISK_REPARIR_TIME
OSM_DISKGROUPS
OSM_DISKSTRING
OSM_POWER_LIMIT
PLSQL_OPTIMIZE_LEVEL
PLSQL_WARNINGS
RESUMABLE_TIMEOUT
SKIP_UNUSABLE_INDESES
SMTP_OUT_SERVER
SP_NAME
STREAMS_POOL_SIZE
New Oracle11g Management
Features
Database Startup and
Shutdown
Overview
of enhancements
Database
Automated Startup and Shutdown
Configuration
Database Install
Simplified
Database Install
Improvements in
Auditing
Uniform
Audit Trail
Extended
SQL Support in FGA
Easier Database
Registration
Unified User
Model
New Oracle11g Network
Features
Database Authentication with
Standard LDAP Password Verifiers
Single Station Administration for
Password Authentication to Oracle Database
SSL Session
Renegotiation
Performance
Improvements
4096-Bit Key Size
Support
Oracle11g Backup and Recovery New
Features
Extended Flashback Functions
Flashback
Database
Flashback Standby
Database
Flashback
Re-instantiation
Flashback
Drop
Flashback
Table
Flashback Row
History
Flashback Transaction
History
RMAN Enhancements
Automated Channel Failover for
Backup and Restore
Automated File Creation During
Recovery
Simplified Backups to
Disk
Simplified Recovery Manager
Cataloging of Backup Files
|
This is a BC Oracle training
course (c) 2010
|
| |
|
