오라클 10g 구축과 활용

Chapter 1 Linux & Oracle10g
Oracle Enterprise Edition 10g Product and Certify
Linux 설치
Oracle10g Install을 위한 OS 설정
Oracle10g Installation
Management After Installation

Chapter 2 Creation & Upgrade (em)
Database Creation 유형
Database Creation
Upgrade
em 설정 및 확인
Initialization Parameters

Chapter 3 Data Control & Management
External Table
DataPump
New Cluster Features
Tablespaces
Files
LOB
Segments

Chapter 4 Application Support
SQL*Plus Enhancement
SQL Statement
Partitioned Outer Join
SQL Model Clause
Materialized View
Indexes
Scheduling
Special Sort

Chapter 5 Virtual Private Database
VPD New Features
Auditing Enhancement

Chapter 6 Flashback - Time Machine
Flashback Features
Row Level Recovery
Tabel Level Recovery
Database Level Recovery
Flashback Guide

Chapter 7 자가관리(self-management) Database System
자동진단(automatic diagnostic) 시스템
SGA Memory 관리 자동화
통계정보 자동관리
Undo & Checkpoint 자동 Tuning
AWR (Automatic Workload Repository)
Alert & Notification (경보와 알림기능)
Cost & Optimizer
Support SQL Tuning
Instance Monitoring
Resource Manger
Space 관리 자동화

Chapter 8 Backup and Recovery
Flash Backup and Recovery
Recovery and Incremental Backup
RMAN and Backup
RMAN and Recovery
Others

Chapter 9 Automatic Storage Management
ASM Install
ASM 및 설정

Chapter 10 그 밖의 것들
Monitoring and Tracing
Simple Configuration
Resumable Space and Flush Buffer
Enhanced Packages
Clone and Compatibility