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:
- Understand what an SQL execution plan is
- Understand how the Optimizer builds execution plans
- Know why SQL execution plans change
- Use Oracle instrumentation to identify poor performing SQL
- Read an execution plan and what influences the steps
- See how SQL Plan Management (SPM) works
- Know what a SQL Profile is and how it works
- Understand the difference between temporary and permanent fixes for SQL performance issues
Class Pricing:
- $375 USD for Free members
- $300 USD for Essential & Advantage members (ask for your coupon code)
- FREE for Prime members (just ask to be registered)
Class Outline:
Session 1.
- Oracle Optimizer basics
- Identifying poor performing SQL (ASH/Live Monitor/v$sql)
- Execution plan high level analysis
- Implementing a temporary fix
- 30 minute lab
Session 2.
- Review
- Oracle SQL Plan Management (SPM)
- Oracle SQL Profiles & SQL Tuning Advisor
- Q & A
- 30 minute lab
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:
- An up-to-date modern browser such as Google Chrome, Microsoft Edge, Mozilla Firefox or Apple's Safari.
- The ability to connect to the online training over the internet, hosted by Zoom. You do not need a microphone.
Welcome OraPub Members!
Enter the member portal and be ready to be transformed in your Oracle DBA work.
© Copyrights by OraPub. All Rights Reserved.