Oracle 10g Administrator I
Installing the Oracle Database Software
* Installation: System Requirements
* Checking the System Requirements
* Optimal Flexible Architecture (OFA)
* Setting Environment Variables
* Installing the Oracle Software
Creating an Oracle Database
* Database Configuration Assistant (DBCA)
* Using the DBCA to Create a Database
Managing the Oracle Instance
* Starting and Stopping Database Control
* Oracle Enterprise Manager
Managing Database Storage Structures
* How Table Data Is Stored
* Table spaces and Data Files
* Space Management in Table spaces
* What Is Automatic Storage Management?
* ASM: Key Features and Benefits
* ASM: Concepts
Administering User Security
* Database User Accounts
* Authenticating Users
* Administrator Authentication
* Unlocking a User Account and Resetting the Password
* Creating a Password Profile
Managing Schema Objects
* What Is a Schema?
* Accessing Schema Objects
* Naming Database Objects
* Types of Indexes
* B-Tree Index
* Bitmap Indexes
* What Is a View?
* Creating Views
* Sequences
* Creating a Sequence
* Data Dictionary:
* Data Dictionary Views
Managing Data and Concurrency
* Manipulating Data Through SQL
Managing Undo Data
* Data Manipulation
* Undo Data
* Undo Data Versus Redo Data
* Configuring Undo Retention
* Guaranteeing Undo Retention
Implementing Oracle Database Security
* Database Security
* Standard Database Auditing
* Uniform Audit Trails
* Value-Based Auditing
* Fine-Grained Auditing
* DBA Auditing
Configuring the Oracle Network Environment
* Oracle Net Services
* Oracle Net Listener
* Establishing Net Connections
* Establishing a Connection
* Naming Methods
Proactive Maintenance
* Optimizer Statistics
* Using the Manage Optimizer Statistics
* Automatic Workload Repository (AWR)
* Automatic Database Diagnostic Monitor (ADDM)
* Enterprise Manager and Advisors
Performance Management
* Performance Monitoring
* SQL Tuning Advisor:
* Enabling Automatic Shared Memory Management (ASMM)
* Using the Memory Advisor
Oracle 10g Administrator II
Backup and Recovery Concepts
Performing Database Backups
* Oracle Secure Backup
* User-Managed Backup
* Recovery Manager (RMAN)
* Managing Backups
Performing Database Recovery
Performing Flashback
* When to Use the Flashback Technology
Moving Data
* Loading Methods
* Data Pump:
* Data Pump Export and Import:
* Data Pump Utility
* External Table Population with ORACLE_DATAPUMP
* External Table Population with ORACLE_LOADER
Configuring Recovery Manager
Using Recovery Manager
Database Recovery
Flashback
Dealing With Database Corruption
Monitoring and Managing Memory
* Memory Management
* How ASMM Works and how to Configure
Automatic Performance Management
* Tuning Activity
* Performance Planning
* Static’s collection
* Troubleshooting and Tuning
* Database Control and Advisor
Managing Storage
* Space Management
* Extends Types
* Row Changing and Migration
* Monitoring Table space
* Transporting Table space
* Transporting Database
Automatic Storage Management
* ASM Architecture
* Creating ASM Instance
* ASM Storage
* Disk Group Mirroring
* ASM files
* Migrating Database to ASM instance
