Manageability Enhancements in Oracle9i

Overview/Description
To describe the manageability enhancements of an Oracle9i database

Target Audience
Oracle database administrators; developers interested in the technical aspects of Oracle9i database

Prerequisites
Experience in Oracle database administration; the learning paths Oracle Introduction and Oracle8i Database Administration, while not essential, would be useful

Expected Duration
310 Minutes

Objectives:

Manageability Enhancements in Oracle9i

  • define an Oracle9i SPFILE and its characteristics.
  • describe how to view, export, and migrate an Oracle9i database SPFILE and describe its startup behavior.
  • view and change parameter values in an Oracle9i SPFILE.
  • explain the sharing of initialization parameter files in an Oracle9i database.
  • describe and enable automatic memory management in an Oracle9i database.
  • describe and enable dynamic memory management in an Oracle9i database.
  • dynamically increase the size of a component SGA memory area in an Oracle9i database.
  • describe the allocation and tracking of memory behind a dynamic SGA in an Oracle9i database.
  • explain the concepts and benefits of Oracle9i managed files.
  • manage control files and redo log files and tablespaces with OMF in an Oracle9i database.
  • explain, create, and alter a default temporary tablespace in an Oracle9i database.
  • define, create, alter, drop, and switch an undo tablespace in an Oracle9i database.
  • define and use multiple block sizes in an Oracle9i database.
  • explain the concept and implementation of automatic segment free space management in an Oracle9i database.
  • describe resumable space allocation in an Oracle9i database.
  • describe the life cycle of resumable space allocation and how to enable, disable, and alter resumable space allocation in an Oracle9i database.
  • enable, disable, and alter resumable space allocation in an Oracle9i database.
  • detect suspended statements and monitor resumable space allocation in an Oracle9i database.
  • launch and navigate around the Oracle9i Enterprise Manager console.
  • launch the Oracle9i Enterprise Manager in Standalone mode and explain the benefits and restrictions of Standalone mode in an Oracle9i database.
  • describe and use the functionality and features that Enterprise Manager provides for an Oracle9i database.
  • describe and use the additional functionality and features that Enterprise Manager provides for an Oracle9i database.
  • use the different methods of reporting and create user-defined events in an Oracle9i database.
  • launch the Oracle9i Enterprise Manager console, add databases to a Navigator tree, and create an HTML report.


    • Course Number: 39816_eng