Getting Started
Course Objectives00:00:00
Exploring Oracle Database Architecture
Oracle Database Tools
Oracle-Supplied User Accounts
Oracle Database Server Architecture
Oracle SQL and PL/SQL
Connecting to Oracle Databases
Introducing Oracle Database
Relation Database Models
Querying the Oracle Data Dictionary00:00:00
Managing Database Instances
Shutting Down Oracle Databases
Querying Dynamic Performance Views
Working with the Automatic Diagnostic Repository (ADR)
Opening and Closing PDBs
Starting Up Oracle Databases
Initialization Parameter Files00:00:00
Creating PDBs
Methods and Tools to Create PDBs
Dropping PDBs with SQL*Plus
Unplugging and Pluggin In PDBs with SQL*Plus
Cloning PDBs with SQL*Plus
Creating PDBs from Seed with SQL*Plus
Configuring the Oracle Network Environment
How Listeners Work
Testing Oracle Net Connectivity with tnsping
Oracle Net Services
Configuring Listeners for Dynamic Service Registration
Configuring Local Naming for Connections
Configuring Communidation Between Databases
Configuring Listeners for Static Service Registration
Dedicated Versus Shared Server Configurations
Administering User Security
Authenticating Users
Assigning Quotas to Users
Creating Users
Granting Privileges
Creating and Granting Roles
Creating and Assigning Profiles
Applying the Principal of Least Privilege
Revoking Privileges and Roles
Creating and Managing Tablespaces
Implementing Oracle Managed Files
Creating Tablespaces in SQL*Plus
Moving and Renaming Online Data Files in SQL*Plus
Viewing Tablespace Information in SQL*Plus
How Table Data is Stored
Altering and Dropping Tablespaces in SQL*Plus
Managing Storage Space
Block Space Management
Allocating Extents
Free Space Management Within Segments
Row Chaining and Migration
Space-Saving Features
Types of Segments
Oracle Database Space Management Features
Understanding Deferred Segment Creation
Managing UNDO Data
Local Undo Mode Versus Shared Undo Mode
Comparing Undo Data and Redo Data
Undo Data: Overview
Configuring Undo Retension
Categories of Undo
Storing Undo Information
Transactions and Undo Data
Managing Undo
Moving Data
Oracle Data Pump: Benefits
Data Pump Export and Import Clients
SQL*Loader Overview
Loading Methods
Data Pump Utility: Interfaces and Modes
Oracle Data Pump: Overview
Data Pump Import: Transformations
Moving Data: General Architecture
Backup and Recovery Concepts
Categories of Failure
Understanding Types of Backups
Understanding Instance Recovery
Flashback Technology
DBA Responsibilities
Oracle Data Protection Solutions
Comparing Complete and Incomplete Recovery
Monitoring and Tuning Database Performance
Database Maintenance
Automatic Database Diagnostic Monitor
Automatic Workload Repository (AWR)
Database Server Statistics and Metrics
Performance Tuning Methodology
Performance Planning Considerations
Managing Performance Activities
Performance Monitoring
SQL Tuning
Oracle Optimizer
SQL Access Advisor
SQL Plan Directives
SQL Tuning Advisor
SQL Tuning Process
Optimizer Statistics
Adaptive Execution Plans
SQL Performance Analyzer
Oracle Database Resource Manager
Resource Manager Elements
Limiting CPU Utilization at the Database Level
Using the Active Session Pool Feature
Creating a Complex Resource Plan
Oracle Database Resource Manager: Overview
Limiting CPU Utilization at the Server Level
Creating a Simple Resource Plan
Using Resource Manager to Allocate Resources
Enterprise Manager Cloud Control
Controlling the Enterprise Manager Cloud Control Framework
Starting the Enterprise Manager Cloud Control Framework
Stopping the Enterprise Manager Cloud Control Framework
Introduction to Oracle Database Cloud Service
DBCS Architecture
Oracle Cloud: Overview
Additional Database Configuration Options
Database Cloud Service Offerings
Features and Tooling
Creating DBCS Database Deployments
Creating a Database Deployment
Automated Database Provisioning
Creating an SSH Key Pair
How SSH Key Pairs are Used
Storage Used for Database Files
Managing DBCS Database Deployments
Managing Network Access to DBCS
Cloud Tooling
Accessing Tools and Features from the DBCS Console
Enabling Access to a Compute Node Port
Scaling a Database Deployment
Managing the Compute Node Associated With a Database Deployment
Backing Up and Restoring DBCS Database Deployments
Backing Up and Recovering Databases on DBCS
Creating an On-Demand Backup
Performing Recovery by Using the Console
Performing Recovery by Using the dbaascli Utility
Backup Configuration
Customizing the Backup Configuration
Backup Destination Choices
Patching DBCS Database Deployments
Using the dbaascli Utility to Manage Patches
Using the DBCS Console to Manage Patches
Patching DBCS
Creating Master Encryption Keys for PDBs
Creating and Activating an Encryption Key
Determining Whether You Need to Create and Activate and Encryption Key for a PDB
CDB and PDB Master Encryption Keys
Tablespace Encryption by Default
Defining the Keystore Location
Transparent Data Encryption (TDE) Overview
Managing the Software Keystore and Master Encryption Key
Managing the Keystore in CDBs and PDBs
Using TDE
Components of TDE
Tablespace Encryption by Default in DBCS
Controlling Tablespace Encryption by Default
