Database 10g: DBA

Course Outline

Overview of Oracle 10gAdministration

Your responsibilities as an Oracle DBA

• Configuring Oracle 10 g databases
• Controlling user access and operations
• Monitoring system usage
• Ensuring database availability

The Oracle 10garchitecture

• Instances vs. databases
• Oracle processes and memory usage
• Determining database file structure
• Processing transactions with Oracle 10 g

Constructing an Oracle 10gDatabase

Creating and dropping the database

• Setting the initialisation parameters
• Dynamic and static parameters
• Creating control files and log files
• Reducing administration with Oracle managed files

Defining tablespace structure

• Supporting applications that require multiple block sizes
• Creating UNDO and SYSAUX tablespaces

Starting and stopping the database

• Mounting and opening the database
• Text-based and server parameter files
• Connecting with SYSDBA privilege

Performing Space Management

Logical and physical storage structures

• Improving sort performance with temporary tablespace groups
• Bigfile and locally managed tablespaces

Controlling storage for database objects

• Managing space with PCTFREE/PCTUSED
• Moving and redefining tables online
• Shrinking tables online to regain space
• Resuming operations after failures
• Managing LOB storage with chunks

Automating Database Management with Oracle Enterprise Manager (OEM) 10gDatabase Control

The OEM architecture

• Strengths and weaknesses of OEM
• Navigating the graphical interface

Administering with Database Control

• Setting thresholds and generating alerts
• Verifying changes in the data dictionary

Managing Users and Resources

Creating user accounts

• Implementing password controls
• Allocating space quotas on tablespaces
• Limiting resource usage with profiles

Maintaining security

• System and object privileges
• Setting up and working with roles
• Transparently encrypting data

Enhancing Availability and Administration with Partitions

Building table partitions and subpartitions

• Partitioning types: range, hash and list
• Tailoring storage for individual partitions
• Splitting and merging partitions

Configuring index partitions

• Deploying local, global, prefixed and non-prefixed indexes
• Rebuilding unusable indexes

Backing Up and Recovering the Database

Safeguarding the database

• Role of the redo log and control file
• Ensuring recovery using archiving
• Protecting and tracing the control file

Selecting a backup strategy

• Implementing hot and cold backups
• Partial online and offline backups
• Restoring tables with Data Pump

Performing recovery of the database

• Recovering corrupted tablespaces
• Tracking row history with flashback
• Restoring dropped tables from the recycle bin

Fundamental Tuning Concepts

• Sizing the buffer cache and shared pool
• Balancing disk I/O and memory allocation
• Index storage considerations