Oracle10g New Features
Training
© 2016 by
Burleson Corporation
* Learn the most important
10g 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 mediocre
Oracle10g new features training offered by others, this course
examines all Oracle10g new features with an eye on those features
that are the most important to Oracle10g availability, Oracle10g
performance and Oracle10g development.
This Oracle10g new features training is special because
this course is taught by a veteran Oracle Certified DBA with more
than 20 years of full-time experience.
 |
|
Oracle Database 10g
New Features
Oracle10g Reference for
Advanced Tuning & Administration
Mike Ault, Daniel Liu, Madhu
Tumma
ISBN 0-9740716-0-9
|
This 10g new features 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 course 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 Oracle10g
New Features for the DBA by Rampant TechPress. Burleson Corporation instructors offer
decades of real world DBA experience in Oracle features, and they
will share their Oracle secrets in this intense Oracle 10g
new features training.
Course Duration
This is an
intensive 3-day or 4-day Oracle10g new features
overview. This course is a comprehensive overview of
Oracle10g, taught by a leading Oracle10g trainers. The 4-day
version of this course explores more robust Oracle 10g SQL new
features in Virtual Spreadsheets and regular expression
syntax.
Oracle10g New Features
3-Day Syllabus
Copyright © 2016 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
DAY 2
Oracle10g 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 Oracle10g 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
New Oracle10g DML
Features: Insert, Update and Delete
Single-Set Aggregates in DML Returning
Clause
Upsert through SQL Interrow
Calculations
New Oracle10g 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 Oracle10g
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 Oracle10g 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
Oracle10g Utilities
Improvements
Data Pump Utilities
·
Data Pump
Overview
·
Data Pump
Benefits
·
Data Pump
Export
·
Data Pump Export
Examples
·
Data Pump
Import
·
Data Pump Import
Examples
SQL*Loader Improvements
·
Direct Path Support for ROWID
Datatype
·
Direct Path Support for VARRAY
Datatype
·
Direct Path Support for XML Type
Tables
SQL*Plus Enhancements
·
Session
Configuration
·
SQL Prompt Runtime Variable
Substitution
·
DESCRIBE Command
Improvements
·
SPOOL Command
Improvements
·
Show Recycle
Bin
·
SQL*Plus
Compatibility
iSQL*Plus
Enhancements
·
Input
Prompting
·
Command
Changes
New Scheduler Utilities
·
Introduction to
Scheduler
·
Scheduler
Architecture
·
Program and Job
Concepts
·
Managing Jobs and
Programs
·
Data Dictionary View for
Scheduler
·
Examples
New Oracle10g 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
|
|
DAY
3
Oracle10g 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
Oracle10g High
Availability Improvements
Log Miner
-
Overview
of the improvements
-
Automated
LogMiner Configuration
-
Support
for Index-Organized Tables
-
Support
for Additional Types
-
LONG,
Multibyte CLOB and NCLOB
Real Application
Clusters
-
Overview
of the Improvements
-
Data guard
broker support
-
CRS
(Cluster Ready Services)
-
workload
management improvements
-
manage, and monitor application workloads as a
service
-
Improved
Streams RAC Support
-
supports hot mining,
-
automatically restart processes after
failover
-
supplemental logging
Data Guard
-
Simplified
Zero Data Loss for Data Guard SQL Apply
-
Real Time
Apply
-
Named Data
Guard Configurations
-
Secured
Redo Transmission
-
Zero
Downtime Instantiation for SQL Apply
Supplemental
Logging
Enhanced Online
Redefinition
Improved Handling of DDL Locks on Busy
Tables
Signature-Based Dependency Tracking
Using Synonyms
Oracle10g
Streams
Overview of
Streams
Downstream
Capture
-
Downstream
Capture Overview
-
Creating a
Downstream Capture Process
Performance Enhancements for greater
work loads
-
Enhanced
Capture and Apply Performance
-
Performance Enhancements for AnyData Queues, Rules, and
Propagation
Updates to the
Rules
-
Easy Rules
Engine Transformation Management
-
Negative
Rules
-
Tuning
Rules
Better interoperation with Oracle
RAC
-
capture
changes from redo log as well as the archived redo
log
-
automatic
transfer of the queue
New streams related dynamic performance
views
New streams related initialization
parameters
Chapter 15: Security Enhancements
VPD Support for Parallel
Query
VPD Static and Dynamic
Policies
Column-level
VPD
Business
Intelligence
Data Warehousing
Enhancements
-
Interrow
Calculations
-
SQLAccess
Advisor tool
-
DBMS_ADVISOR package
-
for
Indexing
-
for
materialized view
-
Partitioning Enhancements
-
partitioning for index-organized
tables.
-
partitioning materialized views in OLAP
-
Hash-partitioned global indexes.
SQL Support for Analytic
Applications
-
Grouped
Table Outer Join
-
Size of
aggregations in a single SQL statement.
-
SQL
Inter-row Calculations
Summary
Management
-
Enhanced
Partition-aware Materialized View Refresh
-
EXPLAIN
PLAN Shows Materialized View Access The
-
Enhanced
Dimensions
-
Nested
Materialized View Refresh Materialized
-
Enhanced
PCT Refresh Partition
-
Query
Rewrite Uses Multiple Materialized Views
|
This is a BC Oracle training
course (c) 2016
|
| |
|
