Description
This course teaches participants how to create, maintain, and administer an Oracle8 or 8i database. Administering users and storage, performing backups, and recovering a database are covered. Security and database optimization are also discussed.

Audience
System administrators who will be supporting Oracle databases, and application developers who will be developing database applications using Oracle.

Prerequisites
Some familiarity with SQL and PL/SQL is required.

Hardware and Software
Dedicated Oracle8 or 8i server properly installed on any platform, with sufficient logins for the number of students and instructor. DBA and Administrator log-ins and privileges are also required.

Format

• Presentation
  
• Hands-on
  

Objectives
After completing this course, participants should be able to:

• Describe the Oracle database architecture
• Describe the role of the database administrator (DBA)
• Create and administer an Oracle database
• Manage Oracle8 storage structures
• Describe Oracle8 objects
• Perform user administration in an Oracle database environment
• Backup and recover a database
• Describe Oracle8's security mechanisms
• Use SQL*DBA and Server manager
• Optimize an Oracle8 database

Basic Concepts

• Oracle architecture
• Logical structure and storage structures
• Database administrator tools

Creating the Database

• Initial planning
• Steps to create an Oracle database
• After database creation

Database Control

• Starting and shutting down the database
• Altering database availability

Managing Database Storage

• Setting storage parameters
• DDL, partitions, and optimization
• Managing tablespaces and datafiles
• Renaming and relocating tablespaces

Oracle8 Objects

• Object type definition
• Object tables, views, and comparison
• LOBs, BLOBs, and CLOBs

Managing Rollback Segments

• Assignments to rollback segments
• Types of rollback segments
• Acquiring of rollback segments
• Changing storage parameters

Redo Logs and Control Files

• Managing and archiving redo logs
• Creating and dropping control files

Database Security

• Oracle licensing and security guidelines
• Creating, altering, and dropping users and roles
• Profile management
• Granting object privileges

Backup and Recovery

• Performing full and partial backups
• Recovery mechanisms and datafile restoration

Export and Import

• EXP and IMP operation notes
• System backup management

Database Optimization

• Tuning memory, hit ratio, and tuning I/O
• Managing data storage