Back to Search Results

Training Course Summary:

This DBA course is intended for those who are responsible for managing, maintaining and supporting Oracle version 8.

Pre-Requisites:

We suggest completion of our SQL*Plus Fundamentals (OSQLF) course (or equivalent experience).

Training Course Overview/Content:

Introduction: Oracle System Architecture. Overview of components, processes and functions of Oracle 8. Datafiles, redo logs, control files, parameter file. System Global Area and shared memory structures. Description of Administrator facilities and duties.· Creating a database: Setting initialisation parameters. Important SQL scripts. Starting up, mounting and opening the database. Shutdown modes. Using the data dictionary.· Managing and optimising disk space: The System tablespace. Creating additional tablespaces. Important storage parameters. Monitoring extents and free space. Extending tablespaces. Configuring rollback segments. Configuring redo logs. · Tables and indexes: Performance issues. Storage parameters and PCTFREE and PCTUSED. Oracle 8's new partitioning facilities. Partitioning tables. Partitioning indexes. Managing partitions. Oracle 8 and objects.· Performance Tuning: Monitoring shared memory. Sizing the buffer cache, shared pool and redo log buffer. Tuning sort operations. Building & running healthcheck reports.· User administration: Creating users. Using Oracle 8's new password controls. Default and temporary tablespaces. Space quotas. Profiles. System and object privileges. Creating and managing roles. System and object auditing.· Backup and recovery: Archiving redo logs. Hot and cold database backups. Instance recovery. Database, tablespace and datafile recovery (practical exercise). The Oracle 8 Recovery Manager.· Oracle Utilities: Export and import. SQL Loader. Direct Load.· Net 8 Configuration: Managing tnsnames and listener files. Managing service names. Building database links.