Oracle DBA Training & Syllabus
Enterprise Edition Installation
- Identify System Requirements
- The Optimal Flexible Architecture (OFA)
- Oracle_Base
- Oracle Home
- Configure the Installation Environment
- Enterprise Edition Installation
- DBCA
The Administrator Interface
- Enterprise Manager Tour
- Using Em Sql Worksheet
- Duties of a Database Administrator
- Exploring the Oracle Database Architecture: General
The Oracle Enterprise Architecture
Exploring the Oracle Database Architecture: Instance Memory
- What Is An Oracle Database Instance?
- More about the System Global Area (SGA)
- About the PGA
- Managing Memory
Exploring the Oracle Database Architecture: Instance Processes
- Instance Background Processes
- Sql Execution Processes
Creating an Oracle Database
- Create a New Database
- Configure an Existing Database
- Drop a Database
- Manage DBCA Templates
- Manually Create a Database
Managing the Database Instance
- Configuring a Linux Environment
- Starting & Stopping Database Control
- Starting & Stopping the Database Listener
- Starting & Stopping the Database Instance
- More about the Database Files
Manage Database Storage Structures: Tablespaces
- About Tablespaces
- Tablespace Management
- Drop Tablespace
- Alter Tablespace
Manage Database Storage Structures: Advanced Tablespaces
- More about Temporary Tablespaces
- About Temporary Tablespace Groups
- More about Permanent Tablespaces
- More about Bigfile Tablespaces
- More about the Sysaux Tablespace
Manage Database Storage Structures
- Data Files & Temp Files
- Managing Data Files
- Managing Temp Files
- Enable Oracle-Managed Files (OMF)
Managing Undo Data
- About Undo Space Management
- Configure Automatic Undo Management
- Undo_Management
- Undo_Tablespace
- Undo_Retention
- Guarantee Undo Retention
- Monitor Undo Space
- Use the Undo Advisor
Network Environment: Oracle Shared Servers
- Shared Servers Architecture
- Configure Shared Servers
- Monitor Shared Servers
- V$Shared_Server
- V$Shared_Server_Monitor
- V$Session
- V$Circuit
- V$Dispatcher & V$Dispatcher_Config
- V$Queue
Security: Implementing Database Security
- Database System Privileges
- Database Object Privileges
- Administrator Auditing Of Database Activity
- Enhanced Default Security Settings
Security: Administering User Security
- Create & Manage Database Accounts
- Grant & Revoke Database Privileges
- Resource Limits via Profiles
- Alter Profile
- Drop Profile
- Password Management via Profiles
- About Role-Based Security
- With Admin Option
- Alter User...Default Role
- Set Role
- Enhanced Default Security Settings
Moving Data: Sql Loader
- Loader Concepts
- Control File Options
- Load Methods
- Using the Em Interface
Moving Data: Export & Import
- Manage Directory Objects
- About the Data Pump Architecture
- Data Pump Export
- Data Pump Import
- Data Pump Data Dictionary Views
Database Maintenance & Performance Management
- The Management & Advisory Framework
- Manage the Automatic Workload Repository
- Automatic Database Diagnostic Monitor
- Use Metrics & Alert Thresholds
- Automatic Maintenance Tasks
Managing Concurrency & Locks
- About Latches & Locks
- Manage & Monitor Latches
- Manage & Monitor Locks
- V$Lock
- V$Locked_Object
- V$Session
- V$Session_Wait
- Dba_Blockers & Dba_Waiters
- Dba_Dml_Locks & Dba_Ddl_Locks
- Dml_Locks
Backup & Recovery Concepts & Configuration
- About Database Backup & Recovery Structures
- Managing Redo Data
- Managing Archival Data
- Automatic Crash Recovery
- Creating a Basic Backup Strategy
