Untitled Document

Concentrika poppy

About the course

The course is intended for those who need to find out how to administer an ORACLE database, be this from the viewpoint of DBA, project manager, developer, or as support staff. Throughout the course, the training follows a pattern of firstly how and why ORACLE works as it does, followed by how to engineer changes hands on . Lastly, as the course moves on and the delegate acquires more skills, business based workshops are introduced. These require you to decide how the database should be built, deployed and managed, as well as drawing upon the hands-on skills needed to effect an actual outcome based on your decisions.

On leaving the course, you will be able to build a database, create users and their infrastructure, interconnect databases and load data. You will understand how to roll out a system on another machine. Backup and restore forms a vital part of the training.

Prerequisites

Delegates should be familiar with SQL and with working in ORACLE SQL*PLUS. You should have attended our “Introduction to Oracle” course or be familiar with the contents.

Duration

5 days

1. Introducing database administration

Responsibilities of a DBA
Elements of an RDBMS
Client server considerations

5. Internal organisation of datafiles

Logical organisation within datafiles
Rollback Segments
Estimating storage requirements
Problems with data storage
fragmentation
chained rows

9. Backup and Recovery

Strategy
Managing logging
Using alter database
RMAN recovery catalog

2. Creating a database

Instance management
Components of a database
Creating and deleting a database
Startup and shutdown using svrmgr
Loading the catalogue
System parameters
Alter system, alter database, alter session

6. Users and Security

User management strategies
Managing the user object
Limiting consumption of resources – user profiles
Managing security
permission and privilege
roles
trusted login to ORACLE
operating system privileges OSOPER, OSDBA
The audit subsystem

10. NET8

ORACLE networking strategy
Configuring NET8 – listener.ora and tnsnames.ora
ORACLE network applications
- COPY, linked database, snapshot, enterprise manager

3. The System Global Area and Background Processes

Memory structures
Background processes
Data dictionary

7. Bulk loading and unloading of data

SQL*LOADER
EXPORT/IMPORT

11. Performance monitoring

UTLBSTAT/UTLESTAT
Query optimisation
Explain Plan
Autotrace

4. Tablespaces

ORACLE Optimal Flexible Architecture (OFA)
Storage strategies
Managing the tablespace system object
Moving a tablespace
Monitoring tablespace growth

8. ORACLE 8 Advanced Features

Large objects
Tables and indexes
Abstract datatypes
Advanced queueing
Job scheduling