Exploring the Oracle Database Architecture
o Oracle Database Architecture Overview
o Interacting with an Oracle Database
o Process Architecture
o Database Storage Architecture
o Logical and Physical Database Structures
o Tablespaces and Data Files
o SYSTEM and SYSAUX Tablespaces
o Segments, Extents, and Blocks
Preparing the Database Environment
o Tasks of an Oracle Database Administrator
o Tools Used to Administer an Oracle Database
o Installation: System Requirements
o Optimal Flexible Architecture (OFA)
o Setting Environment Variables
o Oracle Universal Installer (OUI)
o Database Configuration Options
o Advanced Installation Options
Creating an Oracle Database
o Planning the Database
o Configuring the Listener
o Using the DBCA to Create a Database
o Password Management
o Creating a Database Design Template
o Using the DBCA to Delete a Database
o Using DBCA For Additional Tasks
Managing the Oracle Instance
o Management Framework
o Oracle Enterprise Manager
o Initialization Parameter
o Database Startup and Shutdown
o Shutdown Modes
o Viewing the Alert History
o Using Trace Files
o Data Dictionary: Overview
Configuring the Oracle Network Environment
o Oracle Net Services & Listener
o Establishing Net Connections
o Tools for Configuring and Managing the Oracle Network
o Net Services Administration Pages
o Naming Methods
o Directory Naming
o SGA and PGA
o When Not to Use a Shared Server
Managing Database Storage Structures
o Storage Structures
o How Table Data Is Stored
o Anatomy of a Database Block
o Space Management in Tablespaces
o Tablespaces in the Preconfigured Database
o Actions with Tablespaces
o Oracle Managed Files (OMF)
o ASM: Concepts
Administering User Security
o Database User Accounts
o Predefined Accounts: SYS and SYSTEM
o Administrator Authentication
o Benefits of Roles
o Predefined Roles
o Implementing Password Security Features
o Assigning Quota to Users
Managing Schema Objects
o What Is a Schema?
o Accessing Schema Objects
o Specifying Data Types in Tables
o Creating and Modifying Tables
o Understanding Data Integrity
o Indexes & Views
o Sequences
o Temporary Tables
Managing Data and Concurrency
o Manipulating Data Through SQL
o PL/SQL
o Administering PL/SQL Objects
o Functions, Procedures, Packages & Triggers
o Data Concurrency
o Enqueue Mechanism
o Resolving Lock Conflicts Using SQL
o Deadlocks
Managing Undo Data
o Data Manipulation
o Transactions and Undo Data
o Undo Data Versus Redo Data
o Configuring Undo Retention
o Guaranteeing Undo Retention
o Using the Undo Advisor
o Viewing System Activity
Implementing Oracle Database Security
o Industry Security Requirements
o Principle of Least Privilege
o Monitoring for Compliance
o Value-Based Auditing
o Fine-Grained Auditing
o DBA Auditing
o Security Updates
o Applying Security Patches
Database Maintenance
o Introducing Terminology
o Optimizer Statistics
o Automatic Workload Repository (AWR)
o Automatic Database Diagnostic Monitor (ADDM)
o Advisory Framework
o Automated Maintenance Tasks
o Server-Generated Alerts
o Reacting to Alerts
Performance Management
o Performance Monitoring
o Managing Memory Components
o Enabling Automatic Memory Management (AMM)
o Automatic Shared Memory Advisor
o Using Memory Advisors
o Dynamic Performance Statistics
o Troubleshooting and Tuning Views
o Invalid and Unusable Objects
Backup and Recovery Concepts
o Part of Your Job
o Statement Failure
o User Error
o Understanding Instance Recovery
o Phases of Instance Recovery
o Using the MTTR Advisor
o Media Failure
o Archive Log Files
Performing Database Backups
o Backup Solutions: Overview
o Oracle Secure Backup
o User-Managed Backup
o Terminology
o Recovery Manager (RMAN)
o Configuring Backup Settings
o Backing Up the Control File to a Trace File
o Monitoring the Flash Recovery Area
Performing Database Recovery
o Opening a Database
o Data Recovery Advisor
o Loss of a Control File
o Loss of a Redo Log File
o Data Recovery Advisor
o Data Failures
o Listing Data Failures
o Data Recovery Advisor Views
Moving Data
o Moving Data: General Architecture
o Directory Object: Overview
o SQL*Loader: Overview
o Data Pump: Overview
o Performance Initialization Parameters
o Using Enterprise Manager to Monitor Data Pump Jobs
o Data Dictionary
Enhancing Database Capabilities
o Using EM Support Workbench
o Create a Service Request
o Package and upload diagnostic data to Oracle Support
o Track the SR and Implement Repairs
o Incident Packaging Configuration
o Working with Oracle Support
o MetaLink Integration
o Managing Patches
