Home
Search results “Oracle adaptive cursor sharing”
Peeking on steroids: Adaptive Cursor Sharing
 
06:24
blog: https://connor-mcdonald.com twitter: https://twitter.com/connor_mc_d Bind peeking in early version of Oracle: https://youtu.be/MnISfllmK74 Issues with bind peeking: https://www.youtube.com/watch?v=ynLF6S15J5M Subscribe for new tech videos every week All other social media channels here: https://linktr.ee/connor My current favorite Oracle stuff: - Favorite 12.2 feature: Almost all structural maintenance can be done online. No more outages. https://docs.oracle.com/en/database/oracle/oracle-database/12.2/newft/new-features.html#GUID-BEEEA34D-3D81-4360-887C-A92BC711816D - Favorite 18c feature: Killing a runaway SQL without killing the entire session. https://docs.oracle.com/en/database/oracle/oracle-database/18/newft/new-features.html#GUID-49F77A8D-CF54-415C-B04F-DB4CE733C513 - Favorite 19c feature: Handling JSON just got a lot easier! https://docs.oracle.com/en/database/oracle/oracle-database/19/newft/new-features.html#GUID-9587F5B4-871B-401A-8978-BDA491F07F8A Music: Night Owl (Broke For Free) #oracle #binds #performance
Views: 472 Connor McDonald
Oracle Database 11g New Features Demo: Adaptive Cursor Sharing
 
07:23
Learn 11g new performance feature that should solve the problem of bind variables and data skew. Dave Anderson of SkillBuilders.com/Oracle.
Views: 5339 SkillBuilders
Adaptive Cursor Sharing ACS
 
01:23:00
SQL Master Training Class Carlos Sierra - Using Oracle's Adaptive Cursor (ACS) feature
Views: 1692 NoCOUG Channel
Histograms and Bind Peeking
 
20:45
Histograms and Bind Peeking watch more videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjab, Tutorials Point India Private Limited
Performance Tuning using Cursor_sharing in oracle 11gR2
 
29:24
Hello friends in my today video we learn about cursor_sharing in oracle which help in improving performance for SQL queries using literal values. #PerformanceTuning #Cursor_sharing Oracle database Unbeatable,Unbreakable Platform..
Views: 4419 Oracle World
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: 14638 OracleDBVision
A peek at bind variable peeking
 
08:27
The evolution of adaptive cursor sharing, starting with the need for the optimizer to be able to look (peek) at the value of a bind variable in order to determine the best execution plan. blog: https://connor-mcdonald.com twitter: https://twitter.com/connor_mc_d Subscribe for new tech videos every week Music: Night Owl (Broke For Free) #oracle #performance
Views: 483 Connor McDonald
12c Adaptive Optimization - Kerry Osborne
 
01:08:29
One of the most interesting new features of the Oracle Database Optimizer is the ability to recognize its own mistakes and use execution statistics to automatically improve execution plans. Oracle calls this "Adaptive Optimization" and this talk will focus on how it works. More webinars at: http://www.red-gate.com/oracle-webinars
Views: 7281 Redgate Videos
New feature of Oracle Database 11g: Adaptive Cursor Sharing
 
01:03:06
Доклад Валерия Ковальчука "New feature of Oracle Database 11g: Adaptive Cursor Sharing", сделанный на конференции для разработчиков программного обеспечения (программные продукты ORACLE) DevLabs 2014 (22 ноября 2014 г.). Валерий Ковальчук – специалист в области архитектуры ПО (Oracle) Luxoft Training: http://www.luxoft-training.ru/about/experts/vkovalchuk.html В докладе рассматриваются следующие вопросы: • история технологии Cursor Sharing; • разделение курсоров и литералы; • разделение курсоров и переменные связывания; • усовершенствования в разделении курсоров; • адаптивное разделение курсоров; • работа с адаптивным разделением курсоров. Приводятся примеры. Luxoft Training – лидер в области обучения и консалтинга по важнейшим дисциплинам Software Engineering: http://www.luxoft-training.ru/
Real-World Performance - 4 - Bind Variables and Soft Parse
 
05:10
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 bind variables and soft parsing make significant performance gains as they contribute to transaction throughput and reverse the mistakes of a poor configuration. 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.
Problems with peeking
 
05:35
Taking a closer look at the history of bind variable peeking in order to see why adaptive cursor sharing improves upon on the functionality. blog: https://connor-mcdonald.com twitter: https://twitter.com/connor_mc_d Bind peeking introduction: https://youtu.be/MnISfllmK74 Subscribe for new tech videos every week All other social media channels here: https://linktr.ee/connor My current favorite Oracle stuff: - Favorite 12.2 feature: Almost all structural maintenance can be done online. No more outages. https://docs.oracle.com/en/database/oracle/oracle-database/12.2/newft/new-features.html#GUID-BEEEA34D-3D81-4360-887C-A92BC711816D - Favorite 18c feature: Killing a runaway SQL without killing the entire session. https://docs.oracle.com/en/database/oracle/oracle-database/18/newft/new-features.html#GUID-49F77A8D-CF54-415C-B04F-DB4CE733C513 - Favorite 19c feature: Handling JSON just got a lot easier! https://docs.oracle.com/en/database/oracle/oracle-database/19/newft/new-features.html#GUID-9587F5B4-871B-401A-8978-BDA491F07F8A Music: Night Owl (Broke For Free) Sound effects: zapsplat.com #oracle #parsing #performance
Views: 313 Connor McDonald
04 02 The Shared SQL Area
 
08:18
ORACLE
Views: 117 oracle ocm
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: 1048 Athar Fahad
Cursors
 
08:33
Cursors watch more videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjab, Tutorials Point India Private Limited
Oracle 12c Dynamic Sampling
 
08:26
Learn how to improve cardinality and performance of SQL statements with Oracle Database 12c Dynamic Sampling. For you Spinal Tap fans, you can now set it to "11".
Views: 1045 SkillBuilders
Oracle 11gR2 New Features for Developers
 
01:05:01
Presented by Dan Hotka Tues 13th Mar 2012 Summary Join Oracle ACE Director Dan Hotka live online as he discusses new features of Oracle 11g for developers. This presentation is a must-see for anyone migrating to the new Oracle 11g Database. The focus of this presentation is new features that would be of interest to developers and includes: Flashback topics Database Replay SQL*Plus new commands New SQL Syntax Options Result Cache PL/SQL Enhancements including: New Compiler Options Triggers Dynamic SQL Dan is an experienced trainer and will illustrate many of the new features of the Oracle11 database that are of importance to developers. You will gain valuable insights into the many features of the latest version of Oracle 11g. A Q+A session with Dan Hotka will follow the presentation. For our complete archive, and to sign up for upcoming webinars please go to http://www.red-gate.com/oracle-webinars
Views: 7595 Redgate Videos
Real-World Performance - 5 - Shared Cursors and One Parse
 
03:39
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 shared cursors and a single parse, as well as sharing a connection pool, make an order of magnitude performance gain. 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.
Oracle Database 11g New Features: Performance Tuning with Feedback Based Optimization
 
02:19
Oracle Database 11g provides a new feature called "feedback based optimization". In this tutorial you will learn what feedback-based optimization is and how it helps Oracle Database 11g performance. One part of nine tutorials dedicated to Oracle 11g Adaptive Cursor Sharing. View all 10 videos for free at SkillBuilders.com/ACS.
Views: 4751 SkillBuilders
Real-World Performance - 1 - Cursors and Connection Intro
 
03:08
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 and introduces a demonstration application, that simulates the mistakes of a poor database and application configuration, and the specific parts of the system that create a sub-optimal configuration. The goal is to step beyond Moore's Law, and create orders of magnitude changes. 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.
Oracle 11g CBO New Features
 
09:13
Learn what's different about cost-based optimization in 11g Release 2. In this training Dave Anderson will guide you through some critical performance and SQL tuning enhancements and other surprises in the Oracle 11g cost-based optimizer. Through live demonstrations and lecture, you will learn about features such as adaptive cursor sharing, feedback-based optimization, new join techniques, DBMS_STATS enhancements, direct (PGA) reads for "large" full table scans, new hints and more. Presented at NYOUG by SkillBuilders' Founder and Oracle DBA, Dave Anderson.
Views: 6914 SkillBuilders
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: 291 SkillBuilders
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: 3667 SkillBuilders
Christian Antognini - Cursor Sharing
 
45:33
Presentation from OakTable World - http://dboptimizer.com/2012/11/08/oaktable-world-2012-all-presentations-and-4-vidoes-up/
Views: 1186 pioro1231
Real-World Performance - 6 - Leaking Cursors
 
11:34
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 leaking cursors 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
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
What is cursor in Oracle
 
04:13
What is cursor in Oracle
Adaptive Dynamic Sampling ByChris Antognini
 
53:05
Topic: Adaptive Dynamic Sampling Speaker: Chris Antognini Videos thanks to Delphix! Thank you to our sponsors: Delphix, Pythian, and Gluent.
Views: 256 Oaktable
Optimizer Adaptive Features in Oracle 12C
 
01:17:08
Die Optimizer Adaptive Features wurden mit Oracle 12.1 neu eingeführt und umfassen u.a. adaptive Pläne, SQL Plan Direktiven und sowie diverse „Re-Optimization“ Techniken. Ausgehend von den bisher gemachten Erfahrungen wurden in Version 12.2 diverse Anpassungen bzw. Verbesserungen gemacht. Diese Änderungen stehen im Mittelpunkt des Vortrages.
Views: 281 DBMasters
What is a hybrid histogram?
 
14:29
Highlights from the DBA Office Hours session. Subscribe for more highlight videos coming soon! blog: https://connor-mcdonald.com
Views: 448 Connor McDonald
Oracle Tutorial - 14 - PL SQL - 4 Implicit cursors
 
10:35
Oracle PL/SQL Query Database. Check more videos on IT courses on iAspireAcademy.org
Views: 15611 iAspireAcademy
Are my index statistics wrong?  Why does NUM_ROWS equal zero?
 
06:27
blog: connor-mcdonald.com Highlights from the April DBA Office Hours session. Office Hours is 100% free Q&A sessions held every month by Oracle experts to help you succeed with the Oracle suite of technologies. Music: Smells Like Summer - Del (Vlog Music No Copyrighted) Video Link: https://youtu.be/IrkMsqcOjGU
Views: 321 Connor McDonald
SQL Plan Management SPM
 
01:37:27
SQL Master Training Class Carlos Sierra - Using DBMS_SPM (SQL Plan Management)
Views: 4090 NoCOUG Channel
How can I speed up a query if an index cannot help?
 
08:20
blog: connor-mcdonald.com Highlights from the April DBA Office Hours session. Office Hours is 100% free Q&A sessions held every month by Oracle experts to help you succeed with the Oracle suite of technologies. Music: Smells Like Summer - Del (Vlog Music No Copyrighted) Video Link: https://youtu.be/IrkMsqcOjGU
Views: 1597 Connor McDonald
SQL Plan Management (Part 1)
 
16:56
SQL Plan Management (Part 1)
Views: 2700 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: 10364 SkillBuilders
Oracle 19C new feature LISTAGG DISTINCT
 
05:31
Oracle 19C New feature LISTAGG DISTINCT Click here to subscribe to my youtube channel http://www.youtube.com/channel/UCBt6VrxAIb5jLh9HLDcdwtQ?sub_confirmation=1 Oracle Interview questions and Answers at https://www.youtube.com/playlist?list=PLb1qVSx1k1Vr0v4wVyvT3GEuA0J0M4xBm Oracle 18C New features at https://www.youtube.com/playlist?list=PLb1qVSx1k1Vqe06V1tIBcvnslMPWX69bW Oracle 12C New features at https://www.youtube.com/playlist?list=PLb1qVSx1k1VqM1u2IHWzZIgziqejl6wx- Oracle PLSQL records and collections at https://www.youtube.com/playlist?list=PLb1qVSx1k1VpAFTXopXvAh_D3PLcTntdm
Views: 633 Siva Academy
Oracle Event 10046 Tracing the Execution
 
01:25:59
SQL Master Training Class Carlos Sierra - Using SQLT to interpret a 10046 trace file
Views: 2112 NoCOUG Channel
Oracle Database 12c - Row Limit (excerpt)
 
01:09
Learn cool new SQL features in Oracle Database 12c. See more free 12c tutorials at SkillBuilders.com/12cTutorials
Views: 38130 SkillBuilders
When Should You Use SQL Bind Variables? Always!
 
02:21
When is the right time to use Bind Variables in your SQL statements? "Pretty much all the time," says Mark Williams. Mark, a Method R evangelist with Cintra Software and Services, explains it all in this 2 Minute Tech Tip recorded at ODTUG Kscope 2018 at Walt Disney World in Orlando, Florida. https://developer.oracle.com/ https://cloud.oracle.com/en_US/tryit
Views: 683 Oracle Developers
Oracle 11g SQL Results Cache Training by SkillBuilders Dave Anderson
 
52:58
Learn how, by using the Oracle Database 11g Results Cache, you can get phenomenal performance from repeated executions of queries against large, static data. From Dave Anderson of SkillBuilders.com/Oracle.
Views: 3300 SkillBuilders
Oracle 10g PL SQL Class 4-Bind Variables
 
07:05
Website: http://javaknowledge.info Source code: http://www.trainingwithliveproject.com FB Page: https://www.facebook.com/javaknowledgeshare FB Group: https://www.facebook.com/groups/PBPTBD
Views: 472 Java Knowledge
PCTFREE / PCTUSED / FREELISTS for the novice
 
10:00
There's a lot of settings you can modify when you create a table. But which ones do you need to worry about? blog: https://connor-mcdonald.com twitter: https://twitter.com/connor_mc_d Subscribe for new tech videos every week All other social media channels here: https://linktr.ee/connor My current favorite Oracle stuff: - Favorite 12.2 feature: Almost all structural maintenance can be done online. No more outages. https://docs.oracle.com/en/database/oracle/oracle-database/12.2/newft/new-features.html#GUID-BEEEA34D-3D81-4360-887C-A92BC711816D - Favorite 18c feature: Killing a runaway SQL without killing the entire session. https://docs.oracle.com/en/database/oracle/oracle-database/18/newft/new-features.html#GUID-49F77A8D-CF54-415C-B04F-DB4CE733C513 - Favorite 19c feature: Handling JSON just got a lot easier! https://docs.oracle.com/en/database/oracle/oracle-database/19/newft/new-features.html#GUID-9587F5B4-871B-401A-8978-BDA491F07F8A Music: Night Owl (Broke For Free) #oracle #pctfree #pctused
Views: 523 Connor McDonald
Проактивная оптимизация производительности БД Oracle / Александр Макаров (РНКО (ГК ЦФТ))
 
45:34
HighLoad++ Siberia 2018 Зал «Иркутск», 25 июня, 12:00 Тезисы и презентация: http://www.highload.ru/siberia/2018/abstracts/3299 В докладе предлагается и демонстрируется простой метод выявления узких мест в работе серверной части ПО на примере БД Oracle. Применение данного метода на регулярной основе 2 раза в год позволило значительно сократить (примерно раз в 10) количество инцидентов производительности на боевой БД с ЦФТ-Ритейл банк, на которую новый функционал поставляется большими порциями каждые 2 недели. Под инцидентами производительности здесь понимается ситуация сильной деградации производительности прикладного кода (его серверной части, расположенной в БД), который в обычных условиях работает нормально. … -------- Нашли ошибку в видео? Пишите нам на [email protected]
Views: 652 HighLoad Channel
Using SQLTXPLAIN to Diagnose SQL Statements Perforning Poorly Part 1
 
01:00:01
Carlos Sierra shows how to use SQLTXPLAIN (SQLT) to diagnose poorly performing SQL statements
Views: 3874 NoCOUG Channel
Statistics Good Practices
 
57:07
SQL Master Training Class Carlos Sierra - Best Practices for Statistics
Views: 479 NoCOUG Channel
Understanding Oracle Explain Plans-Explain Plan Syntax
 
02:47
Understanding Oracle Explain Plans-Explain Plan Syntax http://www.informit.com/promotions/webcast-understanding-oracle-explain-plans-140966 Watch an excerpt from experienced trainer Dan Hotka on Explain Plan Syntax. The full webcast shows you how to work with Explain Plans, then goes into considerable detail about exactly how Oracle arrives at an Explain Plan. Dan has a thorough understanding of how the Cost-Based Optimizer works, and shares that knowledge in this presentation. You will gain valuable insights as to how Oracle processes SQL, and many tips on how to improve SQL performance. This presentation is a must-see for anyone doing SQL tuning. http://www.informit.com/promotions/webcast-understanding-oracle-explain-plans-140966
Views: 616 InformIT
Сравнительный обзор архитектуры PostgreSQL и Oracle | Виктор Егоров
 
45:25
Сравнительный обзор архитектуры PostgreSQL и Oracle | Виктор Егоров Доклад рассмотрит следующие компоненты СУБД PostgreSQL, сравнивая архитектурные решения с СУБД ORACLE: 1. Что представляет из себя экземпляр работающей базы, какие процессы присутствуют и за что они отвечают? 2. Какими структурами оперирует база? 3. Механизм отказоустойчивости. 4. MVCC механизм и возможности восстановления базы. 5. Хранение базы на физических носителях. Каждое из рассматриваемых решений будет оценено с точки зрения накопленного опыта работы в выбранных СУБД, удобства администрирования и доступных способов развития в будущем. Доклад будет интересен: пользователям PostgreSQL, т.к. позволит взглянуть на другую СУБД и её особенности; администраторам PostgreSQL, т.к. ORACLE предлагает большие административные возможности, которые могли бы быть реализованы и в Postgres; разработчикам PostgreSQL, т.к. Postgres активно развивается и этот доклад может задать новые направления развития; желающим перейти с ORACLE (или другой СУБД) на проекты с открытым исходным кодом, т.к. доклад продемонстрирует возможности открытой СУБД Postgres в сравнении с коммерческим продуктом, в котором Postgres выглядит очень достойно! Подробнее: https://pgconf.ru/2018/108306 #PGConfRu #PostgreSQL #Oracle
Views: 381 PGConf.Russia
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: 8636 Database Community
Using Global Hash Partitioned Indexes | Connor McDonald
 
02:15
Developer advocate Connor McDonald explains when and how to use global hash partitioned indexes in this 2 Minute Tech Tip. https://developer.oracle.com/ https://cloud.oracle.com/en_US/tryit
Views: 139 Oracle Developers