Oracle 19C Database Tuning is an intermediate level course for Oracle database experienced attendees that explores core tuning skills such as Database parameters, SQL Tuning Advisor, SQL Access Advisor, Adaptive SQL plans and more.
Our engaging instructors and mentors are highly-experienced practitioners who bring years of current "on-the-job" experience into every classroom. Working within in a hands-on learning environment, guided by our expert team, attendees will explore:
- Overview Oracle Database Architecture
- Query Optimizer
- Tuning Container Databases and Pluggable Databases
- Oracle 12c Tuning features
- Evaluating Execution Plans
- Oracle Tuning Tools
- Using Automatic Workload Repository
- Join Types
- AWR Using Baselines
- Additional AWR performance tools
- Optimizer Statistics
- Monitoring a Service
- Bind Variables and database parameters
- Oracle's Real Application Testing (RAT)
- SQL Tuning Advisor
- Automatic Sql Tuning
- Sql Plan Management
- Shared Pool Tuning
- Tuning the database buffer cache
- Tuning the PGA (Program Global Area)
- Automatic Memory Management (AMM)
- Tuning Segment Space Utilization (ASSM)
- Automatic Storage Management
Need different skills or topics? If your team requires different topics or tools, additional skills or custom approach, this course may be further adjusted to accommodate. We offer additional Oracle, database, scripting, administration and other related topics that may be blended with this course for a track that best suits your needs.
This intermediate-level course requires students have incoming experience working with Oracle Database 18 or higher.
Please see the Related Courses tab for specific Pre-Requisite courses, Related Courses that offer similar skills or topics, and next-step Learning Path recommendations.
Student Materials: Each participant will receive a Student Guide with course notes, code samples, software tutorials, step-by-step written lab instructions, diagrams and related reference materials and resource links. Students will also receive the project files (or code, if applicable) and solutions required for the hands-on work.
Setup Made Simple. All course labs and solutions, data sets, Oracle software (limited version, for course use only), detailed courseware, lab guides and resources (as applicable) are provided for attendees in our easy access, no installation required, remote lab environment for the duration of the course. Our tech team will help set up, test and verify lab access for each attendee prior to the course start date, ensuring a smooth start to class and successful hands-on course experience for all participants.