This comprehensive and advanced-level training is designed for Database Administrators (DBAs) aiming to specialize in installing, configuring, monitoring, and securing Oracle Database 23ai systems. Throughout the course, participants will engage in hands-on and in-depth instruction across Oracle architecture, multitenant database structures (CDB/PDB), network services, user and privilege management, data security, performance tuning, data transport, and automated maintenance tasks.
Oracle Database 23ai: SQL Workshop (or equivalent knowledge)
Upon completion of this workshop, participants will:
Understand Oracle Database architecture in detail
Perform database installations using GUI (DBCA) and command-line tools
Configure Oracle Net Services and manage connectivity
Manage Pluggable Databases (PDBs) effectively
Administer storage structures, tablespaces, and undo segments
Configure and manage user accounts, roles, and profiles
Set up auditing policies, including FGA (Fine Grained Auditing)
Use SQL*Loader, Data Pump, and external tables for data loading/migration
Leverage RMAN and cross-platform data transport capabilities
Monitor and tune systems using Oracle Enterprise Manager
Schedule and manage automated maintenance tasks for high availability
Oracle instance components (SGA, PGA)
Background processes (SMON, PMON, LGWR, DBWR)
Understanding CDB and PDB structures
Memory and process diagrams, introduction to sharding
SQL*Plus, SQL Developer, DBCA, OEM, Cloud Control 13c
Configuration and management interfaces
Selecting templates, setting character sets, silent mode execution
CREATE DATABASE, ENABLE PLUGGABLE DATABASE
Configuring SEED file directories and mappings
STARTUP, SHUTDOWN modes, managing PDB openings, auto start
Initialization parameters (spfile, init.ora)
Alert logs, trace files, V$ dynamic views
Understanding listener components and architecture
Differences between Dedicated and Shared Servers
Easy Connect, Local Naming, Directory Naming
Using DB Services for workload management
Static and dynamic service registration
Modifying listener.ora
Configuration, session handling, performance considerations
CREATE PLUGGABLE DATABASE syntax
Use of FILE_NAME_CONVERT, OMF integration
DBMS_PDB, GoldenGate replication
Remote cloning, unplug/plug methods
Opening/closing PDBs, parameter configuration, PDB removal
Hostname and port assignment per PDB
Segments, extents, blocks, and physical structures
SYSTEM, SYSAUX, USERS tablespaces explained
Permanent and temporary tablespaces
File relocation, renaming, and OMF usage
Compression techniques, shrinking segments
Resumable Space Allocation setup and use
Undo types, UNDO_RETENTION, temporary undo features
Common vs local users, password authentication
OS Authentication and quota management
System vs object privileges
Role-based access control, Oracle default roles
Profile creation, password policies, resource assignments
Unified audit policies, Fine-Grained Auditing (FGA)
Archiving and purging audit records
SQL*Loader, Data Pump, RMAN overview and use cases
Creating control files, using Express mode
Table-level loading examples
PDB-to-PDB transfer via Data Pump
RMAN cross-platform transport, endian format checks
ORACLE_LOADER and ORACLE_DATAPUMP drivers
Task types, maintenance windows explained
Creating schedules, enabling/disabling jobs
Resource allocation configuration
AWR, ADDM, and advisory tools introduction
Wait events, sessions and services monitoring
Gathering statistics and setting thresholds
Optimizer Statistics, SQL Tuning Advisor, Access Advisor
Adaptive Execution Plans in Oracle 23ai
Join our public courses in our Istanbul, London and Ankara facilities. Private class trainings will be organized at the location of your preference, according to your schedule.