Oracle Database 12c: Performance Management and Tuning: 1Z0-064: Oracle Database 12c: Performance Management and Tuning
- 16 Courses | 10h 26m 1s
- 3 Books | 35h 9m
Explore performance analysis and tuning tasks as you prepare for the Oracle Database 12c: Performance Management and Tuning certification.
COURSES INCLUDED
Introduction to Performance Tuning
There are many methodologies for troubleshooting performance problems in Oracle Database 12c. Learn about performance management techniques, including tuning goals and objectives, and working with waits, events, classes, and statistics.
15 videos |
29m
Assessment
Badge
Implementing Performance Tuning
Oracle Enterprise Manager gives you a central area for managing Oracle tools. Learn about OEM architecture and pages, as well as using alerts in tuning, user trace files, common tuning problems, and service requests.
11 videos |
28m
Assessment
Badge
Automatic Workload Repository
The Automatic Workload Repository provides services to database components to collect, maintain, and use statistics for issue detection and self-tuning. Explore AWR in Oracle Database 12c, including administration and reporting.
9 videos |
25m
Assessment
Badge
ADDM & ASH
The Automatic Database Diagnostic Monitor allows you to analyze AWR data for performance problems. Active Session History can assist in more granular problem solving situations. Learn about using these two tools in Oracle Database 12c.
14 videos |
38m
Assessment
Badge
Metrics & Monitoring
Metrics are used for system health monitoring, problem detection, and self tuning in Oracle Database 12c. Explore how to establish and manage performance baselines and work with real-time SQL monitoring.
18 videos |
47m
Assessment
Badge
Application Monitoring
Oracle Database 12C includes services that organize work execution within the database, and make execution that much more manageable, measurable, tunable, and recoverable. Learn about working with and scheduling these services.
10 videos |
27m
Assessment
Badge
SQL Diagnostics
Increase your performance tuning knowledge by learning the basic phases of SQL processing and ways to extract detailed information about the actual execution of a SQL statement in Oracle Database 12c.
13 videos |
47m
Assessment
Badge
Tuning Problem SQL Statements
SQL is at the heart of any relational database management system, and optimizing SQL typically provides the largest performance gains in real-world situations. Explore the Cost-Based Optimizer and optimizing data retrieval.
13 videos |
48m
Assessment
Badge
Performance, Migration, & Compression
Better tune your Oracle 12c database by understanding index maintenance, extent management, database blocks, Automatic Segment Space Management, migration and chaining, and data compression.
14 videos |
47m
Assessment
Badge
Measuring SQL Performance
Once poorly performing SQL is identified and changes are proposed, you need to ensure that they will yield the desired effect. Discover how tools such as the SQL Performance Analyzer and SQL Tuning Advisor can be used to achieve this goal.
17 videos |
1h 8m
Assessment
Badge
Maintaining SQL Performance
Database Replay can help with performance tuning by allowing you to capture a workload and replay it on a test system to see the effect of changes outside of the production database. Learn about Database Replay in Oracle Database 12c.
8 videos |
25m
Assessment
Badge
Tuning Instance Memory
When performance tuning in Oracle Database 12c, it's vital to include the System Global Area in your efforts. Explore SGA tuning, including using AWR reports, adaptive cursor sharing, and the SQL query result cache.
11 videos |
50m
Assessment
Badge
Memory Tuning Techniques
The SGA a key component to the effective working of the Oracle database engine. Learn about SGA tuning, including tuning the buffer cache and I/O.
11 videos |
45m
Assessment
Badge
SQL Memory Usage Tuning
The SGA is a key component to the effective working of the Oracle database engine. Explore SQL memory usage, the PGA and its role in sort operations, and temporary tablespaces.
6 videos |
23m
Assessment
Badge
Performance Tuning Summary
To fully tune your database, you need a solid understanding of manipulating SGA components and Automatic Memory Management Maintenance. Learn about these Oracle Database 12c concepts.
7 videos |
30m
Badge
Performance Tuning Methodology
Broaden your knowledge of Oracle Database 12c performance tuning by examining a series of commonly occurring real-world performance problems and the typical solutions for those scenarios.
11 videos |
43m
Assessment
Badge
SHOW MORE
FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THESE COURSES
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.BOOKS INCLUDED
Book
Oracle Database 12c Performance Tuning Recipes: A Problem-Solution ApproachProviding proven solutions to real-life Oracle performance problems with relevant background and theory to support each solution, this resource is a ready reference for database administrators in need of immediate help with performance issues relating to Oracle Database.
11h
By Bill Padfield, Darl Kuhn, Sam R. Alapati
Book
Expert Oracle Indexing and Access Paths: Maximum Performance for Your Database, Second EditionExplaining how indexes help performance, and sometimes hinder it too, this concise book demystifies the various index choices so that you can choose rightly and describes the database administration chores associated with indexes.
4h 51m
By Bill Padfield, Darl Kuhn, Sam R. Alapati
Book
Oracle Database 12c Release 2 Performance Tuning Tips and TechniquesFilled with real-world case studies and best practices, this essential resource details the latest monitoring, troubleshooting, and optimization methods and includes coverage on testing, reporting, and security enhancements.
19h 18m
By Richard J. Niemiec
