Oracle 19c Administration

This Oracle Database 19c Administration course is designed to give the Oracle database administrator practical experience in administering, monitoring, tuning and troubleshooting an Oracle database.

 A database administrator will gain an understanding of the architecture and processes of the Oracle database server.

Delegates will learn how to ensure the integrity and availability of data and will also learn how to monitor the performance of a database, allocate resources with the Resource Manager and schedule jobs with the Oracle Job scheduler.

Delegate Will Practice:

• Administering an Oracle Database Instance
• Monitoring an Oracle Database
• Configuring the Oracle Network Environment
• Creating and Managing Database Storage Structures
• Managing Users, Profiles, Privileges and Roles
• Managing Undo Data and Temporary Segments
• Monitoring and Resolving Lock Conflicts
• Maintaining Database Security
• Implementing Database Auditing
• Monitoring the Performance of the Database
• Loading and Unloading Data
• Using the Job Scheduler
• Configuring a Database for Backup and Recovery