Home
Search results “Execution plan for oracle”
Oracle Performance Tuning - Read and interpret Explain Plan
 
17:43
Connect with me or follow me at https://www.linkedin.com/in/durga0gadiraju https://www.facebook.com/itversity https://github.com/dgadiraju https://www.youtube.com/c/TechnologyMentor https://twitter.com/itversity
Views: 38578 itversity
Oracle SQL Tuning - How to Read Execution Plans (Explain Plan)
 
13:39
In this free tutorial you will learn how to generate and read (interpret) an execution plan in Oracle Databases. See more FREE Oracle Tuning tutorials at http://skillbuilders.com/free-oracle-tutorials. Understanding what the Oracle Database does with your SQL is essential to tuning - and the execution plan is the key. Oracle Certified Master DBA John Watson will provide a brief introduction (4 minutes) - which includes John's tuning methodology, then demonstrate EXPLAIN PLAN, SQL*Plus AUTOTRACE and DBMS_XPLAN.DISPLAY_CURSOR. In the tutorial, John will teach you: - How to read an execution plan - Find the 1st step in the plan - Decipher the order of the steps in the plan - That EXPLAIN PLAN can be very misleading Prerequisites: To get the most from this tutorial, you should: 1 Know how to code SQL 2 Be familiar with SQL*Plus 3 Know - in very general terms - what an execution plan is. 4 Have a basic understanding of the Library Cache (this is where Oracle Database stores parsed SQL statements) 5 Have a basic understanding of the Cost Based Optimizer (this is the part of the database that parses your SQL, creates an execution plan. Hopefully the correct - most efficient - plan).
Views: 64355 SkillBuilders
Oracle Explain Plan basics
 
11:50
This video gives basic understanding of Oracle Explain plan and will help to understand execution plan terminology.
Views: 13695 amit wadbude
Oracle tutorial : Using execution plan to optimize query in oracle
 
12:54
Oracle tutorial: Explain plan for query optimization in Oracle PLSQL oracle tutorial for beginners using execution plan to optimize query sql query analyzer sql query cost analysis https://techquerypond.wordpress.com This oracle tutorial show you how to use EXPLAIN PLAN in oracle. This video covers how to check cost of the query from DBMS_XPLAN.DISPLAY . You can find the cost of the query using the Using EXPLAIN PLAN FOR and based on the result you can optimize the query for faster performance. Subscribe on youtube: https://www.youtube.com/channel/UCpiyAesWNYOXSz5GPq8lbkA For more tutorial please visit #techquerypond https://twitter.com/techquerypond
Views: 10794 Tech Query Pond
Interpreting Oracle Explain Plan Output - John Mullins
 
01:00:16
Themis Instructor John Mullins presents some details on interpreting Oracle Database Explain Plan output. For more information visit http://www.themisinc.com
Views: 45067 Themis Education
ORACLE EXPLAIN PLAN FUNDAMENTALS
 
36:14
This Tutorial will explain basics of Oracle 11g EXPLAIN Plan by using this ppt & some hands-on in Oracle 11g R2 Database.This tutorial will include below topics. Understanding EXPLAIN plan. Set up & Use EXPLAIN Plan. Explain PLAN_TABLE & related scripts & DBMS_XPLAN.DISPLAY. Generate & View EXPLAIN Plan. Read & Interpret basics of EXPLAIN Plan. EXPLAIN PLAN limitations.
Views: 160668 Anindya Das
Explaining the Explain Plan: Interpreting Execution Plans for SQL Statements
 
01:04:02
Presenter: Maria Colgan, Oracle Corporation The execution plan for a SQL statement can often seem complicated and hard to understand. Determining if the execution plan you are looking at is the best plan you could get or attempting to improve a poorly performing execution plan can be a daunting task, even for the most experienced DBA or developer. This session examines the different aspects of an execution plan, from selectivity to parallel execution, and explains what information you should be gleaming from the plan and how it affects the execution. It offers insight into what caused the Optimizer to make the decision it did as well as a set of corrective measures that can be used to improve each aspect of the plan.
Views: 3928 ODTUG
SQL: Explain Plan for knowing the Query performance
 
05:17
In this tutorial, you'll learn how to compare queries to know the better performance query..
Views: 96054 radhikaravikumar
Understanding The Execution Plan - Part 1
 
01:29:06
Topic: Understanding The Execution Plan In this video (part-1) I have explained - The basics of Oracle Execution Plan - How an Execution Plan Looks from SQL Developer, SQL*Plus - How to use Oracle Explain Plan command - Where else one can find Oracle's Execution Plan apart from PLAN_TABLE - Some Examples of Execution Plan - Using DBMS_XPLAN package to format the output while printing the Execution Plan
Views: 6187 Satish Lodam
Influencing Oracle SQL Execution Plans
 
51:50
Themis instructor John Mullins discusses Oracle SQL Execution plans and how you can influence them for better SQL performance.
Views: 1810 Themis Education
Ways of generating EXECUTION PLAN in Oracle Database
 
12:15
Learn how to generate execution plan in oracle database in many ways
Views: 3426 OrSkl Academy
Oracle Database 12c: Adaptive Execution Plans with Tom Kyte
 
05:42
Tom Kyte introduces adaptive execution plans followed by a demo. "Adaptive Plans" in SQL Tuning Guide" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=TGSQL221 "Controlling Adaptive Optimization" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=TGSQL257 "Generating and Displaying SQL Execution Plans" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=TGSQL271 "Keeping Your Database Secure" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=DBSEG009
Views: 13755 OracleDBVision
Query Tuning 101: How to Compare Execution Plans
 
04:12
When you're tuning SQL query there's two important questions to keep in mind: * Have my changes made any difference? * If they have, is performance better or worse? In this video we'll look at how you can use SQL Developer to compare execution plans. This will enable you to differences between them and determine which plan performs better. ============================ The Magic of SQL with Chris Saxon Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. 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 or merchantability, fitness for a particular purpose, and non-infringement.
Views: 14742 The Magic of SQL
05 04 Reading an Execution Plan
 
04:26
ORACLE
Views: 436 oracle ocm
Obtaining Execution Plan in Oracle
 
05:11
Obtaining Execution Plan in Oracle with demostration.
Views: 358 Expert-Oracle.com
Execution Plan Example 2
 
03:10
Get the complete course on SQL Tuning(Regular price $199) for only $10 https://www.udemy.com/sql-tuning/?couponCode=UDEYOU
Views: 548 Oracle Training
Execution Plan Example 4
 
06:34
Get the complete course on SQL Tuning(Regular price $199) for only $10 https://www.udemy.com/sql-tuning/?couponCode=UDEYOU
Views: 2254 Oracle Training
Oracle Explain Plan
 
12:08
Oracle SQL Executions: Explain Plan and Execution Plan A simple introduction with a single table example
Views: 936 Hemant K Chitale
Execution Plan Example 1
 
02:16
Get the complete course on SQL Tuning(Regular price $199) for only $10 https://www.udemy.com/sql-tuning/?couponCode=UDEYOU
Views: 857 Oracle Training
Using DBMS_XPLAN.DISPLAY_CURSOR to examine execution plans
 
12:33
In this video I describe how you can use Oracle's DBMS_XPLAN.DISPLAY_CURSOR to examine the execution plan for a SQL statement that has recently been executed and determine if that plan is optimal or not and where you might be able to optimize it.
Views: 8273 Maria Colgan
Slow SQL Query? Get the Plan in Oracle SQL Developer!
 
15:38
See how to get execution and explain plans, format and views those plans, use AutoTrace, and Real Time SQL Monitoring for your SQL queries in Oracle SQL Developer.
Views: 2303 Jeff Smith
Oracle Parallel Execution Plans Deep Dive
 
44:24
A presentation about understanding the essentials of Oracle Parallel Execution and how to read the corresponding execution plans
Views: 2843 Randolf Geist
Introduction to Execution Plan
 
02:12
Get the complete course on SQL Tuning(Regular price $199) for only $10 https://www.udemy.com/sql-tuning/?couponCode=UDEYOU
Views: 407 Oracle Training
Oracle SQL Tuning - How to Read Execution Plan Part 1
 
03:39
Learn how to tune SQL. If you're going to tune Oracle SQL statements, you will need to learn how to read an execution plan! See all Free lessons in this tutorial at http://www.skillbuilders.com/sql-tuning-for-beginners-free-tutorial .
Views: 2094 SkillBuilders
Oracle Performance Tuning - Generate Explain Plan
 
18:05
Connect with me or follow me at https://www.linkedin.com/in/durga0gadiraju https://www.facebook.com/itversity https://github.com/dgadiraju https://www.youtube.com/c/TechnologyMentor https://twitter.com/itversity
Views: 8530 itversity
How to auto-optimize SQL code with Toad for Oracle Xpert Edition
 
03:50
http://www.DellSoftware.com/Toad-for-Oracle This video shows how to auto-optimize SQL code with Toad for Oracle Xpert Edition from Dell Software.
Views: 7087 DellTechCenter
2014 11 03 12 15 Oracle Lunch n Learn Explain Plan Syntax
 
19:27
Oracle Explain Plan content including Plan_Table setup, SQL*Plus and bind variables, and newer DBMS_XPLAN syntax.
Views: 3081 Dan Hotka
22 Basic Execution Plans
 
29:46
SQL Server 2012 Administration Essentials SQL Server 2014
Oracle 12c SQL Tuning - Adaptive Execution Plans
 
10:11
Learn an Oracle Database 12c new performance feature - Adaptive SQL Plans. During execution, Oracle Database can switch the SQL to a new plan. A very powerful corrective measure! But if you don't know about it , how can you possibly tune SQL in Oracle Database 12c? Time to learn 12c!
Views: 5457 SkillBuilders
Loading plans in SQL Baselines in Oracle
 
06:01
Loading plans in SQL Baselines
Views: 2934 Apps Core
Understanding SQL Trace, TKPROF and Execution Plan for Beginners
 
01:01:38
Presenter: Carlos Sierra, Oracle Corporation In this session, participants will learn about producing a SQL Trace then a summary TKPROF report. A sample TKPROF is navigated with the audience, where the trivial and the not so trivial is exposed and explained. Execution Plans are also navigated and explained, so participants can later untangle complex execution plans and start diagnosing SQL performing badly.
Views: 582 ODTUG
Plan d'exécution Oracle
 
06:37
http://oraclexperts.ca L'interprétation de plusieurs plans d'exécution avec Oracle 11g 10G, optimiser vos bases de données Oracle, vidéo de formation Oracle sur l'optimisation
Views: 6790 oracleexpert
Calculate query performance with Explain Plan in Oracle PLSQL.
 
09:14
Explain plan is a wonderful utility in Oracle PL SQL. It helps you to understand how much cost a query takes to perform based on indexed table or table without index. In this oracle tutorial a full description is given on a table containing huge number of rows first based on index on a column and then without index.
Views: 3695 Subhroneel Ganguly
Oracle Optimizer Cost Calculation from explain plan
 
02:23
This presentation describes the method to understand how oracle calculate cost during explain plan generation
Views: 705 debasis maity
What exactly is PLAN TABLE in Oracle Database #Performance #Tuning
 
16:00
Running an EXPLAIN PLAN to generate EXECUTION PLAN in oracle database is possible with PLAN_TABLE. But this video will give you much more insights of what is this PLAN_TABLE. Learn how is PLAN_TABLE called as global temporary table. Need Oracle database training? WhatsApp to +919951696808 visit www.orskl.com/training
Views: 3058 OrSkl Academy
SQL Plan Baselines
 
09:54
SQL Plan Baselines watch more videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjab, Tutorials Point India Private Limited
EXPLAIN PLAN for multiple SQL statements
 
09:43
How to generate Oracle database explain plan for number of SQL statements at the same time.
Views: 2206 OrSkl Academy
Oracle 11g Pro Performance Tuning Ls 1:Explain plan
 
29:18
In this tutorial you will learn how to tune the oracle 11g performance.
Views: 18195 DBA Pro
Oracle SQL Developer - Comparing SQL Execution Plans
 
10:36
This is a short video about a feature in SQL Developer which alllow any DBA or developer to compare different execution plans of a SQL Statement. My Blog: https://navneetupnejadba.wordpress.com/ Slideshare: https://www.slideshare.net/navneetupneja1/sql-developer-powerful-free-tool-for-developers-and-dbas
Views: 230 Navneet Upneja
Oracle Performance - SQL Baseline Exercises
 
08:52
Oracle Performance - SQL Baseline Exercises
Views: 2807 The Silent DBA
Query Tuning 101: Access vs. Filter Predicates In Execution Plans
 
02:08
Have you ever wondered what the difference is between the "filter predicates" or "access predicates" steps listed in execution plans - or even what a predicate is? If so, watch this video to find out! Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. 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 or merchantability, fitness for a particular purpose, and non-infringement.
Views: 4858 The Magic of SQL
Oracle SQL Tuning Re-Optimizing Execution Plans with Cardinality Feedback
 
15:37
Cardinality feedback, introduced with Oracle Database 11g, has been significantly enhanced with 12c. Cardinality feedback allows the CBO to learn from a cardinality estimate mistake and re-optimize the execution plan. Learn more in this free SQL Tuning tutorial. See all free Oracle Database tutorials at http://www.skillbuilders.com/free-oracle-tutorials.
Views: 3087 SkillBuilders
Oracle SQL Performance Tuning  1
 
06:49
Oracle SQL Performance Tuning and tips Cost Based Optimizer (CBO) Rule Based Optimizer (RBO) SQL Explain Plan Oracle Explain Plan
Views: 12101 TechLake
New SQL ID Does not mean hard parsing or new execution plan
 
08:02
Not that new SQL ID lets oracle database generate a new execution plan
Views: 1509 OrSkl Academy
Oracle SQL Tuning - Explain Plan Lies?
 
08:20
Do you use EXPLAIN PLAN to tune Oracle SQL? Does it always "tell the truth", or does it "lie". (Maybe it's not the whole truth!) In this free tutorial from SkillBuilders' Oracle Certified Master John Watson, you will learn why the execution plan generated by EXPLAIN PLAN can be misleading and what to do about it. After a brief lecture, John demonstrates exactly why. You'll hear about dynamic sampling, adaptive cursor sharing (11g), adaptive execution plans (12c) and of course, bind variables. John demonstrates how bind variables cause misleading execution plans using dbms_xplan.display and dbms_xplan.display_cursor. To get the most from this tutorial, you should have some understanding of hard parse, soft parse, cardinality, histograms. See all SkillBuilders FREE Oracle Database tutorials at http://www.skillbuilders.com/free-oracle-tutorials.
Views: 3371 SkillBuilders
SELECT statement Processing in an Oracle Database - DBArch  Video 7
 
06:22
You will learn from this video how a SELECT statement is processed in an Oracle Database. You will learn about the a Parse, Execute and Fetch phases in a select statement. Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 25710 Ramkumar Swaminathan
Query Tuning 101 What to Look for in Autotrace Output
 
02:58
You're up and running with autotrace, looking at the actual execution plan for a query. Now the real work begins! What is it you're actually looking for in the execution plan? This video shows what you need to investigate and how to use the HotSpot feature of SQL Developer 4.1 to highlight parts of the query you need to pay attention to. ============================ The Magic of SQL with Chris Saxon Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. 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 or merchantability, fitness for a particular purpose, and non-infringement.
Views: 7929 The Magic of SQL
How to read and interpret an explain plan by Daniel Morgan (English)
 
01:08:05
Webinar done in 2010 by Oracle ACE Director Daniel Morgan regarding how to read and interpret an Oracle explain plan
Views: 15885 OracleMania

Depo provera injection generic plavix
Poemas de amor poetas celebrex generic name
Para que sirve cytotec 200mcg
Ikaclomin tab 50 mg zoloft
Topamax 500mg