|
Provided by: 123-CBT Computer Based Training Oracle8 Database Administration - Manage an Instance |
 |
Training
Provided by 123-CBT Computer Based Training
Course Overview
This course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle8. In this course, participants will learn about the concepts and procedures associated with Oracle architectural components, using the database administration tools, managing an Oracle instance, and using National Language Support.
Learn To:
- 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).
Content Emphasis
Skills-Based
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 60111, 60112 and 60113.
Total Learning Time
6 - 8 Hour(s)
Course Contents
Unit 1: Oracle Architecture Components
Duration: 1 - 2 Hour(s)- 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
Duration: 1 - 2 Hour(s)- 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
Duration: 2 Hour(s)- 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)
Duration: 2 Hour(s)- 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.
|
|
||||||||||
Oracle8 Database Administration - Manage an Instance
--
About The Training Provider: 123-CBT Computer Based Training
123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning
programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace:
E-Learning available for
- ABAP 6.10
- Access 2003
- Acrobat 6.0
- ASP
- ASP.NET
- C
- Captivate 1.0
- Crystal Reports 8.5
- Crystal Reports v10
- Dreamweaver MX
-...
