Toad for Oracle DBAs - Performance Management - Free
-
Description
This self-paced, web-based training course is available for FREE to all users. This course is based on Toad for Oracle 12.5 or later. If you have an older release of Toad for Oracle, please visit our Support portal to upgrade. If you have any questions, please contact your local Sales Representative for further details contact us
This course is for Oracle DBAs who needs to learn how to best leverage the Toad DBA Suite for Oracle to diagnose and resolve database performance issues, determine where the performance bottlenecks are, and how to resolve poorly performing SQL and PL/SQL queries.
There is a test that correlates to the course. This test is just a knowledge check of what you have learned.
Click Here to launch the test.
NOTE: The certificate of completion is currently NOT available at this point.
-
Duration: 2-3 hrs
-
Audience
Oracle DBAs managing Oracle instances and Real Application Cluster (RAC) environments -
Prerequisites
A good working knowledge of Toad for Oracle or the completion of the Toad for Oracle Fundamentals course is necessary. A solid understanding of Oracle database administration tasks is necessary.
Browser Requirements:
The courseware has been tested to run on the following browsers:
- Google Chrome v32 or higher
- FireFox 26 or higher
- Internet Explorer 9 or higherEnable automatic popups and adding the following sites to the exceptions list:
*.quest.com
*.software.quest.comhttps://www.wikihow.tech/Add-a-Website-to-Trusted-Sites
Re-launch browser
If the course or simulations within the course do not work, try to launch the course using a different web browser.
-
Objectives
This course will cover how to:
- Diagnose performance bottlenecks in your database environments (standalone, RAC and Exadata systems) caused by SQL workloads, database activity, I/O rates, and Configuration and Memory
- Predict future SQL bottlenecks
- Tune the poorly performing SQL statements
-
Topics
Introduction
- Overview of the Toad DBA Suite for Oracle Performance Management Features
- Navigating the course
Spotlight
- Configuration of Spotlight™ on Oracle
- Explore various Spotlight launch points
- Configuration of Spotlight alarms and views
- Use Spotlight to view Database Activity, I/O, and Configuration and Memory
- Using and understanding Predictive Analysis
- Capture and visualize database transactions in an Oracle Trace file
- Hands-on practice simulation to learn how to use and understand Spotlight on Oracle
- Spotlight on RAC
SQL Optimizer
- Identifying PL/SQL Code bottlenecks
- Identifying all code bottlenecks
- Understanding the various modes and features of the SQL Optimizer (single, batch optimization, plan baselines)
- Evaluate the impact of database changes on SQL performance (database configuration, indexing, compare)
- Assess indexing opportunities based on actual database workload
-
Format
Students complete this course through self-paced web-based training. The course presents product functionality and provides the participant the opportunity for hands-on practice resolving real-world problems through use case driven simulations. Each lesson contains closing questions allowing for a knowledge check. The lessons in the course build on each other and each new lesson allows the participant the opportunity to reinforce what they have learned in previous lessons. There is a test that correlates to the course. Upon passing this test, the participant has the opportunity to achieve a Toad for Oracle Advanced DBA Certificate of Completion.
-
Special Notes
This self-paced, web-based training course is available for FREE to all Toad World registered users. Upgrading your current Toad version to 12.5 or higher will entitle you to this offer. Please contact your local Sales Representative for further details contact us
