Installing Oracle Database 10g Software:
- Optimal Flexible Architecture (OFA)
- Setting Environment Variables
- Preinstallation Checks
- Prerequisite Checks
- Configuration and Management
|
|
Creating an Oracle Database:
- Database Architecture
- Exploring the Storage Structure
- Tablespaces and Datafiles
- Segments, Extents, and Blocks
- Grid Control
|
Database Interfaces:
- Enterprise Manager:
- Querying Data
- Joining Tables
- Overview of Transactions
|
|
Controlling the Database:
- Management Framework
- Initialization Parameter Files
- The Alert Log
|
Storage Structures:
- Tablespaces and Data Files
- Space Management in Tablespaces
- Creating a New Tablespace
- Storage for Locally Managed Tablespaces
|
|
Administering Users:
- Creating a User
- Privileges
- Roles
|
|
Managing Schema Objects:
- Creating and Modifying Tables
- Defining Constraints
- Creating Indexes
- Creating Views
- Using a Sequence
|
|
Managing Data:
- Manipulating Data Through SQL
- Data Pump
- SQL*Loader & SQL*Loader Control File
- Comparing Direct and Conventional Path Loads
|
PL/SQL:
- Administering PL/SQL Objects
- Functions
- Procedures
- Packages
- Triggers
|
|
Oracle Database Security:
- Apply the Principle of Least Privilege
- Limit Users with Administrative Privileges
- Manage Default User Accounts
- Monitoring for Suspicious Activity
|
Oracle Net Services:
- Oracle Net Listener
- Advanced Connection Options
- Oracle Net Manager
- Testing Oracle Net Connectivity
|
|
Oracle Shared Servers:
- Dedicated Server Process
- Processing a Request
- The SGA and PGA
- Configuring Oracle Shared Server
- When Not to Use Shared Server
|
Performance Monitoring:
- Monitoring Methodologies
- Manually Gather Optimizer Statistics
- Automate Optimizer Statistics Collection
- Viewing Metric Information
- Reacting to Performance Issues
|
|
Proactive Maintenance:
- Setting Thresholds
- Using Baselines
- Memory Advisors
- Segment Advisor
- Automatic Workload Repository (AWR)
- ADDM Findings
|
Undo Management:
- Transactions and Undo Data
- Administering Undo
- Configuring Undo Retention
|
|
Monitoring and Resolving Lock Conflicts:
- Locking Mechanism
- Enqueue Mechanism
- Lock Conflicts
- Detecting Lock Conflicts
- Resolving Lock Conflicts
|
Backup and Recovery:
- Objectives
- Backup and Recovery Issues
- Instance Failure
- Instance Recovery
- Media Failure
- Configuring Backup Settings
- Manage Backups & Recovery
|
|
|
