DB Viscosity Training PART 3: ORACLE DATABASE PERFORMANCE TUNING
| Calendar: |
ODTUG Events Calendar |
| Type: |
Public |
| Title: |
DB Viscosity Training PART 3: ORACLE DATABASE PERFORMANCE TUNING |
| Group: |
ODTUG Members |
| Owner: |
Karen Cannell [TH Technology] |
| Start: |
Mar 11, 2021 12:00 PM America/Eastern |
| End: |
Mar 11, 2021 02:30 PM America/Eastern |
| Description: |
Presented by Oracle ACE Associate Gary Gordhamer and Ron Mehrer, Viscosity North America
Registration is limited to 30 hands-on lab students, but unlimited to those interested in viewing the presentation only. The first 30 to register for the hands-on lab will receive lab credentials the day before the session via email.
Overview
Oracle Database upgrades often lead to performance related issues. This is due to the number of underlying technical changes in software, introduction of new features, and general enhancement of the products. With many 19c upgrades going on, it’s good to know how to use the many technical features in Oracle for dealing with or even eliminating performance issue. In this lab we will go through some of the basic skills that every DBA should have around performance tuning from enhance explain plans and gathering statistics to using SQL Plan Management. We will also cover the differences between SQL Baselines and SQL profiles. This session should be good if you are an experienced DBA just brushing up on your skills, or new to using Oracle database performance tuning tools.
Two hour course: A virtual presentation will be followed by the hands-on practicum on SQL tuning. Attendees will have access to a virtual machine with Oracle database pre-installed.
Outline
1. 19c upgrade – be prepared!
- MOS Reading
- Profiles vs Baselines
2. SQL Explain Plan
- Normal
- Plan statistics
- Monitor
- Finding your statements
3. Object Statistics
- Automated jobs
- Checking object staleness
4. SQL Plan Management (SPM)
- SPM finding performance regression
5. SQL plan baselines
- Create a baseline
- Finding invalid baselines
- Changing a baseline
6. SQL Patch
- Grabbing a SQL profile
- Adding a patch (hint)
7. SQL Profile
- Generated by SQL tuning advisor
- Transport to another DB
|
| Link: |
https://attendee.gotowebinar.com/register/7995479644858088976?source=odtug |
|
