Oracle Database Administration

 

:Objective

At the end of the course delegates will be able to create and manage database users, implement a security system to control their activities, define a backup strategy and perform recovery in the event of a system failure and tune the database to optimize performance.

 Knowledge of the target operating system is helpful. Delegates should also be competent in the skills covered by the PTR Oracle SQL*Plus Fundamentals course.

 

:Course outline

Introduction  ..   Oracle System Architecture

Overview of components, processes and functions of Oracle 8

Data files, redo logs, control files, parameter file

System Global Area and shared memory structures

Description of Administrator facilities and duties

Creating a database

Setting initialization parameters         - Important SQL scripts

Starting up, mounting and opening the database

Shutdown modes                                - Using the data dictionary

Managing and optimizing disk space

The System table space                       - Creating additional table spaces

Important storage parameters             - Monitoring extents and free space

Extending table spaces                       - 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

Tuning memory structures

Monitoring shared memory                - Sizing the buffer cache

shared pool and redo log buffer         - Tuning sort operations

User administration

Creating users             - Using Oracle 8’s new password controls

Default and temporary table spaces

Space quotas               - Profiles

System and object privileges

Creating and managing roles

System and object auditing

Backup & recovery  ..  Archiving redo logs

Hot and cold database backups          - Instance recovery

Database, table space and data file recovery (practical exercise)

The Oracle 8 Recovery Manager       

Oracle Utilities  ..   Export and import  - SQL Loader

دورة تدريبية

اطلب الحقيبة