P10380 – Oracle Database 18c: Administration Workshop

Module 1: Introduction

• Sample HR Schema
• Oracle Cloud Overview
• Oracle Database Editions, Options, and Management Packs

Module 2: Oracle Database Architecture

• Automatic Storage Management (ASM) Overview
• Oracle Database Instance Configurations
• Oracle Database Memory and Process Structures
• Connecting to the Database Instance
• Logical and Physical Database Structures
• Multitenant Architecture
• Oracle Database Server Architecture

Module 3: Introduction to Oracle Database Cloud

• Automated Database Provisioning
• Oracle Database Cloud Service Architecture
• Features and Tooling

Module 4: Creating Oracle Database Cloud Service (DBCS) Deployments

• SSH Key Pairs
• Database File Storage
• Input to the Creation Wizard

Module 5: Accessing an Oracle Database

• Oracle Database Cloud Service Tools
• Database Configuration Assistant (DBCA)
• Oracle Enterprise Manager Cloud Control
• Oracle enterprise Manager Database Express
• SQL Developer
• SQL*Plus

Module 6: Managing DBCS Database Deployments

• Managing Network Access to DBCS
• Managing the Compute Node
• Scaling a Database Deployment
• Patching a Database Deployment

Module 7: Managing Database Instances

• Starting Up Oracle Database Instances
• Data Dictionary Views
• Shutting Down Oracle Database Instances
• Dynamic Performance Views
• Automatic Diagnostic Repository (ADR)
• Alert Log and Trace Files
• Initialization Parameter Files

Module 8: Oracle Net Services

• Oracle Net Services Administration Tools
• Configuring Communication Between Database Instances
• Oracle Net Listener Overview
• Connecting to an Oracle Database Instance
• Comparing Dedicated and Shared Server Configurations
• Naming Methods

Module 9: Administering User Security

• Assigning Quotas to Users
• Applying the Principal of Least Privilege
• Managing Oracle Cloud Users, Privileges, and Roles
• Creating and Assigning Profiles
• User Authentication
• Managing Oracle Database Users, Privileges, and Roles

Module 10: Creating PDBs

• Dropping PDBs
• Cloning PDBs
• Methods and Tools to Create PDBs
• Creating PDBs from Seed
• Unplugging and Plugging in PDBs

Module 11: Creating Master Encryption Keys for PDBs

• Overview of Transparent Data Encryption (TDE)
• Creating and Activating an Encryption Key
• CDB and PDB Master Encryption Keys
• Encryption in Oracle Database Cloud Service

Module 12: Creating and Managing Tablespaces

• Viewing Tablespace Information
• Creating, Altering and Dropping Tablespaces
• Table Data Storage
• Tablespace Encryption by Default in DBCS
• Implementing Oracle Managed Files
• Moving and Renaming Online Data Files

Module 13: Managing Storage Space

• Resumable Space Allocation
• Shrinkable Segments
• Deferred Segment Creation
• Space-Saving Features
• Oracle Database Space Management Features
• Types of Segments
• Table and Row Compression
• Block Space Management

Module 14: Managing Undo Data

• Comparing Local Undo Mode and Shared Undo Mode
• Transactions and Undo Data
• Storing Undo Information
• Configuring Undo Rentention
• Comparing Undo Data and Redo Data
• Temporary Undo

Module 15: Moving Data

• External Tables
• Oracle Data Pump
• Migrating to Oracle Database Cloud Service
• SQL Loader

Module 16: Backup and Recovery Concepts

• Point-in-time Recovery
• Complete Recovery
• Categories of Failure
• Flashback Technology
• Instance Recovery

Module 17: Backup and Recovery Configuration

• Configuring ARCHIVELOG Mode
• Configuring and Monitoring the Fast Recovery Area
• Multiplexing Control Files
• Multiplexing Redo Log Files
• Archive Redo Log Files

Module 18: Creating Database Backups

• RMAN Backup Types
• On-Demand Backups on DBCS
• Using Recovery Manager (RMAN)
• Backup Terminology
• Automatic Backups on Database Cloud Service (DBCS)

Module 19: Performing Database Recovery

• Database Recovery Advisor
• Recovering Data Files in ARCHIVELOG Mode
• Recovering Data Files in NOARCHELOG Mode
• Recovery Options in Database Cloud Service (DBCS)

Module 20: Monitoring and Tuning Database Performance

• Managing Memory Components
• Automatic Workload Repository (AWR)
• Advisory Framework
• Monitoring Wait Events, Sessions, and Services
• Managing Metric Thresholds and Alerts
• Performance Tuning Methodology
• Performance Planning Considerations
• Automatic Database Diagnostic Monitor (ADDM)

Module 21: SQL Tuning

• Oracle Optimizer
• SQL Tuning Advisor
• SQL Performance Analyzer
• Optimizer Statistics
• SQL Access Advisor
• SQL Tuning Process