Course Code: O19CDBAPT
Duration: 5 days
This Oracle Database 19c DBA Performance Tuning & Management course introduces the DBA to the main concepts of Oracle Database performance tuning and management. DBAs will gain practical experience in analyzing and tuning database performance.
Delegates on the Oracle Database 19c DBA Performance Tuning & Management course will learn how to use tuning goals and methodologies to identify tuning contentions in an Oracle database and how to take corrective action, how to detect and tune common database performance problems, how to use the database advisors to proactively tune a database and how to use the various tools provided by Oracle to tune a database.
Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.
Versions supported 12c, 18c, 19c.
The objective of the Oracle Database 19c DBA Performance Tuning & Management course is to provide the skills needed to monitor and tune an Oracle Database.
The Oracle Database 19c DBA Performance Tuning & Management course is suitable for database administrators and technical support staff who are required to monitor and tune an Oracle Database.
The delegate will learn and acquire skills as follows:
This course will aid the delegate in their preparation for the following exam:
Attending this course will help delegates gain many of the skills and product knowledge requirements as outlined in the exam objectives. Studying this course and its associated reference materials can form part of the preparation to achieve certification. Experience, practice, self-study and aptitude are also key requirements for exam success.
Before taking any exam, ensure you have the recommended experience. The Oracle website lists all exam requirements and these are updated regularly.
Exams are not included as part of the course.
Delegates who wish to attend the Oracle Database 12c DBA Performance Tuning & Management course should have practical knowledge of using SQL and of administering an Oracle database. They should have attended the Oracle SQL and the Oracle Database 19c Administration courses or have a good working knowledge of Oracle SQL and Oracle database administration. The ability to describe and use Oracle built-in packages would be highly advantageous but is not essential.
This course is run on a Linux operating system, a basic knowledge of Linux/UNIX is recommended but is not essential.
Where Oracle 19c courses are listed in the Pre-requisite Courses section equivalent Oracle 12c or 18c courses would also suffice.
Live Virtual Classroom
Our Customers Include
Our Course Curriculum