Oracle Database 10g: Administration

Course Details

•Install Oracle Database 10g and configure a database.

•Manage the Oracle instance.

•Manage the Database storage structures.

•Create and administer user accounts.

•Perform backup and recovery of a database.

•Monitor, troubleshoot, and maintain a database.

•Configure Oracle Net services.

•Move data between databases and files.

Introduction (Database Architecture)

Describe course objectives

Explore the Oracle 10g database architecture

Installing the Oracle Database Software

Explain core DBA tasks and tools

Plan an Oracle installation

Use optimal flexible architecture

Install software with the Oracle Universal Installer (OUI)

Creating an Oracle Database

Create a database with the Database Configuration

Assistant (DBCA)

Create a database design template with the DBCA

Generate database creation scripts with the DBCA

Managing the Oracle Instance

Start and stop the Oracle database and components

Use Enterprise Manager (EM)

Access a database with SQL*Plus and iSQL*Plus

Modify database initialization parameters

Understand the stages of database startup

View the Alert log

Use the Data Dictionary

Managing Database Storage Structures

Describe table data storage (in blocks)

Define the purpose of tablespaces and data files

Understand and utilize Oracle Managed Files (OMF)

Create and manage tablespaces

Obtain tablespace information

Describe the main concepts and functionality of Automatic

Storage Management (ASM)

Administering User Security

Create and manage database user accounts

Authenticate users

Assign default storage areas (tablespaces)

Grant and revoke privileges

Create and manage roles

Create and manage profiles

Implement standard password security features

Control resource usage by users

Managing Schema Objects

Define schema objects and data types

Create and modify tables

Define constraints

View the columns and contents of a table

Create indexes, views and sequences

Explain the use of temporary tables

Use the Data Dictionary

Managing Data and Concurrency

Manage data through SQL

Identify and administer PL/SQL Objects

Describe triggers and triggering events

Monitor and resolve locking conflicts

Managing Undo Data

Explain DML and undo data generation

Monitor and administer undo

Describe the difference between undo and redo data

Configure undo retention

Guarantee undo retention

Use the undo advisor

Implementing Oracle Database Security

Describe DBA responsibilities for security

Apply the principal of least privilege

Enable standard database auditing

Specify audit options

Review audit information

Maintain the audit trail

Configuring the Oracle Network

Environment

Use Enterprise Manager for configuring the Oracle network

environment

Create additional listeners

Create Net Service aliases

Configure connect-time failover

Control the Oracle Net Listener

Test Oracle Net connectivity

Identify when to use shared versus dedicated servers

Proactive Maintenance

Use statistics

Manage the Automatic Workload Repository (AWR)

Use the Automatic Database Diagnostic Monitor (ADDM)

Describe advisory framework

Set alert thresholds

Use server-generated alerts

Use automated tasks

Performance Management

Use Enterprise Manager pages to monitor performance

Use the SQL Tuning Advisor

Use the SQL Access Advisor

Use Automatic Shared Memory Management

Use the Memory Advisor to size memory buffers

Use performance related dynamic views

Troubleshoot invalid or unusable objects

Backup and Recovery Concepts

Identify the types of failure that may occur in an Oracle

Database

Describe ways to tune instance recovery

Identify the importance of checkpoints, redo log files, and

archived log files

Configure ARCHIVELOG mode

Performing Database Backups

Create consistent database backups

Back your database up without shutting it down

Create incremental backups

Automate database backups

Monitor the flash recovery area

Performing Database Recovery

Recover from loss of a control file

Recover from loss of a redo log file

Perform complete recovery following the loss of a data file

Performing Flashback

Describe Flashback database

Restore the table content to a specific point in the past with

Flashback Table

Recover from a dropped table

View the contents of the database as of any single point in

time with Flashback Query

See versions of a row over time with Flashback Versions

Query

View the transaction history of a row with Flashback

Transaction Query

Moving Data

Describe available ways for moving data

Create and use directory objects

Use SQL*Loader to load data from a non-Oracle database

(or user files)

Explain the general architecture of Data Pump

Use Data Pump Export and Import to move data between

Oracle databases