OD-19c-AW: Oracle Database 19c: WHO SHOULD ATTEND?

Administration Workshop
This Oracle Database 19c Administration course
is for anyone who needs to administer, monitor
Course Code: OD-19c-AW
and support an Oracle database.
Duration: 5 days
Instructor-led Training (ILT) | Virtual Instructor-
PREREQUISITES
led Training (VILT)
• Should have an understanding of
OVERVIEW
relational database concepts and good
operating system knowledge.
This course provides detailed information on the
• Should have attended the Oracle SQL
architecture of an Oracle Database instance and
course or have a good working
database, enabling you to effectively manage
knowledge of Oracle SQL.
your database resources. You learn how to
create database storage structures appropriate
MODULES
for the business applications supported by your
database. In addition, you learn how to create
Module 1: Introduction to Oracle Database
users and administer database security to meet
your business requirements. Basic information
• Objectives
on backup and recovery techniques is presented
• Oracle Database Server Architecture:
in this course. To provide an acceptable response
time to users and manage resources effectively, Overview
• Oracle Multitenant Container Database:
you learn how to monitor your database and
manage performance. Introduction
• Oracle Multitenant Container Database:
SKILLS COVERED Architecture
• Oracle Database Instance
Configurations
• Describe Oracle Database architecture
• Database Sharding: Introduction
• Describe Oracle Database Cloud Service
• Oracle Database Server: Interactive
(DBCS) architecture and features
Architecture Diagram
• Create and manage DBCS database
• Summary
deployments
• Configure the database to support your
applications Module 2: Accessing an Oracle Database
• Manage database security and
implement auditing • Objectives
• Implement basic backup and recovery • Connecting to an Oracle Database
procedures Instance
• Move data between databases and files • Oracle Database Tools
• Employ basic monitoring procedures • Database Tool Choices
and manage performance • SQL*Plus
• Oracle SQL Developer
• Oracle SQL Developer: Connections
• Oracle SQL Developer: DBA Actions
• Database Configuration Assistant
(DBCA)
1|Page
 • Oracle Enterprise Manager Database • Starting the Oracle Database Instance
Express • Shutting Down an Oracle Database
• Enterprise Manager Cloud Control 13c Instance
Features • Comparing SHUTDOWN Modes
• Oracle Enterprise Manager Component • Opening and Closing PDBs
Overview • Configuring PDBs to Automatically Open
• Single Pane of Glass for Enterprise • Summary
Management • Practice Overview
• Oracle Enterprise Manager Database
Management Module 6: Managing Database Instances
• Summary
• Objectives
Module 3: Creating an Oracle Database by • Working with Initialization Parameters
Using DBCA • Initialization Parameters
• Modifying Initialization Parameters
• Objectives • Viewing Initialization Parameters
• Planning the Database • Working with the Automatic Diagnostic
• Choosing a Database Template Repository
• Choosing the Appropriate Character Set • Automatic Diagnostic Repository
• How Are Character Sets Used? • Viewing the Alert Log
• Setting NLS_LANG Correctly on the • Using Trace Files
Client • Administering the DDL Log File
• Using the Database Configuration • Querying Dynamic Performance Views
Assistant • Considerations for Dynamic
• Using DBCA in Silent Mode Performance Views
• Summary • Data Dictionary: Overview
• Practice Overview • Querying the Oracle Data Dictionary
• Summary
Module 4: Creating an Oracle Database by • Practice Overview
Using a SQL Command
Module 7: Oracle Net Services: Overview
• Objectives
• Creating a Container Database (CDB)
• Creating a CDB by Using a SQL • Objectives
Command: Example • Connecting to the Database Instance
• Using the SEED FILE_NAME_CONVERT • Oracle Net Services: Overview
Clause • Defining Oracle Net Services
• Using the ENABLE PLUGGABLE Components
DATABASE Clause • Tools for Configuring and Managing
• Summary Oracle Net Services
• Practice Overview • Oracle Net Listener: Overview
• The Default Listener
Module 5: Starting Up and Shutting Down a • Comparing Dedicated and Shared
Database Instance Server Architecture
• Summary
• Objectives
2|Page
Module 8: Configuring Naming Methods • Practice Overview

• Objectives Module 11: Configuring Oracle Connection

• Establishing Oracle Network Manager for Multiplexing and Access Control
Connections
• Connecting to an Oracle Database • Objectives
Instance • Oracle Connection Manager: Overview
• Name Resolution • Oracle Connection Manager Processes
• Establishing a Connection • Oracle Connection Manager:
• User Sessions Architecture
• Naming Methods • Using Filtering Rules
• Easy Connect • Implementing Intranet Access Control
• Local Naming • Implementing Internet Access Control
• Directory Naming • Using Session Multiplexing
• Using Database Services to Manage • Configuring Oracle Connection Manager
Workloads • Configuring the cman.ora File
• Creating Database Services • Example of a cman.ora File
• Summary • Configuring Clients
• Practice Overview • Configuring the Database Server
• Configuring the Database Server for
Module 9: Configuring and Administering the Multiplexing (Optional)
Listener • Using the Oracle Connection Manager
Control Utility
• Objectives • Review of Oracle Connection Manager
• Review: Oracle Net Services Overview Features
• Oracle Net Listener: Overview • Summary
• The Default Listener • Practice Overview
• Configuring Dynamic Service
Registration Module 12: Creating PDBs from Seed
• Configuring Static Service Registration
• Summary • Objectives
• Practice Overview • Provisioning New Pluggable Databases
• Tools
Module 10: Configuring a Shared Server • Creating a New PDB from PDB$SEED
Architecture • Using the FILE_NAME_CONVERT Clause
• Using OMF or the
• Objectives PDB_FILE_NAME_CONVERT Parameter
• Shared Server Architecture: Overview • Summary
• Comparing Dedicated and Shared • Practice Overview
Server Architecture: Review
• Enabling Shared Server Module 13: Using Other Techniques to Create
• Controlling Shared Server Operations PDBs
• SGA and PGA Usage
• Shared Server Configuration • Objectives
Considerations • Cloning Regular PDBs 3Migrating Data
• Summary from a Non-CDB into a CDB
3|Page
 • Plugging a Non-CDB into CDB Using • Types of Segments
DBMS_PDB • How Table Data Is Stored
• Replicating a Non-CDB into a CDB by • Database Block Content
Using GoldenGate • Understanding Deferred Segment
• Cloning a Non-CDB or Remote PDB Creation
• Using DBCA to Clone a Remote PDB • Controlling Deferred Segment Creation
• Plugging an Unplugged Regular PDB • Monitoring Tablespace Space Usage
into CDB • Summary
• Plugging in a PDB Using an Archive File
• Cloning Remote PDBs in Hot Mode Module 16: Creating and Managing
• Near-Zero Downtime PDB Relocatio Tablespaces
• Using DBCA to Relocate a Remote PDB
• Proxy PDB: Query Across CDBs Proxying • Objectives
Root Replica • Creating Tablespaces
• Creating a Proxy PDB • Creating a Tablespace: Clauses
• Summary • Creating Permanent Tablespaces in a
• Practice Overview CDB
• Defining Default Permanent
Module 14: Managing PDBs Tablespaces
• Temporary Tablespaces
• Objectives • Altering and Dropping Tablespaces
• Changing the PDB Mode • Viewing Tablespace Information
• Modifying PDB Settings • Implementing Oracle Managed File
• Impact of Changing Initialization (OMF)
Parameters • Enlarging the Database
• Changing Initialization Parameters: • Moving or Renaming Online Data Files
Example • Examples: Moving and Renaming Online
• Using the ALTER SYSTEM Command in a Data Files
PDB • Summary
• Configuring Host Name and Port • Practice Overview
Number per PDB
• Dropping PDBs Module 17: Improving Space Usage
• Summary
• Practice Overview • Objectives
• Space Management Features
Module 15: Database Storage Overview • Block Space Management
• Row Chaining and Migration
• Objectives • Free Space Management Within
• Database Storage Architecture Segments
• Logical and Physical Database • Allocating Extents
Structures • Using Unusable Indexes
• Segments, Extents, and Blocks • Using Temporary Tables
• Tablespaces and Data Files • Creating Global Temporary Tables
• Default Tablespaces in a Multitenant • Creating Private Temporary Tables
Container Database • Table Compression: Overview
• SYSTEM and SYSAUX Tablespaces • Table Compression: Concepts
4|Page
 • Compression for Direct-Path Insert • Creating Oracle Database Users in a
Operations Multitenant Environment
• Advanced Row Compression for DML • Creating Common Users in the CDB and
Operations PDBs
• Specifying Table Compression • Creating Schema Only Accounts
• Using the Compression Advisor • Authenticating Users
• Resolving Space Usage Issues • Using Password Authentication
• Reclaiming Space by Shrinking • Using Password File Authentication
Segments • Using OS Authentication
• Shrinking Segments • OS Authentication for Privileged Users
• Results of a Shrink Operation • Assigning Quotas
• Managing Resumable Space Allocation • Summary
• Using Resumable Space Allocation • Practice Overview
• Resuming Suspended Statements
• What Operations Are Resumable? Module 20: Configuring Privilege and Role
• Summary Authorization
• Practice Overview
• Objectives
Modile 18: Managing Undo Data • Privileges
• System Privileges
• Objectives • System Privileges for Administrators
• Undo Data: Overview • Object Privileges
• Transactions and Undo Data • Granting Privileges in a Multitenant
• Storing Undo Information Environment
• Comparing Undo Data and Redo Data • Granting Privileges: Example
• Managing Undo • Using Roles to Manage Privileges
• Comparing SHARED Undo Mode and • Assigning Privileges to Roles and
LOCAL Undo Mode Assigning Roles to Users
• Configuring Undo Retention • Oracle-Supplied Roles
• Categories of Undo • Granting Roles in a Multitenant
• Guaranteeing Undo Retention Environment
• Changing an Undo Tablespace to a Fixed • Granting Roles: Example
Size • Making Roles More Secure
• Temporary Undo: Overview • Revoking Roles and Privileges
• Temporary Undo Benefits • Granting and Revoking System
• Enabling Temporary Undo Privileges
• Monitoring Temporary Undo • Granting and Revoking Object Privileges
• Summary • Summary
• Practice Overview • Practice Overview

Module 19: Creating and Managing User Module 21: Configuring User Resource Limits
Accounts
• Objectives
• Objectives • Profiles and Users
• Database User Accounts • Creating Profiles in a Multitenant
• Oracle-Supplied Administrator Accounts Architecture
5|Page
 • Creating Profiles: Example • SQL Loader: Review
• Profile Parameters: Resources • Creating the SQL*Loader Control File
• Profile Parameters: Locking and • SQL*Loader Loading Methods
Passwords • Protecting Against Data Loss
• Oracle-Supplied Password Verification • SQL*Loader Express Mode
Functions • Using SQL*Loader to Load a Table in a
• Assigning Profiles in a Multitenant PDB
Architecture • Summary
• Summary • Practice Overview
• Practice Overview
Module 25: Transporting Data
Module 22: Implementing Oracle Database
Auditing • Objectives
• Data Pump Export and Import Clients
• Objectives • Data Pump Interfaces and Modes
• Database Security • Data Pump Import Transformations
• Monitoring for Compliance • Using Oracle Data Pump with PDBs
• Types of Activities to be Audited • Exporting from a Non-CDB and
• Mandatorily Audited Activities Importing into a PDB
• Understanding Auditing • Exporting and Importing Between PDBs
Implementation • Full Transportable Export/Import
• Viewing Audit Policy Information • Full Transportable Export/Import:
• Value-Based Auditing Example
• Fine-Grained Auditing • Transporting a Database Over the
• FGA Policy Network: Example
• Audited DML Statement: • Using RMAN to Transport Data Across
Considerations Platforms
• FGA Guidelines • RMAN CONVERT Command
• Archiving and Purging the Audit Trail • Transporting Data with Minimum Down
• Purging Audit Trail Records Time
• Summary • Transporting a Tablespace by Using
• Practice Overview Image Copies
• Determining the Endian Format of a
Module 23: Introduction to Loading and Platform
Transporting Data • Transporting Data with Backup Sets
• Transporting a Tablespace
• Objectives • Transporting Inconsistent Tablespaces
• Moving Data: General Architecture • Database Transport: Data Files
• Oracle Data Pump: Overview • Transporting a Database
• Oracle Data Pump: Benefits • Transporting a Database: Conversion
• SQL Loader: Overview • Transporting a Database: Example
• Summary • Transporting a Database:
Considerations
Module 24: Loading Data • Transporting a Database with Backup
Sets
Objectives • Summary
6|Page
 • Practice Overview • Summary
• Practice Overview
Module 26: Using External Tables to Load and
Transport Data Module 29: Database Monitoring and Tuning
Performance Overview
• Objectives
• External Tables • Objectives
• External Tables: Benefits • Performance Management Activities
• ORACLE_LOADER Access Driver • Performance Planning Considerations
• ORACLE_DATAPUMP Access Driver • Database Maintenance
• External Tables • Automatic Workload Repository (AWR)
• Viewing Information About External • Automatic Database Diagnostic Monitor
Tables (ADDM)
• Summary • Configuring Automatic ADDM Analysis
• Practice Overview at the PDB Level
• Advisory Framework
Module 27: Automated Maintenance Tasks: • Performance Tuning Methodology
Overview • Summary

• Objectives Module 30: Monitoring Database Performance

• Proactive Database Maintenance
Infrastructure • Objectives
• Automated Maintenance Tasks: • Server-Generated Alerts
Components • Setting Metric Thresholds
• Predefined Automated Maintenance • Reacting to Alerts
Tasks • Alert Types and Clearing Alerts
• Maintenance Windows • Database Server Statistics and Metrics
• Predefined Maintenance Windows • Performance Monitoring
• Viewing Maintenance Window Details • Viewing Statistics Information
• Automated Maintenance Tasks • Monitoring Wait Events
• Summary • Monitoring Sessions
• Monitoring Services
Module 28: Automated Maintenance Tasks: • Summary
Managing Tasks and Windows • Practice Overview

• Objectives Module 31: Database Processes

• Configuring Automated Maintenance
Tasks • Objectives
• Enabling and Disabling Maintenance • Process Architecture
Tasks • Process Structures
• Creating and Managing Maintenance • Database Writer Process (DBWn &
Windows BWnn)
• Resource Allocations for Automated • Log Writer Process (LGWR & LGnn)
Maintenance Tasks • Checkpoint Process (CKPT)
• Changing Resource Allocations for • System Monitor Process (SMON)
Maintenance Tasks • Process Monitor Process (PMON)
7|Page
 • Process Manager (PMAN) • Optimizer Statistics Collection
• Recoverer Process (RECO) • Setting Optimizer Statistics Preferences
• Listener Registration Process (LREG) • Optimizer Statistics Advisor
• Manageability Monitor Process • Optimizer Statistics Advisor Report
(MMON) • Executing Optimizer Statistics Advisor
• Archiver Processes (ARCn) Tasks
• Interacting with an Oracle Database: • SQL Plan Directives
Memory, Processes, and Storage • Adaptive Execution Plans
• Summary • SQL Tuning Advisor: Overview
• Practice Overview • SQL Access Advisor: Overview
• SQL Performance Analyzer: Overview
Module 32: Managing Memory • Managing Automated Tuning Tasks
• Summary
• Objectives • Practice Overview
• Managing Memory Components
• Shared Pool
• Database Buffer Cache END OF PAGE
• Redo Log Buffer
• Large Pool
• Java Pool
• Streams Pool
• Program Global Area (PGA)
• Managing Memory Components
• Efficient Memory Usage: Guidelines
• Automatic Memory Management
• Monitoring Automatic Memory
Management
• Automatic Shared Memory
Management
• Understanding Automatic Shared
Memory Management
• Oracle Database Memory Parameters
• Managing the SGA for PDBs
• Managing the Program Global Area
(PGA)
• Managing the PGA for PDBs
• Summary
• Practice Overview

Module 33: Analyzing SQL and Optimizing

Access Paths

• Objectives
• SQL Tuning Process
• Oracle Optimizer
• Optimizer Statistics
8|Page