Home
Search results “Oracle baseline sql”
Oracle Performance - SQL Baseline Exercises
 
08:52
Oracle Performance - SQL Baseline Exercises
Views: 2289 The Silent DBA
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
Loading plans in SQL Baselines in Oracle
 
06:01
Loading plans in SQL Baselines
Views: 2306 Apps Core
Oracle 11g New Features : SQL Plan Management  (Baselining)
 
22:15
Oracle 11g SQL Plan Management, a.k.a. Baselining, will solve the major issues of change control. We can give you an absolute guarantee - if you configure this as part of your upgrade - that SQL statement execution (performance) will never regress. You may also like our new and free Oracle 12c video tutorials, https://www.skillbuilders.com/free-oracle-database-tutorials . This tutorial is particularly relevant: it provides a review of baselining then reveals 12c performance features https://www.skillbuilders.com/free-oracle-database-tutorials/oracle-12c-sql-performance-features-agenda-session/
Views: 10030 SkillBuilders
SQL Tuning Advisor & Baselines
 
07:33
SQL Tuning Advisor & Baselines watch more videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjab, Tutorials Point India Private Limited
SQL Plan Management (Part 1)
 
16:56
SQL Plan Management (Part 1)
Views: 2095 Apps Core
VTS: SQL Tuning Without Trying - Arup Nanda
 
59:24
This VTS session features learn about the SQL Tuning Advisor feature in Oracle Database, and how to use it effectively and interpret the results for superior performance in the context of the real world presented by a real-life DBA. Presented by Oracle Ace Director Arup Nanda.
Views: 7773 Database Community
SQL Performance Baselining in Oracle 11g
 
09:39
Learn how to use SQL Plan Management (aka baselining) to prevent SQL performance regression! Stop performance from degrading! See all FREE lessons , including 12c Baselining here - http://www.skillbuilders.com/free-12c-performance-features-training-2
Views: 576 SkillBuilders
How to check and compare baselines with SQL Monitor
 
01:17
SQL Monitor Technical Author Anne Edwards explains how to check baselines for SQL Server performance metrics in Redgate SQL Monitor. To find out more about SQL Monitor, and to try it for yourself, visit http://www.red-gate.com/monitor
Views: 760 Redgate Videos
ORACLE SQL Plan Baseline設定演示
 
06:18
如何設定SQL Plan Baseline,可以固定SQL的執行計畫,確保執行效能不會因為其他因素而受到影響。
SQL PLAN MANAGMENT
 
08:54
Proyecto final de administración de bases de datos relacionales II
Views: 420 César Retana
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: 1628 Themis Education
SQL PLAN BASELINE Part II
 
04:21
本影片說明如何讓已經有PLAN BASELINE的SQL可以選擇更好的執行計畫。
Flush particular SQL Statement from Shared Pool
 
04:33
Flush Execution Plan in Oracle 11g, Flush sql_statement from shared pool in Oracle 11g,
Views: 699 Athar Fahad
Oracle Performance - SQL Performance Analyzer Guided Workflow Example
 
05:37
Oracle Performance - SQL Performance Analyzer Guided Workflow Example
Views: 383 The Silent DBA
Solving Performance Problems on Oracle DB
 
28:11
Solving Performance Problems on Oracle DB Matthew Vegh - Embarcadero Thursday, June 26, 2014 - 11am DBAs and database developers regularly spend a lot of time tracking down and resolving performance issues on the database servers they are responsible for; it can be very difficult, frustrating, and expensive. Given the complex interactions of applications, users and databases, new performance issues can arise almost as fast as old ones can be addressed. This session will simulate common performance problems on an Oracle server and then both identify those problems and provide effective solutions. Matthew Vegh is a Software Architect at Embarcadero Technologies for the Embarcadero DB Power Studio family of products and has been with the company for the better part of a decade. He has over 15 years of development experience with a wide range of technologies and a definite preference for database tooling.
Why Did Your SQL Execution Plan Change? | Alfredo Krieg
 
02:26
Oracle ACE Alfredo Krieg offers advice on tools for improving database performance in this 2 Minute Tech Tip recorded at the 2016 Great Lakes Oracle Conference in Cleveland, OH.
Oracle Performance - Create Tuning Sets and Run SQL Tuning Advisor
 
09:50
Oracle Performance - Create Tuning Sets and Run SQL Tuning Advisor
Views: 2925 The Silent DBA
SQL Plan Management SPM
 
01:37:27
SQL Master Training Class Carlos Sierra - Using DBMS_SPM (SQL Plan Management)
Views: 3720 NoCOUG Channel
ITSE 1345 Intro to Oracle SQL & PL/SQL
 
20:34
More than an introduction, this video serves as a refresher for the baseline knowledge necessary for this course...
Views: 127 Chris Burns
Using SQLTXPLAIN to Diagnose SQL Statements Perforning Poorly
 
04:00:15
SQL Master Training Class Carlos Sierra - Diagnosing poorly performing SQL statements
Views: 1471 NoCOUG Channel
SQL Tuning with Oracle Database 12c Histograms
 
09:20
Learn the new 12c options for creating histograms. See all free video tutorials at http://www.skillbuilders.com/free-oracle-tutorials. In this free tutorial, Oracle Certified Master DBA John Watson demonstrates what histograms do (provide correct cardinality), the difference between histogram types (Frequency and Height Balanced). You will also learn the importance of the auto sample size algorithm in 12c and the new "Hybrid" and "Top Frequency" type histograms.
Views: 3168 SkillBuilders
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: 13040 The Magic of SQL
12c SQL Performance Features - Baselining in 12c
 
06:07
Learn how to use SQL Plan Management in Oracle Database 12c to prevent SQL performance regression! All free lessons at http://www.skillbuilders.com/free-12c-performance-features-training-2
Views: 836 SkillBuilders
Oracle 12c: Database Administration II Part 2: Lab Demo Solution: Create an SQL Tuning Profile
 
05:43
http://gogotraining.com, 877-546-4446, sign up for a free account and watch all the preview videos for free! In this video you will learn how to Perform Flashback Database Recovery, Configure Flashback Data Archives, Tune Backup and Recovery Operations, Use Oracle’s SQL Tuning Advisor, Use Oracle’s SQL Access Advisor and Implement Oracle’s Advanced Memory Management. Create Metrics Thresholds and Alerts Create AWR Reports Create AWR Single and Repeating Baselines Implement SQL Plan Management Tune Oracle’s Shared Pool Tune Oracle’s Buffer Cache Use Oracle’s Automatic Segment Space Management http://gogotraining.com, 877-546-4446, sign up for a free account and watch all the preview videos for free!
Views: 1508 GogoTraining
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: 5215 SkillBuilders
Oracle SQL Monitoring - Performance Analysis
 
01:30:41
SQL Monitoring is the best new feature of Oracle 11g for performance analysts, developers and support teams. Finally there is a tool that provides the most accurate, useful and interesting information when a SQL statement is running for longer than expected in a clear format with no minimal advance configuration requirements: What execution plan is really being used? What row source cardinality calculations are incorrect? What steps in the plan are taking the most time and consuming most resources? In this presentation, Doug Burns will demonstrate the various ways of accessing SQL Monitoring functionality and use example reports to show how the information can be used to analyse both currently running and completed statements. It will also describe and offer solutions to some of the minor quirks you might encounter. For our complete archive, and to sign up for upcoming webinars please go to http://www.red-gate.com/oracle-webinars
Views: 4871 Redgate Videos
Why use SQL Monitor
 
05:11
Why should you use SQL Monitor? In this short video I explain why I love to use SQL Monitor when examining the execution plans for complex SQL statements. It's actually part of a larger discussion on my blog https://sqlmaria.com
Views: 1401 Maria Colgan
oracle sql performance analyzer
 
12:50
compares the performance of the statements in a tuning set before and after a database change.
SQL Snacks - Performance Tuning 101 - Baseline with PAL Tools
 
16:22
Ayman El-Ghazali www.TheSQLPro.com @TheSQLPro Special thanks to Edgardo Valdez for his help in teaching me to use the tool. SQL Snacks - Performance Tuning 101 Establishing a Baseline with the PAL Tools Original Blog Post: http://thesqlpro.com/2014/09/17/sql-snacks-video-performance-tuning-101-baseline-with-pal-tools/
Views: 1772 Ayman El-Ghazali
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: 12668 OracleDBVision
Oracle Performance - SQL Performance Analyzer Upgrade Example
 
07:01
Oracle Performance - SQL Performance Analyzer Upgrade Example
Views: 117 The Silent DBA
0305 The SQL Tuning Advisor
 
03:31
ORACLE
Views: 163 oracle ocm
Troubleshooting Oracle PL/SQL with DBMS_PROFILER and DBMS_UTILITY
 
45:44
Themis instructor John Mullins helps you gain an understanding of how to use the Oracle PL/SQL dbms_profiler and dbms_utilitypackages to troubleshoot and handle PL/SQL performance issues, program errors and exceptions.
Views: 3340 Themis Education
AWR with SQLDeveloper
 
07:25
#Oracle #AWR Using SQLDeveloper (Note : Usage of AWR requires the Diagnostic Pack Licence !) For examples of interpreting an AWR report search https://hemantoracledba.blogspot.com for "AWR"
Views: 5481 Hemant K Chitale
Collect and Baseline Wait Statistics (Dear SQL DBA Episode 14)
 
17:25
What are the best tools to collect and baseline wait statistics in SQL Server? Should you write your own? Read the transcript here: http://www.littlekendra.com/2016/08/25/collect-and-baseline-wait-statistics-dear-sql-dba-episode-14/ Prefer a podcast? http://www.littlekendra.com/dearsqldba/
Views: 1119 SQL Workbooks
1Z0-051 – Oracle Exam Database SQL Test Fundamentals I Questions
 
01:01
For more information on Oracle 1Z0-051 Practice Test Questions Please Visit: https://www.Pass-Guaranteed.com/1Z0-051.htm What am I going to be tested for? The 1Z0-051 Oracle Database: SQL Fundamentals I exam tests how you can manage your SQL fundamentals knowledge in writing subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Which are some of the topics of the 1Z0-051 SQL Fundamentals exam? Test Topic 1: Execute a basic Oracle SELECT statement Questions (Exam Coverage 14%) Test Topic 2: Displaying Data from Multiple Test Tables Questions (Exam Coverage 20%) Test Topic 3: Using Subqueries to Solve Queries Questions (Exam Coverage 20%) Test Topic 4: Using the Exam Set Operators Questions (Exam Coverage 21%) Test Topic 5: Creating Other Schema Objects Questions (Exam Coverage 13%) Test Topic 6: Oracle SecureFiles Questions (Exam Coverage 10%) Who can attend to the Oracle Database: SQL Fundamentals I test? The Oracle 1Z0-051 SQL Fundamentals exam is mainly intended for Application Developers, Data Warehouse Administrators, and PL/SQL Developers who use the Oracle SQL Developer as their main development tool. Can you give me some in-depth information on the 1Z0-051 exam topics? • List the capabilities of Oracle SQL SELECT statements • Oracle 1Z0-051 Direct NFS • Describe the use of group functions • Join a table to itself by using a self-join • Run health checks • Write single-row and multiple-row subqueries exam • Oracle 1Z0-051 Control transactions • SQL Plan Baseline Architecture What’s the 1Z0-051 passing score and duration? The duration of this exam is 120 minutes (64 questions) and the minimum passing score is 60%.
Views: 955 Oliver Oscar
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: 5334 Satish Lodam
12c SQL Performance Features Adaptive Execution Plans
 
09:12
See Oracle Database change a SQL execution plan - during execution!! See more free 12c features lessons at http://www.skillbuilders.com/free-12c-performance-features-training-2.
Views: 239 SkillBuilders
0306 The SQL Access Advisor
 
02:17
ORACLE
Views: 201 oracle ocm
How to Tune SQL when You Can't Edit the Source Code, Part 1 of 2
 
03:17
Learn Oracle SQL Tuning! How do you add a hint to SQL you can't edit? How do you tune SQL if you don't have access to the source code? Sometimes, Oracle indexes, statistics, stored outlines, profiles or 12c directives will solve a tuning problem. However, as a last resort, you may want to add a hint. In this case DBMS_ADVANCED_REWRITE can be the solution. In this tutorial, Oracle Certified Master DBA John Watson of SkillBuilders demonstrates using DBMS_ADVANCED_REWRITE to change the SQL Oracle executes - without changing the source code!
Views: 1365 SkillBuilders
How To Create Profile In Oracle
 
09:02
Hi.. Friends In This Video We Leans How To Create Profile In Oracle 11g On Windows USERNAME : tiger PROFILE NAME : tiger_profile (ALTER USER user_name PROFILE profile_name) Through Provide Profile This Particular Users.
Views: 1359 PGT POINT
Detect performance issues using PL/SQL Profiler
 
06:05
https://www.quest.com/products/toad-for-oracle/ Learn how to detect and report on a performance bottleneck in a PL/SQL program.
Views: 1666 Quest
Oracle Performance - DBMS_STATS
 
42:43
Oracle Performance - DBMS_STATS
Views: 3389 The Silent DBA
How to tune Oracle SQL with Histograms: Part 1 The Importance of Histograms
 
01:28
Histograms are essential ingredient of Tuning SQL in the Oracle Database. In Oracle 12c there are new features related to Histogram. In this part of this histogram tutorial, Oracle Certified Master John Watson describes the importance of histograms. Histograms collect essential statistics such as data skew and thus accurately predict how many rows a predicate will select. This impacts critical decisions such as join order, join method and access method.
Views: 1985 SkillBuilders
SQL Tuning with Histograms Demonstration Part 3 of 4
 
06:01
Learn how to use Oracle Histograms! Histograms are essential ingredient of Tuning SQL in the Oracle Database. In this part of the tutorial, SkillBuilders' Oracle Certified Master John Watson describes the importance of histograms. Histograms collect essential statistics such as data skew and thus accurately predict how many rows a predicate will select. This impacts critical decisions such as join order, join method and access method. See all free Oracle Database tutorials from SkillBuilders at http://www.skillbuilders.com/free-oracle-tutorials.
Views: 1001 SkillBuilders