• Available 24/7 • Short modules for ease in watching • Unlimited viewing •
Oracle DBA tuning learning paths help you set and achieve your goals.
Members benefit from assessments and certificates.
Oracle Incident Analysis Using ASH Data
Seminar Duration: 1h 59m • Transformative
If you have hit the wall trying to solving certain performance problems using an AWR report, then this seminar is for you! In this seminar, Craig will lead you through the entire ASH analysis process from start to finish... twice. And he will even show you how to create a visualization of the situation using the free statistics package R. If you want to learn how to use ASH to solve random short-lived performance incidents, you will find this seminar incredibly valuable... your diagnostic edge.
How To Choose Your Best Oracle Performance Analysis Strategy
Seminar Duration: 2h 12m • Foundational
It’s an unhappy user. What is your best strategy? As Oracle DBAs we have two fundamental performance analysis strategies: time based and sample based (ASH). Knowing their differences and how to exploit them gives you the edge. In this seminar, Craig introduces each strategy, highlights how they work and contrasts their differences. Then he will demonstrate each strategy ending with three situational videos and YOU choose the best strategy. It's easy... once you have seen this seminar!
Let’s Build Something! Building Your Own ASH Toolkit
Seminar Duration: 1h 28m • Foundational
Let's build something! ASH provides Oracle DBAs with an amazing set of performance data. In this video seminar Craig will show you how to build three highly flexible ASH-based scripts: summary, top anything and session time-line. Throughout the seminar Craig explains and demonstrates scripts on a real Oracle workload. Whether you use these scripts or not, you will have a very deep understanding about ASH and how to effectively use it.
Understanding And Resolving Oracle Cache Buffer Chain Wait/Latch Contention
Seminar Duration: 1h 38m • Foundational
When a server process needs to access a buffer, it must access the cache buffer chain (CBC) structure to determine if the buffer is already in the buffer cache. With just the right workload mix, performance can be a problem. Learning about the relevant Oracle internals and how to diagnose and solve CBC performance problems is what this seminar is all about.
How To Start Blogging To Propel Your Career
Seminar Duration: 1h 14m • Transformative
The decision to blog or not to blog is one of your most important career decisions. A successful blog will propel your career wherever you want it to go. An unsuccessful blog will become a colossal waste of your time. So if you're going to blog, it's important to do it right. But what is "right" for Craig, may not be "right" for you. How do you make the right decision and then be successful doing it? That's the focus of this video seminar.
Understanding And Resolving Oracle Free Buffer Wait Contention
Seminar Duration: 1h 46m • Foundational
Free buffer waits is one of the most feared of all Oracle wait events. It requires just the right workload mix and configuration to appear. When it does appear, it affects the entire application. So, how do you quickly improve performance with a clear understanding of the situation? That's the focus of this video seminar.
Tuning Oracle Using An AWR Report
Seminar Duration: 2h 19m • Foundational
Tuning Oracle Using An AWR Report teaches Oracle DBAs how to make Oracle database systems fast using an AWR or Statspack report. Craig will lead you through the entire process turning you into a respected performance analyst. No more flipping through an entire AWR report top-to-bottom desperately searching for answers! You will learn how to develop solutions that are spot-on and everyone will know it. You will know what to do, do it fast, and be able to explain the situation with clarity and confidence.
To Queue Or Not To Queue, That Is The Question
Seminar Duration: 1h 41m • Transformative
To Queue Or Not To Queue, That Is The Question will help you tune Oracle systems faster and with a greater depth of understanding. The insights you gain provide both a tactical and strategic performance tuning advantage. Queuing theory can be... theoretical! But, Oracle ACE Director, Craig Shallahamer, turns this topic upside down making it a fantastic learning experience.
Identifying High Risk SQL Before The Upgrade
Seminar Duration: 0h 57m • Inventive
Everyone knows identifying the high risk Oracle database SQL AFTER the upgrade is easy. But before the upgrade? That's difficult. You need to be Identifying High Risk SQL Before The Upgrade. Comparing SQL elapsed times is simply not good enough. In this seminar Craig aggressively deals with these complex issues.
Creative Oracle Redo Maneuvers
Seminar Duration: 1h 26m • Inventive
Creative Oracle Redo Maneuvers teaches you how to push Oracle redo throughput to the absolute limit! There are a number of unusual and powerful maneuvers Oracle DBAs can do to reduce commit times, reduce log file sync and log file parallel write wait times. In a nutshell, you will be able to improve performance when the system is bogged down with redo related issues.
Oracle Database Memory Serialization Control (Latches & Mutexes)
Seminar Duration: 1h 48m • Foundational
Oracle Database Memory Serialization Control (Latches & Mutexes) teaches Oracle DBAs the ins and outs about Oracle memory structure control. Oracle effectively creates the illusion of simultaneous memory structure manipulation. It's our job to ensure this illusion remains a mystery to our users. We know we are successful when our users just know it works!
Detailing Oracle CPU Consumption: The Missing Link
Seminar Duration: 1h 06m • Inventive
Detailing Oracle CPU Consumption: The Missing Link helps Oracle DBAs answer this question, "What's Oracle doing with all that CPU?" In this seminar you will learn how to determine where Oracle is consuming CPU down to the Oracle kernel code function level and how this relates to the broader performance situation.
Utilization On Steroids
Seminar Duration: 1h 05m • Foundational
Utilization On Steroids is a fast-paced, one-hour video seminar for busy Oracle DBAs and developers. It has taken Craig 20+ years to truly understand utilization, and he is now sharing it with you! You will learn in one hour what took Craig years to create. This nine-module seminar makes you better at Oracle database performance tuning by digging deep into the realm of utilization.
Using Skewed Performance Data To Your Advantage
Seminar Duration: 1h 09m • Transformative
Every Oracle DBA has experienced the effects of skewed performance data, but most don't know how to use that knowledge to their advantage. Has your IO administrator said the IO response time is fine, but you know single block IOs are taking around 25ms? That's just one skewed performance data example. You will learn how to avoid, recognize and use skewed Oracle wait times and SQL elapsed times. Craig will teach you how to gather the appropriate data, understand the data and visually demonstrate the situation.