Oracle Database 23ai: Administration Workshop Training in Paris

This comprehensive and advanced-level Oracle Database 23ai: Administration Workshop Training in Paris 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)

1. Introduction to Oracle Database Architecture

• Oracle instance components (SGA, PGA)

• Background processes (SMON, PMON, LGWR, DBWR)

• Understanding CDB and PDB structures

• Memory and process diagrams, introduction to sharding

2. Database Access and Tools

• SQL*Plus, SQL Developer, DBCA, OEM, Cloud Control 13c

• Configuration and management interfaces

3. Database Creation Using DBCA

• Selecting templates, setting character sets, silent mode execution

4. Database Creation Using SQL

• CREATE DATABASE, ENABLE PLUGGABLE DATABASE

• Configuring SEED file directories and mappings

5. Starting and Shutting Down the Database

• STARTUP, SHUTDOWN modes, managing PDB openings, auto start

6. Instance and Parameter Management

• Initialization parameters (spfile, init.ora)

• Alert logs, trace files, V$ dynamic views

7. Oracle Net Services

• Understanding listener components and architecture

• Differences between Dedicated and Shared Servers

8. Naming Methods

• Easy Connect, Local Naming, Directory Naming

• Using DB Services for workload management

9. Configuring the Listener

• Static and dynamic service registration

• Modifying listener.ora

10. Shared Server Architecture

• Configuration, session handling, performance considerations

11. Creating PDBs

• CREATE PLUGGABLE DATABASE syntax

• Use of FILE_NAME_CONVERT, OMF integration

12. Cloning and Migrating PDBs

• DBMS_PDB, GoldenGate replication

• Remote cloning, unplug/plug methods

13. Managing PDBs

• Opening/closing PDBs, parameter configuration, PDB removal

• Hostname and port assignment per PDB

14. Database Storage Architecture

• Segments, extents, blocks, and physical structures

• SYSTEM, SYSAUX, USERS tablespaces explained

15. Tablespace Creation and Management

• Permanent and temporary tablespaces

• File relocation, renaming, and OMF usage

16. Storage Optimization

• Compression techniques, shrinking segments

• Resumable Space Allocation setup and use

17. Undo Management

• Undo types, UNDO_RETENTION, temporary undo features

18. User Account Management

• Common vs local users, password authentication

• OS Authentication and quota management

19. Privileges and Roles

• System vs object privileges

• Role-based access control, Oracle default roles

20. Resource Limits (Profiles)

• Profile creation, password policies, resource assignments

21. Oracle Audit Configuration

• Unified audit policies, Fine-Grained Auditing (FGA)

• Archiving and purging audit records

22. Introduction to Data Transfer

• SQL*Loader, Data Pump, RMAN overview and use cases

23. Data Loading Techniques

• Creating control files, using Express mode

• Table-level loading examples

24. Data Transport Methods

• PDB-to-PDB transfer via Data Pump

• RMAN cross-platform transport, endian format checks

25. Loading with External Tables

• ORACLE_LOADER and ORACLE_DATAPUMP drivers

26. Introduction to Automated Maintenance

• Task types, maintenance windows explained

27. Managing Automated Tasks

• Creating schedules, enabling/disabling jobs

• Resource allocation configuration

28. Fundamentals of Performance Monitoring

• AWR, ADDM, and advisory tools introduction

29. Advanced Performance Tracking

• Wait events, sessions and services monitoring

• Gathering statistics and setting thresholds

30. SQL Analysis and Access Path Optimization

• Optimizer Statistics, SQL Tuning Advisor, Access Advisor

• Adaptive Execution Plans in Oracle 23ai