Course Content
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
- Using the EM Interface
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
