Oracle9i New Features: Database Administration


Overview/Description
Target Audience
Expected Duration
Lesson Objectives
Course Number

Overview/Description
This course introduces learners to the Oracle9i enhancements in server-side manageability, Oracle Enterprise Manager, and globalization..

Target Audience
The audience for this course are Database Administrators. Required prerequisites include SQL, PL/SQL, DBA I, DBA II..

Expected Duration (hours)
8.0

Lesson Objectives

Oracle9i New Features: Database Administration

  • The learner will be able to identify the benefits of the automated SQL execution feature.
  • The learner will be able to identify the characteristics of the PGA memory management feature.
  • The learner will be able to identify the new data dictionary enhancements that support the new memory management features.
  • The learner will be able to identify the benefits of the dynamic SGA feature.
  • The learner will be able to identify the characteristics of the dynamic SGA components.
  • The learner will be able to match the database parameters with their buffer cache sizing attributes.
  • The learner will be able to identify the features of Oracle Managed Files.
  • The learner will be able to identify the operational considerations of implementing Oracle Managed Files.
  • The learner will be able to Identify the benefits of the data deletion feature.
  • The learner will be able to Identify the characteristics of the default temporary tablespace.
  • The learner will be able to identify the characteristics of bitmapped blocks used by the automatic segment free space usage feature.
  • The learner will be able to identify the operational considerations of implementing automatic segment free space management.
  • The learner will be able to Identify the implementations of the high water mark in the Oracle9i server.
  • The learner will be able to Identify the modified procedures and parameters of the DBMS_SPACE package.
  • The learner will be able to identify the two methods of fixing bitmap entries by using the SEGMENT_FIX_STATUS procedure of the DBMS_REPAIR package.
  • The learner will be able to identify the characteristics of global indexes in the Oracle9i server.
  • The learner will be able to identify the characteristics of the Oracle9i feature that monitors index usage.
  • The learner will be able to identify the operational considerations of implementing the automatic undo management feature.
  • The learner will be able to identify the operational considerations of implementing the resumable space allocation feature.
  • The learner will be able to identify the features of multiple block size support in the Oracle9i server.
  • The learner will be able to identify the enhancements that have been made to support cached execution plans.
  • The learner will be able to identify the operational considerations of implementing a persistent parameter file.
  • The learner will be able to identify the features of the active session pool.
  • The learner will be able to identify the characteristics of the maximum estimated execution time feature.
  • The learner will be able to match the resource plan directives that administer the automatic consumer group switching feature with its description.
  • The learner will be able to identify the operational considerations of the undo quota in the Oracle9i server.
  • The learner will be able to match the data dictionary objects with their new columns to support resource manager enhancements.
  • The learner will be able to identify the operational considerations associated with implementing a names server as an LDAP proxy.
  • The learner will be able to Sequence the steps in configuring the Oracle names server as an LDAP proxy server.
  • The learner will be able to Match the CKPTOP.ora components with their descriptions.
  • The learner will be able to Match the OEM component their minimum machine requirements.
  • The learner will be able to identify the features of the database detect functionality of Configuration Assistant.
  • The learner will be able to identify the two supported migration steps for the Oracle Enterprise Manager repository.
  • The learner will be able to identify the features of the Oracle9i intelligent agent.
  • The learner will be able to identify the resource manager enhancements in Oracle Enterprise Manager for the Oracle9i server.
  • The learner will be able to Identify the report generation enhancements in Oracle Enterprise Manager.
  • The learner will be able to identify the reverse engineering DDL features of Oracle Enterprise Manager.
  • The learner will be able to identify the new Oracle9i features supported by the OEM console.
  • The learner will be able to identify the facilities provided by the OEM console to support advanced queueing and replication.
  • The learner will be able to match the Oracle Enterprise Manager component with its functionality in supporting materialized views.
  • The learner will be able to identify OEM enhancements that support OLAP management.
  • The learner will be able to identify the available services of the OEM console running in standalone mode.
  • The learner will be able to identify the controlled areas of the customizable console.
  • The learner will be able to identify the guidelines for implementing management regions.
  • The learner will be able to identify reporting framework features employed by Oracle Enterprise Manager.
  • The learner will be able to identify the benefits of the event creation enhancements in Oracle Enterprise Manager.
  • The learner will be able to identify the guidelines in dynamically modifying events.
  • The learner will be able to identify the benefits of user defined events.
  • The learner will be able to identify the benefits of the event handler.
  • The learner will be able to identify the features of the blackout facility in Oracle Enterprise Manager.
  • The learner will be able to identify the job system enhancements in Oracle Enterprise Manager.
  • The learner will be able to identify the differences between byte and character semantics.
  • The learner will be able to identify the data dictionary views that have been modified to support the new NLS features.
  • The learner will be able to Match the new NLS character sets with their descriptions.
  • The learner will be able to identify the new language and territory definitions.
  • The learner will be able to identify the advantages of Unicode.
  • The learner will be able to match the encoding schemes with their descriptions.
  • The learner will be able to identify the two methods that implement a Unicode solution.
  • The learner will be able to match the character sets with their descriptions.
  • The learner will be able to identify the type conversion considerations for the NCHAR data type.
  • The learner will be able to identify the possible issues related to character set migration.
  • The learner will be able to identify the tests performed by the character set scanner utility.
  • The learner will be able to Sequence the steps for performing a character set data conversion.
  • The learner will be able to identify the features of multilingual linguistic sorts.
  • The learner will be able to match the linguistic sorts with their support descriptions.
  • The learner will be able to identify the features of the Oracle Locale Builder.
  • The learner will be able to identify the guidelines associated with creating new globalization support locale data files.
  • The learner will be able to identify the datetime and interval data types in the Oracle9i server.
  • The learner will be able to match the settings used to support time zones and DST with their descriptions.
  • The learner will be able to identify the guidelines for using the NLS_TIMESTAMP_FORMAT and NLS_TIMESTAMP_TZ_FORMAT parameters.
  • The learner will be able to match the built-in SQL functions that support datetime, interval, and DST features with their descriptions.

    • Course Number:
    en_US_64301_ng