Home
Search results “Shared pool latches oracle”
SCPT 15: Oracle Shared Pool
 
17:01
Oracle DBA Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 29181 Oresoft LWC
Shared Pool Tuning
 
11:20
Shared Pool Tuning watch more videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjab, Tutorials Point India Private Limited
02 05 Shared Pool
 
02:14
ORACLE
Views: 246 oracle ocm
SCPT 41: Types of Locks and Latches in Oracle
 
07:11
Oracle DBA Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 20000 Oresoft LWC
Can you really flush Oracle SHARED POOL
 
11:21
This video will explain what happens in reality when you issue ALTER SYSTEM FLUSH SHARED_POOL. A step by step case study will give you the answers by the end of this video session. Oracle DBA training: Need some training on Performance tuning? - Whatsapp +919951696808 Look for more contents on training at: www.orskl.com/training
Views: 2510 OrSkl Academy
Oracle Database Memory Serialization Control (latches & mutexes)
 
14:14
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-serialization-control 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
Views: 2434 OraPub, Inc.
Understanding And Resolving Oracle CBC Wait/Latch Contention - Introduction
 
07:10
Understanding And Resolving Oracle CBC Wait/Latch Contention 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. For more information go to www.orapub.com
Views: 776 OraPub, Inc.
Real-World Performance - 13 - Large Dynamic Connection Pools - Part 1
 
14:23
Check out the entire series on the Oracle Learning Library at http://www.oracle.com/goto/oll/rwp In this video, listen and watch Andrew Holdsworth, Vice President of Oracle Database Real-World Performance at Oracle Corporation, as he demonstrates how large dynamic connection pools affect performance. Copyright © 2014 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the "Materials"). The Materials are provided "as is" without any warranty of any kind, either express or implied, including without limitation warranties of merchantability, fitness for a particular purpose, and non-infringement.
Real-World Performance - 14 - Large Dynamic Connection Pools - Part 2
 
07:07
Check out the entire series on the Oracle Learning Library at http://www.oracle.com/goto/oll/rwp In this video, listen and watch Andrew Holdsworth, Vice President of Oracle Database Real-World Performance at Oracle Corporation, as he explains how large dynamic connection pools affect performance. Copyright © 2014 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the "Materials"). The Materials are provided "as is" without any warranty of any kind, either express or implied, including without limitation warranties of merchantability, fitness for a particular purpose, and non-infringement.
SCPT 45: Common Performance Issues in Redo Log
 
19:09
Oracle DBA Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 13061 Oresoft LWC
What are Latches
 
06:47
Latch Overview
Views: 3712 Mike
Shared Pool
 
07:33
Oracle Database 11g - Deep dive into Shared Pool
Views: 65 suraj verma
SCPT 47: Oracle Storage Parameters: PCTFREE and PCTUSED
 
09:16
Oracle DBA Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 21354 Oresoft LWC
Oracle Performance - Configure Instance Caging
 
02:32
Oracle Performance - Configure Instance Caging
Views: 213 The Silent DBA
SCPT 16: Oracle Java Pool, Large Pool, Streams Pool
 
12:19
Oracle DBA Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 18322 Oresoft LWC
Troubleshooting a Complex Oracle Performance Issue
 
01:28:00
In this session Tanel will walk you through troubleshooting a yet another complex performance issue that he has faced in past. Again, the initial symptoms point to a different direction than the actual root cause, so a systematic approach was needed.
Views: 2329 Tanel Poder
SCPT 12: Oracle System Global Area
 
14:34
Oracle DBA Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 30290 Oresoft LWC
5. Структуры памяти Oracle
 
13:34
1. SGA 2. PGA 3. Shared Pool: library cache, data dictionary cache 4. Buffer Cache: db_cache_size, db_keep_cache_size, db_recycle_cache_size 5. Redo Log Buffer Cache 6. Large Pool 7. Java Pool Oracle Database, БД Oracle, вебинар Oracle, презентация Oracle, урок Oracle, лекция Oracle, обучение Oracle
How to CAUSE Oracle free buffer waits
 
06:33
This is a snippet from my online video seminar, Understanding And Resolving Oracle Free Buffer Wait Contention. Check it out here: http://www.orapub.com/video-seminar-understanding-eliminating-oracle-free-buffer-waits
Views: 952 OraPub, Inc.
SCPT 17: Tools to Manage Oracle's Memory Structure
 
11:54
Oracle DBA Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 15898 Oresoft LWC
SCPT 11: Process Global Area and User Global Area
 
16:09
Oracle DBA Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews
Views: 33512 Oresoft LWC
Lock Manager
 
03:21
Locks are placed on certain objects in Savance Enterprise to prevent multiple users from editing at the same time. This training video covers how these locks are managed.
Views: 213 SavanceEnterprise
SCPT 36:What is Locking
 
12:34
Oracle DBA Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 29224 Oresoft LWC
Oracle database locking issue
 
03:17
Analyzing locks with d.side - Automatic diagnostic for Oracle databases performance and troubleshooting http://www.dside-software.com Copyright (c) d.side software
Views: 243 D.SIDE SOFTWARE
SCPT 14: Oracle Block Buffer Cache
 
24:35
Oracle DBA Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 29943 Oresoft LWC
DB2 for z/OS Best Practice: DB2 for z/OS Data Sharing Tuning Group Buffer Pools
 
44:15
In a data sharing environment, tuning Group Buffer Pools is an important activity for keeping your system running smoothly. First, this web lecture goes through the functions and features of Group Buffer Pools to explain the processes involved in tuning. Then, it will show you a series of reports and explain how to interpret key metrics for Group Buffer Pool tuning. Recommended thresholds are described.
Views: 1209 World of Db2
Understanding And Resolving Oracle Free Buffer Wait Contention - Seminar Intro
 
06:19
This is the introduction to my video seminar, Understanding And Resolving Oracle Free Buffer Wait Contention. 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. As Oracle DBAs, our job is to regain control of the situation and restore application performance. But it is complicated and making the wrong move can make the situation even worse! So, how do you quickly improve performance with a clear understanding of the situation? That's the focus of this seminar. This seminar is designed to take you on a journey. The journey starts with Craig clearly explaining what a free buffer wait is. Then he delves into Oracle's buffer cache, focusing on the least recently used (LRU) lists and the associated algorithms. Craig even role plays as an Oracle foreground process and an Oracle buffer header, locking the details into your brain. Now the details brought together making the cause and effect clear so the presented solutions make perfect sense! Taking it further, two solutions are implemented and the results analyzed. Join Oracle ACE Director Craig Shallahamer as he take you on an unforgettable journey into the Oracle buffer cache zeroing in on understanding and resolving Oracle free buffer waits. For details go to http://www.orapub.com/video-seminar-understanding-eliminating-oracle-free-buffer-waits For more information about OraPub go to www.orapub.com
Views: 1047 OraPub, Inc.
EXEM Customr Case: Phenomenon of excessive generation of pin S wait on X
 
01:40
Check the video and see how EXEM Consultants help our customer quickly identifying problem and solve them.
Views: 38 EXEM TV
Funcionamento PARSE - ORACLE
 
02:21
Funcionamento hard parse e soft parse em uma instancia Oracle-- Created using PowToon -- Free sign up at http://www.powtoon.com/join -- Create animated videos and animated presentations for free. PowToon is a free tool that allows you to develop cool animated clips and animated presentations for your website, office meeting, sales pitch, nonprofit fundraiser, product launch, video resume, or anything else you could use an animated explainer video. PowToon's animation templates help you create animated presentations and animated explainer videos from scratch. Anyone can produce awesome animations quickly with PowToon, without the cost or hassle other professional animation services require.
Views: 340 DBA Maker
SCPT 7: Oracle Control Files
 
12:13
Oracle DBA Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 42687 Oresoft LWC
Real-World Performance - 16 - Classic Real World Performance
 
15:48
Check out the entire series on the Oracle Learning Library at http://www.oracle.com/goto/oll/rwp In this video, listen and watch Andrew Holdsworth, Vice President of Oracle Database Real-World Performance at Oracle Corporation, as he explains what classic Real-World Performance is. Copyright © 2014 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the "Materials"). The Materials are provided "as is" without any warranty of any kind, either express or implied, including without limitation warranties of merchantability, fitness for a particular purpose, and non-infringement.
Test: Library Cache Pin during recompile stored procedure
 
04:37
SELECT sys_context('USERENV', 'SID') FROM dual; set lines 130 set pages 1000 SELECT substr(DECODE(o.kglobtyp, 7, 'PROCEDURE', 8, 'FUNCTION', 9, 'PACKAGE', 12, 'TRIGGER', 13, 'CLASS'),1,15) "TYPE", substr(o.kglnaown,1,30) "OWNER", substr(o.kglnaobj,1,30) "NAME", s.indx "SID", s.ksuseser "SERIAL" FROM sys.X$KGLOB o, sys.X$KGLPN p, sys.X$KSUSE s WHERE o.inst_id = USERENV('Instance') AND p.inst_id = USERENV('Instance') AND s.inst_id = USERENV('Instance') AND o.kglhdpmd = 2 AND o.kglobtyp IN (7, 8, 9, 12, 13) AND p.kglpnhdl = o.kglhdadr AND s.addr = p.kglpnses ORDER BY 1, 2, 3 ; http://surachartopun.com/2008/12/recompiled-stored-procedure-library.html
Views: 773 Surachart Opun
SCPT 19: Server Processes
 
14:59
For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 15437 Oresoft LWC
SCPT 42: What is redo and undo in Oracle
 
21:56
Oracle DBA Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 25903 Oresoft LWC
Real-World Performance - 3 - Connection Pools and Hard Parse
 
06:19
Check out the entire series on the Oracle Learning Library at http://www.oracle.com/goto/oll/rwp In this video, listen and watch Andrew Holdsworth, Vice President of Oracle Database Real-World Performance at Oracle Corporation, as he demonstrates how connections and hard parsing contribute to transaction throughput and simulates the mistakes of a poor configuration creating sub-optimal performance. Copyright © 2014 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the "Materials"). The Materials are provided "as is" without any warranty of any kind, either express or implied, including without limitation warranties of merchantability, fitness for a particular purpose, and non-infringement.
SCPT 20: Oracle Back Ground Processes (PMON,SMON,RECO)
 
13:01
Oracle DBA Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 33379 Oresoft LWC
SCPT 44: Undo Management In Oracle
 
14:07
Oracle DBA Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 20468 Oresoft LWC
SCPT 46:Oracle Storage Termininology:  High Water Mark and Free Lists
 
15:31
Oracle DBA Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 17357 Oresoft LWC
Curso de Oracle (Tuning) 06 - Data Dictionary Cache, UGA e Large Pool
 
17:05
Curso Oracle PL/SQL Essentials http://bit.ly/1N3upVn Curso Oracle SQL Expert - Certificação 1Z0-047 http://bit.ly/1G4rKWG Curso Oracle Aprendendo SQL - Preparatório exames 1Z0-051/1Z0-061 http://bit.ly/1eqDlsr Curso de Administração de Redes de Computadores http://goo.gl/nXjaXS Neste curso de Tuning no Oracle você irá aprender os principais conceitos de tuning no oracle melhorando consideravelmente as aplicações em ambientes de produção. No Curso de Tuning no Oracle você será direcionado passo a passo durante o aprendizado com ótima qualidade do conteúdo disponibilizado. Este curso é oferecido gratuitamente aqui porém caso tenha interesse em se aprofundar e aprender o oracle a fundo praparando para certificação acesse os links acima. Também acesse o link de administração de redes de computadores para mais conhecimento nesta área tornando-se um profissional completo. http://youtu.be/4wEd1Qjj-Z8 Tags: Oracle Curso de Oracle Curso de banco de dados Tuning Cursos gratuitos
Views: 598 Cursos Interativos
All About Binds
 
06:16
TO USE OR PRINT this presentation click : http://videosliders.com/r/184 ============================================================== All About Binds Thomas Kyte ,It’s All About Binds ,Agenda Performance Is it just about sharing SQL (or is this really a parsing talk in disguise) Scalability Security Do I always want to bind? What is bind variable peeking? Is it good or evil in disguise or a bit of both? I’m binding, but it isn’t sharing – what’s up with that? So the developers don't bind is cursor_sharing = force/similar appropriate system wide? What is the real difference between cursor_sharing = force/similar and which should we use under what circumstances? ,Performance What is involved in all Parses The “conventional” parse - syntax Semantic check What about a hard parse Optimization (can you spell C.P.U…) Row Source Generation And then we can finally execute it Soft Parse is lighter weight But it is called a “shared” pool, not “your” pool Shared data structures have to be protected Optimization can be avoided Row Source Generation can be avoided Bind01.sql ,Performance Wonder if it might affect memory utilization? Strange that count(*) is so low for that first query isn’t it. Unfortunate that sum(sharable_mem) is so high (and remember, it really is 10 times that amount) Bind02.sql ,Scalability But it runs fast enough and I’ll buy more memory Does it really? Run bind03.sql [email protected]> select 11/10000 from dual; 11/10000 ---------- .0011 ,Latch Algorithm Loop for I in 1 .. 1 loop try to get latch if got latch, return if I = 1 then misses=misses+1 end loop INCREMENT WAIT COUNT sleep Add WAIT TIME End loop; ,More multi-user USERS NOBIND_CPU PARSE_MANY_CPU PARSE_ONCE_CPU ------- ---------- -------------- -------------- 1.00 .27 .07 .03 2.00 .72 .21 .09 3.00 1.46 .38 .13 4.00 2.59 .67 .27 5.00 3.20 .85 .34 6.00 4.20 1.01 .40 7.00 4.79 1.20 .51 8.00 5.74 1.44 .53 9.00 6.27 1.60 .64 10.00 7.16 1.76 .72 ,Security Google sql injection Funny thing happened during my last column create or replace procedure set_udump (p_udump in varchar2) as begin execute immediate 'alter system set user_dump_dest = '''||p_udump||''' scope=memory'; end; / ,Security Google sql injection Funny thing happened during my last column create or replace procedure set_udump (p_udump in varchar2) as begin execute immediate 'alter system set user_dump_dest = '''||p_udump||''' scope=memory'; end; / begin set_udump('C:\ORA4\admin\ora4\udump2'' scope=memory utl_file_dir=''*'' scope=spfile user_dump_dest=''C:\ORA4\admin\ora4\udump2'); end; ,Security Google sql injection Funny thing happened during my last column create or replace procedure set_udump (p_udump in varchar2) as begin if ( p_udump NOT LIKE '%=%' ) then execute immediate 'alter system set user_dump_dest = '''||p_udump||''' scope=memory'; else raise_application_error(-20000,'Sorry, but for safety reasons this procedure does not allow "=" in the parameter value'); end if; end; ,Do I always want to bind? Always say “Never say Never” Never say “Always” You do not want to Over Bind Always Bind Why…. ,Do I always want to bind? Over Binding Compulsive disorder to eradicate all literals in SQL Brought on by taking good advice to an illogical extreme Do we need to bind those? Might it be a bad thing to bind those? Begin for x in ( select object_name from user_objects where object_type in ( ‘TABLE’, ‘INDEX’ )) loop … ,Do I always want to bind? Always Binding Data warehouse – no way. When you run queries per second, yes. When you run queries that take seconds, maybe, maybe no. Conside
Views: 52 slide show me
Real-World Performance - 12 - Getting In Control
 
06:43
Check out the entire series on the Oracle Learning Library at http://www.oracle.com/goto/oll/rwp In this video, listen and watch Andrew Holdsworth, Vice President of Oracle Database Real-World Performance at Oracle Corporation, as he highlights how getting control of your database affects performance. Copyright © 2014 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the "Materials"). The Materials are provided "as is" without any warranty of any kind, either express or implied, including without limitation warranties of merchantability, fitness for a particular purpose, and non-infringement.
SCPT 32: Durability Characteristics of Transaction
 
09:13
Oracle Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 9143 Oresoft LWC
SCPT 18: Introduction to Oracle's Processess
 
08:09
Oracle DBA Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 16711 Oresoft LWC
SCPT 28:Oracle Database Start Up Steps
 
14:03
Oracle Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 15278 Oresoft LWC
SCPT 23: Oracle Slave Processes
 
11:05
Oracle DBA Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 16350 Oresoft LWC
SCPT 39: Types of DML Locks
 
23:42
Oracle DBA Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 15465 Oresoft LWC
How an intense and diverse SQL statement workload can cause Oracle parsing problems
 
09:19
Make your library cache angry! This video is about how an intense and diverse SQL statement workload can cause Oracle parsing problems. There are many reasons for Oracle parsing related performance issues and many ways to identify them. So, I am narrowing the scope by focusing on one possible cause, that is, an intense and diverse SQL statement workload. I will use Oracle's wait interface to identify the root cause. Sound dry and boring? To make this a little more interesting and a whole lot more fun, I'm going to approach this from a non-traditional, almost backward perspective. After explaining some of the Oracle internals, I'm going to create a parsing intensive workload and then watch what happens... in real time. The educational impact is so powerful, I recorded a video This is video is part of Craig's blog post: http://blog.orapub.com/20170126/how-an-intense-and-diverse-sql-workload-causes-oracle-parsing-problems.html For more information go to www.orapub.com
Views: 247 OraPub, Inc.