Database Administration

 

Databases in General Procedures Objects Space & Sizing Backup & Recovery Performance & Tuning Built in packages Network OCP Notes Tools

Databases in General

Basic Database Creation	New Features 7 through to 9i
Database Start	Install of 9i on Linux (Red Hat)
Security	Database Independence e.g. Differences between Oracle & SQL Server
Snapshots	Oracle on NT - hints & tips
Redo Logs	Terminology & Architecture
Security
Rollback and Undo
Administrator authentication and password files
Character sets and UNICODE
Resource Manager
Oracle 9i SPFILE
Oracle Managed Files
Auditing
Date and Time data types and functions
Version - Enterprise or Standard
RAC

Procedures

Adding, renaming, relocating and resizing datafiles

Moving and renaming databases

Using Global context for auditing

Objects

Partitioning - tables

Temporary Tables

Space & Sizing

Locally managed tablespaces (8i)

Freelists

Highwater marks

Backup & Recovery

Recovery

Backup

Export

Import

Recover an index datafile

Logminer

Archive log mode

Tuning & Performance

Tuning Memory

SQL Tuning, EXPLAIN and TKPROF

Built in packages

DBMS_SQL - Dynamic SQL

UTL_FILE - PL\SQL output to flat file

STATSPACK - This provides tuning reports in 9i (similar to BSTAT/ESTAT)

DBMS_SPACE_ADMIN Trouble shooting locally managed tablespaces

Network

Example listener.ora

OCP Notes

SQL

DBA Fundamentals 1

Tools

Oracle Enterprise Manager

SQL*PLUS