Oracle SQL Tuning Quick Fixes
Learn the Oracle tools to resolve your SQL issues!
* New dates coming soon *
8:00-10:30AM Pacific
$375.00 USD (discounts for paid members)
Why should I attend this class?
Firefighting SQL performance issues
When a SQL statement starts performing poorly you need to be ready to act. We will highlight the steps to take when this happens, starting with identifying poor performing SQL and what your options are for a quick fix of the issue.
Understand the issues and how to communicate them
We will cover how the Oracle Optimizer works to determine the SQL execution plan. This is critical to understanding what might be going wrong with a specific SQL statement and how we can use specific tools to help. This knowledge will give you the ability to communicate clearly to management about why issues occurred and what was done for the temporary fix.
Practice before you run into the fire
Maybe you have not used SQL Plan Management (baselines) or SQL profiles and would like to be ready to use these tools. Perhaps you have used them but don’t really understand why they work, or why they stop working. We will explore, in detail, how these tools can help, why they may not help and what your alternatives are.
Mysterious SQL statement behavior
Have you ever had a situation where a SQL statement that was running fine suddenly goes bad? What can you do? In this class we will focus on how to identify poorly performing SQL, and what some of the tools are in Oracle to immediately resolve the issue.
You will be able to:
Class Pricing:
Class Outline:
Session 1.
Session 2.
Details:
Class Hours: There are 4 hours of live, interactive hands-on class training divided into two 2-hour sessions, plus one hour of lab time.
Skill Level: You will need a basic understanding of SQL and Oracle database.
Class Structure: OraPub believes you learn more when you freely and actively engage during the training. This is why each session is full of live demonstrations, lots of Q&A time and lots of hands-on action! If you miss a session, you are free to attend that session when the class is offered again.
Watching Recorded Sessions: Each session is recorded and used to create a unique web page just for your class. The recordings can be streamed using any device, but not downloaded. You can re-watch the videos as many times as you wish. The videos and your unique class web page will be available for three years!
Class Requirements:
You will need:
Welcome OraPub Members!
Enter the member portal and be ready to be transformed in your Oracle DBA work.
© Copyrights by OraPub. All Rights Reserved.