Oracle 10g XE Administration

Oracle 10g Architecture

Memory and Processes

Instances

Database Structure

SQL Query Processing

Oracle 10g XE Installation

Using DBCA

Trouble Shooting

Creating Database

OS Configuration

Authentication

Parameter File

Data dictionary management

Database Interfaces

Using SQL*Plus and isql*Plus

Accessing data and structure

Using query, manipulation and transaction commands

Creating, altering and dropping database information

Database Starting and Stopping

Starting processes - dbconsole, listener, isqlplus, database instance

Startup modes

Parameter file

Alert log

Shutdown operations

Table Spaces and Data Files

Purpose and use of tablespaces and datafiles

Create, manage, drop tablespaces

System tablespaces and user tablespaces

Retrieving status information for tablespaces and datafiles

Schema Objects

Creating and modifying tables

Selecting appropriate data types

Constraints

Viewing table contents

Creating and managing indexes and views

Creating and using sequences

Undo Management

Undo/rollback concepts

Configure and size undo features

Using the Undo Advisor

Undo tablespaces

Undo for transactions and rollback/recovery

Data Administration

Moving data using DML

Data Pump for export and import

SQL Loader for importing external data

Administering Oracle directories

PL/SQL for Administrators

PL/SQL Overview

Anonymous blocks

Procedures, functions, packages

Triggers

Supplied procedures

Managing Users

Creating and managing user accounts

Profiles, roles, privileges and user assignment

User resource management

Database Security

Security principles

Default user accounts

Password management features

Auditing database actions

Network Management

Managing Oracle listener

Net services

Connect time failover

Using Net Manager to configure resolution methods, database connectivity

Configuring and administering shared servers

Backup and Recovery Concepts

Overview of backup and recovery

Failure point identification

Configuring checkpoints, redo logs, archiving

Configure database for recovery

RMAN overview

Flash recovery area

Database Backups

Cold and hot datafile/tablespace backups

Automated backups

Incremental backups

Image copies

Multiplexed archive logs

Control file backups

Spfile/password file backups

Database Recoveries

Restore and recovery overview

Non-critical datafile recovery

Critical file recovery

Recovering damaged archive logs

Recovering control files

Lock Management

Detecting locking issues

Transactions and locking

Configuring optimum lock strategies

Resolving potential deadlocks

Performance Guidelines

Performance issues

SQL optimiser statistics

Gathering performance metrics

Enterprise Manager performance features

Diagnostics and Tuning

Setting automated alerts

Collecting baseline metrics

Using advisors

Automatic Database Diagnostic Monitor

Automated Workload Repository

Responding to server alerts