The Ultimate SQL Tuning Formula
The Ultimate SQL Tuning Formula
Do you want to be an exceptional Oracle DBA? Do you want to be the DBA everyone calls when a performance problem in the database occurs?
Do you want to be the Hero of the Day, as you were the ONE who made the report run faster?
Are you afraid of performance problems in the database? Do you feel that you have no idea where to start?
Do you feel that you read and studied lots of tuning books and articles, and still it is not clear in you mind what steps to take to improve the database performance?
Do you feel lost and overwhelmed when someone is asking for your help in troubleshooting performance problems?
Are you just out of DBA school or with a few years of DBA experience, and you want to improve your tuning skills?
If you answered YES to any of these questions, than this course is definitely for you!
You don't need to spend tens and tens of hours studying and reading books on performance and tuning.
This course puts it all together for you in the minimum time required to learn all you need to know about Oracle performance and tuning.
The course comes with 6 compact modules, and tons of bonuses: mind maps, scripts, and course slides. All the knowledge you are getting, can be applied right away on the job.
The scripts included in the course, are the exact same scripts I use, day to day on my job, to troubleshoot and fix performance problems.
If you are curious to see what is there in each module, keep reading further!
Module 1: The Foundation: All You Need To Know About Oracle Memory Components To Be An Awesome DBA
In this module you will:
Understand the ins and outs of the Oracle Memory
Work with the SGA (System Global Area)
Work with the PGA (Program Global Area)
Learn detailed information about each memory component
Learn all that you need to know about memory management
Module 2: All About Cursors And Why Are They Important
In this module you will:
Learn what cursors are and why you need them
Learn the 7 stages of the cursor aka cursor life-cycle
Learn everything about bind variables and literals
Module 3: How To Be The Hero Of The Day: Finding SQL Statements and Execution Plans
In this module you will:
Learn the ins and outs of execution plans
Learn the 6 ways to get the execution plan of a SQL statement
How to navigate an execution plan without a compass
Learn to finding inefficient execution plans
Module 4: Optimizer Stats The Secret Weapon Of The DBA
In this module you will:
Learn to Navigate statistics without getting lost
Learn how stats are gathered and how to configure statistics preferences
Learn all about histograms
Module 5: Getting Information From AWR
In this module you will:
Learn how to become a master of the AWR repository, working with snapshots, reports, baselines
Learn how to read and interpret the AWR report
Learn about the Active Session History and ADDM
Module 6: Step By Step Tuning Techniques, so you always know what you need to do.
In this module you will:
Learn the Seven Questions to ask when troubleshooting any performance problems
Learn how to find the answer to these questions - aka step by step plan to solve performance problem
Get Troubleshooting steps
Learn 6 ways to tune a query
Learn about SQL profiles - how to use them (everything about profiles)
Learn about moving SQL profiles from one database to another - 2 methods
Learn to use SQL Baselines
Learn the building blocks of the SQL Plan Management
Still not convinced? Why don't you give it a try, you have nothing to lose with the 30 Day Money Back Guaranteed!
The Complete, Proven, Step by Step System to Find, Troubleshoot and Fix Performance Problems in Your Oracle Database
Url: View Details
What you will learn
- Students will be able to troubleshoot performance problems
- Students will have a good understanding of the Oracle optimizer, why it does what it does, and how it works.
- Students will be able to find the bad SQL statement
Rating: 3.85
Level: All Levels
Duration: 4 hours
Instructor: Diana Robete
Courses By: 0-9 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
About US
The display of third-party trademarks and trade names on this site does not necessarily indicate any affiliation or endorsement of hugecourses.com.
View Sitemap