Oracle9i New Features
Training
© 2007-2010
by Burleson Consulting
* Learn about external
tables.
* See new Oracle9i SQL features.
* Understand multiple blocksizes.
* See important new init.ora parameters.
* Understand online table reorganization.
* Focus on the important new Oracle9i features.
|
|
This is an intensive
3-day Oracle9i new features overview. This course is
a comprehensive overview of Oracle9i taught by a highly experienced
Oracle professional.
Unlike mediocre
Oracle9i new features training, this course examines all Oracle9i
new features with an eye on those features that are the most
important to Oracle9i availability, Oracle9i performance and
Oracle9i development.
This hand-on Oracle9i
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.
 |
|
Oracle9i New Features
Robert Freeman
Oracle Press
ISBN: 0072223855
|
This 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 20 database books,
Burleson was chosen by Oracle Press to write five authorized
editions, including Oracle High-Performance SQL
tuning. 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.
Oracle9i New Features
Syllabus
© 2007-2010 by Donald K.
Burleson
DAY
1
1 -
Overview of Oracle9i new features
New
Administration Features
2
– Oracle9i managed files (OMF)
Oracle9i
db_create_file_dest parameter
Exercise – Create
Oracle9i OMF tablespaces and data
files
2
– Oracle9i online reorg
Exercise – Online reorg for pubs
database
3 – Oracle9i Multiple
blocksizes
Exercise –
Create tablespaces with multiple
blocksizes
4
– Oracle9i SGA memory management
Pga_aggregate_target
5
– Oracle9i Automated undo management
5 -
Oracle9i Resumable space management
5 -
Managing spfiles in Oracle9i
6 -
Oracle9i Virtual private databases
6 -
Oracle9i Fine-grained auditing
6 -
Oracle9i Database flash freeze
DAY
2
Oracle9i Architecture Changes
1 -
Oracle9i Flashback query
2 -
Oracle9i Logminer
3 -
Oracle9i Fast-start recovery
3 - New Oracle9i RMAN features
3 - Oracle9i Data Guard
4&5 - Object/relational enhancements in
Oracle9i
Inheritance, ADTs
Exercise – Create an
ADT
Oracle9i VLDB features
6 - Oracle9i Multi-table inserts
Exercise – Create multi-table
inserts
6 - Oracle9i Merge statements - Upserts
Exercise – Create an upsert
statement
6 - Oracle9i Parallel direct load changes
6 - Oracle9i list partitioning
|
|
DAY
3
Oracle9i SQL
1 - Oracle9i CASE statement
Exercise – Perform Oracle9i CASE statement in
SQL
1 – Oracle9i Explicit defaults
1
– Oracle9i Scalar subqueries
1 - New joins – cross join, natural join, using and
on
1 - Oracle9i Left and right outer joins
Exercise – Perform Oracle9i joins in
SQL
2 - Oracle9i Explicit column value defaults
2 - Oracle9i New date time BIFs
2 – Oracle9i External tables
Exercise – create an external
table
Oracle9i PL/SQL
3 - Oracle9i Compiled PL/SQL
3 -
Oracle9i Common SQL parser
3 -
Oracle9i cookie support
3 -
Oracle9i PL/SQL Inheritance support
3 -
Oracle9i New PL/SQL datatypes
New SQL optimization
4
– Oracle9i Index skip scan
Exercise – show index skip scan in
action
4 - Oracle9i Index-only scans on FBIs
Exercise
– show index-only FBI scan
4 - New Oracle9i first_rows_n
optimization
5 -
New Oracle9i execution plan columns
5 -
New Oracle9i statistics gathering
5 -
Oracle9i in-memory execution plans in
v$sql_plan
Exercise – Join v$sql_plan and
v$session
5 -
Improved Oracle9i cursor sharing with
peeking
RAC
and TAF
6 - Evolution of OPS into RAC
6 - Oracle9i Cache fusion architecture
6 - Using Oracle9i TAF with RAC
|
Please note that while the knowledge gained from this Oracle
training may be valuable when preparing for Oracle certification
exams, the content of this course is not for Oracle Certification,
including the Certified Professional (OCP) or Oracle Certified
Associate (OCA) programs.
This is a BC Oracle training
course (c) 2007-2010
|
