Participants will learn about the structure of the Oracle server, principles of instance architecture and data organization in databases. Knowledge includes the issues of the impact of database storage structures, schemas and server configuration to its proper work. The participant will gain knowledge of safety rules in the databases and the practical ability to configure access management and Oracle Network Environment configuration.
After completing the course, participants will know how to:
This course is for database administrators.
The training can be useful also for developers implementing databases and database applications who – by understanding the principles of operation of the server – will be able to better use its potential.
The training is carried out in the form of theoretical part in the form of mini lectures and the practical part in the form of computer exercises.
4 days, 32 training hours
Oracle Server Architecture Overview
Databases and instances
New features in Oracle 19c instance architecture
Multitenant Architecture
Container databases
Pluggable databases
The differences in the container management in the Enterprise and Standard editions
Logical storage structure
Database users
Logical database structure
The physical data storage structure
Instance memory structures
Starting and Closing instance
Creating a database
Initialization parameters
Selecting and updating data (how SQL commands are processed)
Dynamic memory management of the SGA
Ensuring consistency and concurrency transactions
Managing database structure
Tablespaces
Managing the physical structure of the database
Storage Space management
Rollback
Oracle Flashback
National language support
Oracle Scheduler and DBMS_SCHEDULER package
Oracle Net
Distributed Databases
System resources control and management
Database users support
Security system
Monitoring