Скачать с ютуб OraPub | Oracle Database Memory Serialization Control (latches & mutexes) в хорошем качестве

OraPub | Oracle Database Memory Serialization Control (latches & mutexes)

Oracle Database Memory Serialization Control (latches & mutexes) teaches Oracle DBAs the ends and outs about Oracle memory structure control. Oracle effectively creates the illusion of simultaneous memory structure manipulation. And it's our job to ensure this illusion remains a mystery to our users. To help you keep this illusion real, in this seminar I will lead you into the mysterious world of Oracle memory structure serialization control by exploring latches and mutexes: what they are, how they work, how we monitor their performance, how we tell if there is a significant problem and how we systematically diagnose the situation. I think you will soon understand why I think Oracle serialization control rocks! For details go to http://www.orapub.com/video-seminar-s... PART ONE of this seminar focuses on why latches and mutexes are so important to Oracle's operations and how Oracle uses latches and mutexes in its kernel code. I also dig into how Oracle's time model relates to latching. This enables you to properly diagnosis and communicate to others why or why not latches/mutexes are a significant performance issue. Finally, I get into how Oracle increases concurrency by effectively using multiple latches of the same type to increase memory structure concurrency. It's fascinating and very important for DBAs who want to pursue a career focused on Oracle performance tuning. PART TWO begins by focusing on advanced latch spin control and detailing three ways to identify the problem latch. Then I'll begin digging deep into mutexes, including why they are important, why Oracle began using them and the acquisition algorithm. I'll even get into advanced mutex control using Oracle instance parameters. We will observe Oracle using mutexes by operating system tracing Oracle processes. It's pretty cool and key for any DBA who wants to become a performance expert. What You Will Learn In Part 1 & 2 Why Oracle processes must ensure serial access control to Oracle memory structures What are Oracle latches and mutexes How Oracle latches are different from mutexes The latch and mutex acquisition algorithms How L&M activity relates to Oracle's time model How to monitor for real L&M problems using Oracle's time model and an AWR report Steps to methodically approach diagnosing and coming up with performance solutions The differences between latches and mutexes How Oracle implement mutexes in its library cache How to use advanced latch spin control What options DBAs have to influence mutex behavior L&M = Latches And Mutexes Modules Part 1: 060 Oracle Serialization Control - Part 1 1. Why the simultaneous memory structure illusion must exist and why it works so well 2 Oracle processes, L&M and memory structures, the general L&M acquisition algorithm 3 L&M time accounting and how this relates to the Oracle time model and the AWR report 4. Oracle latch specifics: concurrency limitations, child latches, multiple latches and how latches "back off." Part 2: 062 Oracle Serializatoin Control - Part 2 1. Using latch specific spin count control to your advantage and three ways to identify the problem latch 2. Why mutexes are advantageous to increase concurrency 3. Detailing the Oracle mutex algorithm 4. Advanced mutex control and observering Oracle mutex usage in detail For more information to go www.orapub.com 🔵⚪️🔵⚪️🔵⚪️🔵 OraPub is a one-stop location for specialized training in machine learning and Oracle database performance tuning. Our company is designed to help Oracle professionals get the answers and skills they need through engaging training and useful resources.   We cross-train Oracle DBAs to develop and deploy machine learning for their existing monitoring and alerting systems. Our training and services provide an immediate return on investment.   Our online training is uniquely structured for the working professional. For example, all our LVCs are delivered in multiple two-hour sessions, with a day between each session, complete with homework. Craig Shallahamer encourages dialogue throughout every class to ensure students can immediately apply the course content.   Craig Shallahamer is President and Founder of OraPub, with over 30 years of experience in consulting, training and tool development in analytics (machine learning) and Oracle database performance tuning for literally hundreds of companies around the world, including Oracle Corporation. Craig's passion and contagious energy for teaching Oracle managers, developers and DBAs makes the learning process valuable – and fun!   Craig holds a B.S. in Economics from California Polytechnic State University, San Luis Obispo and is an Oracle ACE Director. For more information visit or to have full access to ALL our webinar content go to www.orapub.com