Course Code: O12CDBAPT
Duration: 5 days
This Oracle Database 12cR2 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 12cR2 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 12cR2 DBA Performance Tuning & Management course is to provide the skills needed to monitor and tune an Oracle Database.
The Oracle Database 12cR2 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:
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 12cR2 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 12c courses are listed in the Pre-requisite Courses section equivalent Oracle 11g courses would also suffice.
Excellent course, have gained a lot of knowledge and looking forward to trying these out in the production environment.
Benn - Software Engineer - Transport - May 2021
Fantastic level of documentation and the lecturers have great in depth knowledge of the subjects.
Jamie - Database Developer - IT
Not being a dedicated DBA, the course provided an excellent insight into performance tuning available to me.
Dan - Software Developer - Government
Another well delivered course.
Lee - Shared Services Manager - Outsourcing
Very good session and enjoyed the lab / exercise also.
Santanu - SAP Basis DL - IT
Live Virtual Classroom
Our Customers Include
Our Course Curriculum