Oracle Database Architecture

• Databases and instances overview
• Multitenant architecture
• Sharding architecture
• Architecture diagram on the OHC
• Physical storage structures
• Logical storage structures
• Logical and physical storage structures
• Data storage: segments, extents, blocks
• Types of segments
• Deferred segment creation
• Block structure
• Tablespaces and datafiles
• Processes
• Memory structures
• Overview of Oracle Net Services
• Overview of the Listener
• Dedicated and shared server processes

Creating and Administering an Oracle Database

• Use the Database Server Architecture lesson of the Oracle Database Architecture module
• Connecting to an Oracle Database instance
• Overview of Oracle Database tools
• Prepare to create the database
• Determine the character set to be used
• Create a Multitenant Oracle Database (CDB)
• Using DBCA in silent mode
• Shut down the database instance and start the database instance/open the database
• Open and close PDBs
• Investigating Initialization Parameter Files
• Viewing Initialization Parameters by Using SQL*Plus
• Modifying Initialization Parameters by Using SQL*Plus
• Viewing Diagnostic Information

Configuring and Administering Oracle Net Services

• Use the Oracle Net Services Architecture lesson of the Oracle Database Architecture module
• Naming methods
• Define service names so users can connect to the database
• 19c Easy Connect Syntax Improvements (76634-2)
• Create listeners
• Configure listeners for dynamic or static service registration
• Implement failover and load balancing features
• Configure shared server architecture
• Implement session multiplexing and access control features
• Configure the cman.ora file on the Oracle Connection Manager computer
• Configure the clients with the protocol address of the Oracle Connection Manager listener
• Configure the database server for session multiplexing
• Configure the cman.ora file to set up Oracle Database Cloud Traffic Manager

Creating and Administering Pluggable Databases

• Create PDBs from seed
• Clone a regular PDB
• Unplug and plug or clone a non-CDB
• Unplug and plug a regular PDB
• Perform hot cloning
• Perform near-zero downtime PDB relocation
• Create and use a proxy PDB
• Use DBCA to clone and relocate PDBs, and duplicate CDBs
• Change PDB mode
• Modify PDB settings
• Rename a PDB service
• Drop a PDB

Creating and Managing Database Storage

• Use the Database Storage Structures lesson of the Oracle Database Architecture module
• Create tablespaces to store database objects
• Implement Oracle Managed Files (OMF)
• View tablespace information
• Drop a tablespace
• Increase the size of the database (add datafiles, extend tablespaces, etc.)
• Move or rename datafiles
• Proactively monitor and manage tablespace space usage
• Define default permanent tablespaces
• Define a default temporary tablespace for a PDB
• Save space by using compression
• Reclaim wasted space from tables and indexes by using the segment shrink functionality
• Manage resumable space allocation
• Configure undo retention
• Enable and disable temporary undo
• Use local undo

Managing Users and Securing the Database

• Create database users
• Create common users in the CDB root and application root
• Create local users in regular PDBs and application PDBs
• Assign quota to database users
• Authentication
• Oracle-defined schema-only accounts
• Provide users with access to the database (privileges/roles)
• Create common roles in the CDB root and application root
• Create local roles in regular PDBs and application PDBs
• Grant privileges/roles commonly in the CDB root and application root
• Grant privileges/roles locally in regular PDBs and application PDBs
• Create profiles to control user security and resource utilization
• Create common profiles in the CDB root and application root
• Create local profiles in regular PDBs and application PDBs
• Audit the use of the database (objects, privileges, etc.)
• Audit actions in the CDB and PDBs

Loading and Transporting Data

• Load data (Data Pump, SQL*Loader)
• Utilities to load/maintain data in the database
• Use SQL*Loader to load data
• Use SQL*Loader with PDBs
• Use Data Pump to transport (move) data
• Move data from one database to another database
• Use Data Pump with PDBs
• Use the full transportable export/import feature to move an entire database to a different database instance
• Use the transportable tablespaces feature to move a set of tablespaces between databases
• Use the transportable tables feature to move a set of tables, partitions, and sub-partitions between databases
• Use external tables as a data source

Managing Automated Maintenance Tasks

• Overview of automated maintenance tasks
• Overview of maintenance windows
• Configure automated maintenance tasks
• Enable and disable maintenance tasks
• Create a maintenance window
• Modify a maintenance window
• Remove a maintenance window
• Reduce or increase resource allocation to the automated maintenance tasks

Monitoring and Tuning Database Performance

• Performance management activities
• Performance planning
• Performance tuning methodology
• Automatic performance tuning features (AWR, ADDM, advisors)
• PDB-level ADDM
• Monitor database instance performance
• Monitor database errors and alerts to prevent, detect, and solve problems (alert log, trace files, server-generated alerts)
• Set metric thresholds
• Monitor locks and wait events
• Configure memory management
• Set optimizer statistics preferences
• Identify and tune SQL statements that are using the most resources
• Tune a workload
• Manage automated tuning tasks