Home
Search results “Autotrace on oracle”
Oracle  AUTOTRACE Fundamentals to Analyze & Tune SQL
 
20:43
This Tutorial will explain fundamentals of Oracle AUTOTRACE. Set up & Use AUTOTRACE. Review PLAN & Statistics generated by AUTOTRACE. Understanding Statistics details.
Views: 22286 Anindya Das
Query Tuning 101 How to Run Autotrace in SQL Developer
 
02:21
This video shows how to run autotrace reports using Oracle SQL Developer to analyze query performance. It also discusses the privileges you need to enable database users to run autotrace. ============================ 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: 16993 The Magic of SQL
Using Autotrace in SQL*Plus
 
10:40
Demonstration of using autotrace in SQL*Plus, and how it can aid in performance tuning.
Views: 7896 Stephen Frein
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: 7448 The Magic of SQL
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: 61657 SkillBuilders
Oracle 11g Pro Performance Tuning Ls 3: Autotrace Utility
 
12:09
In this tutorial you will learn how to enable autotrace to improve oracle database performance.
Views: 480 DBA Pro
Oracle SQL Tuning  AutoTrace Option
 
01:39
http://www.dbvidya.com/course/sql-tuning-advanced/ [email protected] +91 991 23 23 000
Views: 174 DbVidya
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: 6294 DellTechCenter
05 06 Autotrace Introduction
 
04:11
ORACLE
Views: 12 oracle ocm
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: 5797 Maria Colgan
ORACLE TKPROF fundamentals Part 1 -  Introduction to SQL Tracing & TKPROF
 
11:44
Link for ORACLE TKPROF fundamentals Part-2 (Interpret TKPROF Report) https://www.youtube.com/watch?v=OiVu6vFq28w ORACLE TKPROF fundamentals For SQL TUNING Part-1 covers 1. Introduction to SQL Tracing. 2. Set up SQL_Trace &TKPROF. 3. Generate TKPROF Report. ---------------------------------------------------------------------------------------------------------------------- ORACLE TKPROF fundamentals For TUNING SQL Part-2 covers  1. Interpreting TKPROF Report.
Views: 30466 Anindya Das
Query Tuning 101 Why Use Autotrace
 
01:38
When you're optimizing SQL queries you need to understand what they're actually doing. Explain plan is a commonly used tool with a major flaw - the reported plan and actual plan can be different! This video demonstrates this with a simple query, showing how autotrace reports the correct execution plan for the SQL statement. ============================ 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: 2176 The Magic of SQL
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: 1549 Jeff Smith
AskTOM TV - SQL trace, SQL plus, SQL developer
 
05:12
A video to help you understand the "thought process" behind answering AskTom questions. In this episode, we look at how we can use SQL trace to diagnose what autotrace privileges we need in SQL Developer blog: https://connor-mcdonald.com ========================================­­­­============== Copyright © 2017 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: 879 Connor McDonald
Oracle SQL_TRACE - Beginner
 
11:31
Oracle SQL_TRACE - Beginner
Views: 20423 Chris Ostrowski
SQL Tuning for Beginners Part 1 - Tuning Methodology and Basic Optimization Concepts
 
27:26
Get started with Oracle SQL Tuning! Designed for developers, DBA's and Analysts who are new to SQL Tuning, this free tutorial introduces a tuning methodology, basic tuning concepts. Part 2 provides a demonstration of explain plan and autotrace for getting an execution plan. Watch Part 2 and 3 - **FREE** - at http://www.skillbuilders.com/oracle-sql-tuning-for-beginners-tutorial. Presented by Dave Anderson and Oracle Certified Master John Watson. Attend 1-day class for beginners, online or on-premise: http://www.skillbuilders.com/oracle-sql-tuning-training-for-beginners
Views: 9045 SkillBuilders
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: 365 ODTUG
Ronald Vargas Quesada - Oracle Database Performance Tuning con SQL
 
42:52
En esta presentación Ronald de Costa Rica nos muestra cómo mejorar la performance de la base de datos a partir de un correcta escritura de las sentencias SQL.
Views: 5767 OracleAmericaLatina
Four Steps to Oracle SQL Tuning  - A Methodolgy
 
02:43
Learn a predictable and repeatable methodology for tuning Oracle SQL statements. Just four steps that you should always follow when tuning an SQL statement. (Note this video does not contain examples of how to apply the four steps, just what the steps are.) Oracle Certified Master John Watson presents. John concludes with a brief overview of how SkillBuilders SQL tuning course provides the information you need to apply the four steps. Learn more about SkillBuilders SQL Tuning course http://skillbuilders.com/oracle-sql-tuning-training 1. What is Oracle doing? (explain plan, trace) 2. Why is Oracle doing it that way? (analyze the execution plan) 3. Is there a better way? Test! 4. If there's a better way, push the CBO towards the better way.
Views: 10735 SkillBuilders
Oracle SQL Developer's Tuning Features
 
50:59
An overview of all the performance tuning and diagnostic features in Oracle SQL Developer including: Explain Plan, Autotrace, SQL Tuning Advsior, Real Time SQL Monitoring, ASH, Monitoring Sessions, and our new Instance Viewer.
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: 43146 Themis Education
SQL: SQL Tracing  Part-1
 
04:33
In this tutorial, you'll learn how to create a tracing file..
Views: 9583 radhikaravikumar
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: 91286 radhikaravikumar
Trace session details with USER process and SERVER process ID
 
13:43
Oracle database user session tracing.
Views: 5991 OrSkl Academy
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: 13750 The Magic of SQL
Query Tuning with tkprof
 
14:57
Demonstration of generating Oracle trace files and then turning these into tuning reports with the tkprof utility.
Views: 54096 Stephen Frein
Ways of generating EXECUTION PLAN in Oracle Database
 
12:15
Learn how to generate execution plan in oracle database in many ways
Views: 3196 OrSkl Academy
tkprof for trace analysis
 
12:56
tkprof for trace analysis watch more videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjab, Tutorials Point India Private Limited
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: 157453 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: 2889 ODTUG
Oracle SQL Tuning - Oracle Execution Plans for Beginners
 
13:39
For More Tutorials Related To Cisco,CCNA,Microsoft,Oracle,HP,Adobe,IBM,Java And Much More Please Visit This Site http://www.geteveryvideos.com/category/certification-tutorials/
Oracle 12c Performance Tuning - Webinar 17/08/2017
 
01:01:08
In this webinar, we will overview performance problems with nowadays database applications. It will explore various approaches to tackle these performance problems after introducing key natures of Oracle database engine. For more information visit the New Horizons website: https://goo.gl/SFn78P
How to Gather SQL Resource Consumption Metrics in Oracle
 
01:20:51
Presented by Karen Morton Tues 8th May 2012 Summary SQL is utilized to return data via our applications to service user requests. Whether it's a single customer lookup or a huge month end summary report, the SQL we write must gather the correct data and return it to the user. Ensuring that the SQL you write can do this in a timely and efficient manner, both now and in the future, requires that you measure and evaluate what resources your query must use. In this webinar, we'll cover several methods for how to collect data that show you precisely how your SQL consumes resources: Using AUTOTRACE Using DBMS_XPLAN.DISPLAY_CURSOR Using Report SQL Monitor Using ASH (Active Session History) and AWR (Automatic Workload Repository) data You'll learn how to utilize the data to understand the work your SQL is doing and the resources it consumes; identify currently evident performance issues as well as areas that could be problematic in the future; and modify your SQL to use less resources more efficiently while still returning the desired results. A live Q+A session with Karen Morton follows the presentation. For our complete archive, and to sign up for upcoming webinars please go to http://www.red-gate.com/oracle-webinars
Views: 7033 Redgate Videos
SQL Tuning for Beginners 2 - Review Challenge
 
08:33
In Part 2, Oracle Certified Master reviews the tuning challenge presented at the end of part 1. John uses Autotrace to demonstrate which query performs the best.
Views: 2766 SkillBuilders
Optimizer Statistics
 
11:10
Optimizer Statistics watch more videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjab, Tutorials Point India Private Limited
DBMS_PROFILER - A Key to Identify PL/SQL Performance Bottleneck
 
14:02
This video tutorial explains PL/SQL performance analysis with DBMS_PROFILER. This video tutorial explains DBMS_PROFILER package,Profiler tables,how to use profiler. It demonstrates Setting up DBMS_PROFILER, Profiling for a PL/SQL procedure and Analyzing the Profiler data.
Views: 26519 Anindya Das
Oracle Performance - Create Tuning Sets and Run SQL Tuning Advisor
 
09:50
Oracle Performance - Create Tuning Sets and Run SQL Tuning Advisor
Views: 3233 The Silent DBA
Debugging PL/SQL with Oracle SQL Developer
 
34:43
Quick overview of our PL/SQL debugger - required privs, setup, and a demo of stepping through a PL/SQL function. Breakpoints, watches, and call stacks, oh my!
Real Time SQL Monitorin Demo in Oracle SQL Developer
 
03:42
See how to watch a query execute in real time using this Oracle Database Tuning Pack feature in Oracle SQL Developer.
Views: 20863 Jeff Smith
Oracle SQL Developer: You're Doing it Wrong
 
17:12
15 minutes power tips and tricks session where the product manager will how you how you SHOULD be using Oracle's database IDE and GUI.
Views: 18793 Jeff Smith
Event 10053 Tracing the CBO
 
01:04:20
SQL Master Training Class Carlos Sierra - Using Oracle's 10053 Trace file (CBO)
Views: 1736 NoCOUG Channel
[Oracle SQL Performance Tuning: 1/4] Overview of SQL Processing
 
28:06
The series of SQL tuning videos presents performance tuning tips for developers
Views: 7011 anilkumar ghorakavi
SQL: Introduction to Optimizer in Oracle
 
07:34
In this tutorial, you'll know what is the meaning and use of Optimizer in Oracle
Views: 16914 radhikaravikumar
Where is my tracefile
 
04:32
SQL trace is an awesome performance tuning resource. But before you can do that analysis, you need to know WHERE your trace file is. ========================================­============== 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: 2544 Connor McDonald
Quickly Tuning SQL with SQL Developer
 
21:31
In this video, I show a few shortcuts I used to make quick tuning work of a problematic SQL statement in SQL Developer 4.1
Views: 9002 BPeaslandDBA
Formatting your Oracle Query Results Directly to CSV
 
03:02
How to get Oracle SQL Developer to automatically format your query results to CSV, HTML, JSON, Insert statements, and more.
Views: 36996 Jeff Smith
Query Analysis and Optimizing in Oracle
 
37:53
Database Management Systems 11. Query Analysis and Optimizing in Oracle ADUni
Views: 82302 Chao Xu
Oracle SQL Tuning Training  Demo Video
 
33:21
http://www.dbvidya.com/course/sql-tuning-advanced/ [email protected] +91 991 2323 000 DbVidya provides online training in various topics Oracle performance tuning for DBA, oracle SQL Tuning training for developers, ETL ,database professionals. Also provides training in Dimensional data modeling and ER Data Modeling and ERwin tool.
Views: 9211 DbVidya