Description: SQL is at the heart of any relational database management system, and optimizing SQL typically provides the largest performance gains in real-world situations. This course will discuss the Cost-Based Optimizer, which is key in determining the execution path of a SQL statement. You will also learn how to optimize the retrieval of data. This course is one of a series in the SkillSoft learning path that covers the objectives for the Oracle Database 12c: Performance Management and Tuning exam (1ZO-064).
Target Audience: Database Administrators, Application Developers, Technical Consultants.
Duration: 01:43
Description: Oracle Database 12C includes services that organize work execution within the database, and make execution that much more manageable, measurable, tunable, and recoverable. This course covers these services as well as the basic phases of SQL processing, and ways to extract detailed information about the actual execution of a SQL statement. This course is one of a series in the SkillSoft learning path that cover the objectives for the Oracle Database 12c: Performance Management and Tuning exam (1ZO-064).
Target Audience: Database Administrators, Application Developers, Technical Consultants
Duration: 01:25
Description: Metrics are used for system health monitoring, problem detection, and self tuning in Oracle Database 12c. In this course, you will see how performance baselines can be established, so that it is simpler to deduce whether there has been any performance degradation. Finally, real-time database operation monitoring is introduced, which extends and generalizes real-time SQL monitoring. This course is one of a series in the SkillSoft learning path that cover the objectives for the Oracle Database 12c: Performance Management and Tuning exam (1ZO-064).
Target Audience: Database Administrators, Application Developers, Technical Consultants
Duration: 00:54
Description: This course introduces the Automatic Workload Repository, which is the infrastructure that provides services to Oracle Database components to collect, maintain, and use statistics for problem detection and self-tuning purposes. The Automatic Database Diagnostic Monitor is also discussed, and we will see how Active Session History can assist in more granular problem solving situations. This course is one of a series in the SkillSoft learning path that cover the objectives for the Oracle Database 12c: Performance Management and Tuning exam (1ZO-064).
Target Audience: Database Administrators, Application Developers, Technical Consultants and learners looking to obtain the Oracle Database 12c: Performance Management and Tuning certification.
Duration: 01:10
Description: The Oracle RDBMS engine has been around for many years, and over the course of its existence, there have been many methodologies in how to go about troubleshooting performance problems. This course will provide a modern-day approach on how to confront these types of challenges, with particular attention to making use of features available in the 12c version of the database. This course is one of a series in the SkillSoft learning path that cover the objectives for the Oracle Database 12c: Performance Management and Tuning exam (1ZO-064).
Target Audience: Database Administrators, Application Developers, Technical Consultants and learners looking to obtain the Oracle Database 12c: Performance Management and Tuning certification.
Duration: 01:10