Short course name:

Database Management Systems 2

Module number:

COM 205

Course Syllabus:

Administration and Architecture of Oracle Database Engines:

Internal database structures and components of an Oracle database engine

Use of Redo logs and checkpoint processes

Control, trace and alert mechanisms in Oracle operation

Instance memory structures – SGA, PGA and UGA; database buffer, library, row/and sort cache areas

Role of SMON, PMON, ARCH, LGWR, CKPJ, Lock and server processes in ensuring optimum system behaviour

Features of the Oracle system data dictionary; auditing the system

Basic startup and shutdown processes; SYSDAB and SYSOPER roles

Creating databases, tablespaces, tables, indexes, views, synonyms, sequences and rollback segments using SQL*Plus and the Oracle Enterprise Manager (OEM) database studio

Bulk table imports using SQL*Loader and OEM

Carrying out hot and cold backups of the database

Physical and logical database backup procedures

Using RMAN for backups

Database failure scenarios

Recovery sequences for failed oracle databases; partial and full recovery steps

Tuning disk, memory and process areas for enhanced operation; load balancing and monitoring lock contention; pinning shared code in SGA; ‘EXPLAIN PLAN’ and ‘V$’ view debugging

Determining optimal numbers/sizes for rollback segments

Oracle partitioned and multiplexed tables; partitioning rules

Using BLOBs and CLOBs for multimedia database objects