Oracle8 Database Administration - Manage an Instance

Audience

Database Administrators system administrators network administrators and technical support professionals. Prior to taking this course participants should be familiar with SQL and PL/SQL using Procedure Builder or have taken courses 61110 61111 61112 and 60113.

Objective

• Identify Oracle architectural components.
• Use the Server Manager line mode and the Oracle
• Enterprise Manager (OEM) interface.
• Manage an Oracle instance.
• Learn about the features of National Language Support (NLS).

Topics Include

Unit 1: Oracle Architecture Components

• Identify the tasks of a database administrator.
• Match the terms associated with establishing a database connection with their descriptions.
• Identify the characteristics of a user process.
• Identify the characteristics of a server process.
• Match the memory structures of the System Global Area (SGA) with the information stored by them.
• Match the mandatory background processes with their functions.
• Match the different types of files existing in a database with the information stored in them.
• Match the non-database files with the information stored in them.
• Sequence the stages in processing a query.
• Identify the combinations of the shared pool components and the information stored in them.
• Identify the characteristics of the database buffer cache.
• Match the contents of the Program Global Area (PGA) with their uses.
• Identify the steps in the execute phase of a given DML statement.
• Identify the uses of a rollback segment.
• Identify the characteristics of a redo log buffer.
• Identify the events that cause the Database Writer (DBWR) to write to datafiles.
• Identify the events that cause the Log Writer (LGWR) to write to the redo log file.
• Identify the uses of System Change Numbers.
• Sequence the steps that occur during COMMIT processing.
• Identify the advantages of the fast COMMIT process used by Oracle.

Unit 2: Administration Tools

• Match the tools used by the DBA with the administrative tasks that they enable the DBA to perform.
• Execute a script from the Server Manager line mode.
• Specify the associated command for a given description.
• Identify the features of the Oracle Enterprise Manager (OEM) architectural components.
• Match the OEM console components with the tasks that they enable.
• Identify the OEM console service used to perform a given task.
• Match the OEM standard applications with the tasks that they enable you to perform.
• Match the components of the Performance Pack with their functions.
• Identify the steps performed to set up OEM for use.
• Match the application interface objects with their uses.
• Match the SQL Worksheet components with their uses.

Unit 3: Managing an Oracle Instance

• Identify the characteristics of the default database administrator user accounts.
• Set up the OS authentication on the NT platform.
• Set up a Password File Authentication on a NT platform by using the ORAPWD80 utility.
• Change the internal password by using the ORADIM80 utility.
• Identify the uses of the parameters included in the parameter file.
• Identify the rules that govern the parameters specified in the parameter file.
• Identify the essential parameters for a parameter file.
• Identify the commonly modified parameters of a parameter file.
• Identify the tasks performed in each stage of an instance startup.
• Start up an instance by using the Oracle Instance Manager.
• Change a database state by using the Oracle Instance Manager.
• Identify the tasks performed in each stage of instance shutdown.
• Identify the features of dynamic performance views.
• Specify the associated dynamic performance view parameter for a given description.
• Display the current parameter values by using the V$PARAMETER dynamic performance view.
• Modify a dynamic initialization parameter by using the Oracle Instance Manager.
• Set up a restricted session to a database by using the Oracle Instance Manager.
• Terminate a user session by using the Oracle Instance Manager.
• Identify the differences between an alert file and a trace file.
• Specify the parameters that are used to control trace files.
• Identify the information stored in a given alert file.

Unit 4: National Language Support (NLS)

• Identify the features of NLS.
• Match the Oracle character encoding scheme classes with their descriptions.
• Identify the reasons for choosing a national character set that is specified in a CREATE DATABASE command.
• Identify combinations of the NLS parameters used for specifying the default conventions and the session characteristics.
• Specify the derived NLS parameters given the descriptions.
• Override the default NLS behavior for an individual user by using the NLS_LANG environment variable.
• Change the NLS settings for a session by using the ALTER SESSION command.
• Specify the linguistic sort type by using the NLS_SORT parameter.
• Identify the combinations of SQL functions and their corresponding NLS Parameters.
• Retrieve the character sets for the database by using a view.
• Retrieve information about NLS settings by using views.

Duration

8

Minimum Requirements

The CDROM version of this course requires:

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
• At least a double speed CDROM drive.
• An MPC compliant sound card with attached speakers or headphones is recommended (Currently only the CDROM version supports audio).

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM and 22MB available hard disk space or file server space.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).

Media

CDROM