Oracle 12c database administration Training Course


28 hours (usually 4 days including breaks)


SQL basic knowledge


The training is intended not only for Oracle database administrators  both who are just starting to work with Oracle servers and who are already working on such one and want to learn about the new futures in 12c version. This training can be also useful for programmers who – thanks to the understanding of server architecture and its mechanisms rules – will be able to create effective applications working with the Oracle 12c database.

Course Outline

Oracle architecture overview
   Instance and database
   New instance features in Oracle 12c
   Multitenant architecture
   Container databases
   Pluggable databases

System security, instance and database configuration
    Server access management and database access for SYSDBA role users
    Initialization parameters – binary and text parameter file
    Starting and shutting down the instance
    Opening and closing the database
    Opening and closing of pluggable databases (PDBs) in Oracle 12c
    Status of the instance and databases (container and pluggable ones)
    Profile management

Oracle Net
    Call descriptors
    Network services
    Listener server process
    Oracle Net Manager
    Serve and client configuration for remote connection
Logical storage structure

Database users
    Database architecture
    Schemas and their objects
    Global and local schema in Oracle 12c
    User management in Oracle 12c

Logical database structure

Managing the physical database structure
    Initialization parameters and passwords
    Alert.log file and trace files
    Controlfiles management
    Adding and moving control files
    Redo.log files management
    Mirrorig, adding and moving redo files
    Switching the database mode and the difference between the ARCHIVELOG and NOARCHIVELOG modes
    Archivelog file management
    Mirroring, adding and moving archivelog files
    Data file management and free space on disks
    Moving data files
    Database files in Oracle 12c containers
    Automatic Storage Management architecture

Disk space management
    Problems with free space in tablespaces
    Free disk space management
    Providing space for temporary segments
    Fragmented tablespaces and segments
    Multiple files tablespaces
    Segment advisor
    Undo Advisor
    Use of indexes

Memory structures within instances
    SGA area
    PGA area
    Area of ​​executable code
    Secondary processes
    Dynamic memory management
    ASMM since 10g and AMM since 11g

Creating a database
Differences in the creation of non-PDB and PDB databases
Selecting and updating data (how SQL commands are processed)
Ensuring consistency and concurrency of transactions
Database structure management
    Types of tablespaces
    OFA (Optimal Flexible Architecture) architecture
    System tablesspace
    SYSAUX tablespace
    TEMP tablespace
    UNDO tablespace
    USERS table space
    EXAMPLE table space
    Tablespace management
    Resizing table space
    Segments in tablespaces
    Moving tables to different tablespaces or to the same tablespace vs HighWaterMark vs Indexes

Archiving and database recovery:
    Hot and cold backup
    Backup of datafiles and control files
    Restoring and recovering the database
    RMAN – Recovery Manager
    Backup using the RMAN tool
    Restoring and recovering database using the RMAN tool

Oracle Flashback
    Flashback Query – retrospective queries
    DBMS_FLASHBACK package – moving the session back and forward in time
    FlashbackVersions Query – querying data versions over time
    FlashbackTransaction Query – monitoring of all DML commands in database
    FlashbackTable – moving tables back and forward in time
    Flashback Drop – retrieving dropped tables back
    Flashback Database – moving the database back in time

National language support
Oracle Scheduler and the DBMS_SCHEDULER package
Control system resources

Leave a Reply

Your email address will not be published. Required fields are marked *