hrs Specialised Training to meet your needs

Home Up The Team Public Courses Customised Consultancy

nfdba

                         

New features in Oracle 9i - DBA

Assumptions and pre-requisites

Delegates have some experience being a DBA in Oracle 8.

Course Outline

General considerations

  • Basic architecture not changed
  • Logging in as SYS and parameter change
  • Setting the default default temporary tablespace

Server Parameter Files

  • Creating SPF
  • STARTUP sequence
  • Migrating to SPF
  • Managing changes

Undo Tablespaces

  • Standalone rollback segments (RBU)
  • Undo Tablespaces (SMU)
  • Managing Undo Tablespaces
  • Setting the retention period for Undo Tablespaces
  • Using Flashback queries

Locally Managed Tablespaces

  • History and purpose
  • Setting extent sizes
  • Automatic Segment Space Management

Analysing objects

  • ANALYZE (now depreciated)
  • Using DBMS_STATS

Dealing with storage changes

  • The need to change the current storage pattern
  • Moving table data with SQL and/or EXPORT
  • Using table redefinition

Extensions to Table Partitioning

  • Review Table partitioning
  • Partition by HASH
  • Partition by LIST

New datatypes

  • TIMESTAMP
  • TIMEZONE
  • XMLType

Monitoring the database

  • Monitoring Indexes
  • Improved OEM tools
[RETURN TO LIST OF COURSES]

 

[Home] 

Send mail to pleasering@oracle-training.co.uk with questions or comments about this web site.
Copyright © 2003 hrs
Last modified: February 11, 2003