Oracle Database Administration

Audience

This course is well suited to database administrators, system administrators and support staff.

This course is suitable for all recent versions of Oracle including 12c, 18c, and 19c.

Prerequisites

Delegates should have some knowledge of their operating system, together with Oracle SQL*Plus or SQL Developer skills. Our Oracle SQL course is the ideal way to gain this experience.

Duration

5 days. Hands on.

Course Objectives

This Oracle Database Administration course explores the fundamentals of basic database administration. The course is based around using the command line, but will provide Enterprise Manager Express and Cloud Control to complement and enhance the learning experience.

During this course, delegates will:

Install and create an Oracle Database
Discover the Oracle database architecture
Create and manage users
Create and manage storage structures
Administer the Oracle Database
Understand backup and recovery
Understand Oracle Flashback technology
Manage space requirements
Monitor and manage performance
Understand the Oracle Scheduler

Course Content

Oracle Concepts Overview
Oracle Components
The Oracle Instance
The Oracle Database
Oracle Processes
The Listener
Grid Infrastructure Overview
Oracle Restart
Automatic Storage Management

Oracle Database Software Installation
Pre-installation Tasks
Installation Process

Oracle Database Creation
Using the Database Configuration Assistant

Managing an Oracle Database Instance
Connecting as a privileged user
Startup and Shutdown
Initialisation Parameters
Understanding Oracle Processes
Understanding System Global Area Components
Managing the System Global Area size
Understanding Program Global Area Components
Managing the Program Global Area size
The Automatic Diagnostic Repository
The Data Dictionary

Control Files and Tablespaces
Understanding the role of Control Files
Understanding Tablespaces
Understanding Data Files
Oracle Managed Files

Redo Logging
Understanding the role of Redo Logging
Redo Log Groups
Redo Log File Multiplexing

Undo Management
Understanding the role of Undo
Managing the Undo Tablespace

Networking
The role of the Listener
Managing the Listener
Network Configuration Files
Contrasting Dedicated and Shared Server configurations

Security
User Management
Database Privileges
Database Roles
Auditing Methods
Oracle Data Redaction

The Oracle Scheduler
Automating Tasks using:
• Jobs
• Programs
• Schedules
• Windows
• Chains

Moving Data
Using SQL*Loader
Using External Tables
Using Datapump
Using Datapump Legacy Mode

Performance Management
Understanding Performance components:
• The Optimiser
• Statisitics Management
• Wait Events
• Memory Advisors
• The Automatic Workload Repository
• Performance Advisors

Database Resource Management
Managing Database Resources with:
• Consumer Groups
• Resource Plans
• Directives

Managing Space
Understanding Segments, Extents and Oracle Blocks
Describing Database Objects, such as:
• Tables
• Indices
• Partitioning
• Clusters
Using Automatic Segment Space Management
Using Compression
Shrinking Segments
Resumable Space Management
Information Lifecycle Management
In Database Archiving
Temporal