Home
Search results “Oracle peeked binds”
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
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: 449 Connor McDonald
Oracle PL/SQL - Bind Variables
 
12:26
http://plsqlzerotopro.com This tutorial explains the use of PL/SQL Bind Variables. Bind Variables are important tool for taking input from users.
Views: 25969 HandsonERP
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: 400 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: 5301 SkillBuilders
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: 296 Connor McDonald
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: 4290 Oracle World
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
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: 64 slide show me
Histograms Pre-12c and now
 
43:45
Anju Garg is an Oracle Ace Associate with over 12 years of experience in IT Industry in various roles. Since 2010, she has been involved in teaching and has trained more than a hundred DBAs from across the world in various core DBA technologies like RAC, Data guard, Performance Tuning, SQL statement tuning, Database Administration etc. She is a regular speaker at Sangam and OTNYathra.  She also writes articles for All Things Oracle. She is passionate about learning and has keen interest in RAC and Performance Tuning. She shares her knowledge via her technical blog at http://oracleinaction.com/ ABSTRACT--- To improve optimizer estimates in case of skewed data distribution , histograms can be created. Prior to 12c frequency and height balanced histograms could be created.  if no. of buckets >= NDV, frequency histogram is created and the optimizer makes correct estimates. If no. of buckets < NDV, height balanced histogram is created and accuracy of optimizer estimates depends on whether a key value is an endpoint or not. The problem of optimizer misestimates in case of height balanced histograms is resolved to a large extent in Oracle Database 12c by introducing top-frequency and hybrid histograms which are created if no. of buckets < NDV. This webinar explores Pre as well post 12c histograms while highlighting the top-frequency and hybrid histograms introduced in Oracle Database 12c.
Oracle Performance - DBMS_STATS
 
42:43
Oracle Performance - DBMS_STATS
Views: 5018 The Silent DBA
AskTOM TV - The TOP-FREQUENCY histogram in 12c
 
10:01
blog: https://connor-mcdonald.com A video to help you understand the "thought process" behind answering AskTom questions. In this episode, how does the optimizer deal with the 12c in-database archiving feature ========================================­­­­============== 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: 753 Connor McDonald
Oracle X$TRACE, Wait Event Internals and Background Process Communication
 
01:48:41
In this session we will look into some internals of Oracle background process communication and also some special types of wait events that most people aren’t aware of. We will use some exotic tracing for internals research and fun and some of this stuff is actually useful in real life too! I’m not going to reveal everything upfront, as this is a secret internals hacking session after all ;-) We will use various techniques to research what the “reliable message” wait event is about and how reliable background process communication is orchestrated in Oracle. This is a hacking session, not formal structured training, so I’ll just do free form demos and talk (probably no slides, just hacking stuff on the command line). Also, check out my full-week Advanced Oracle Troubleshooting online training at https://blog.tanelpoder.com/seminar
Views: 3529 Tanel Poder
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: 425 Connor McDonald
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: 14631 SkillBuilders
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: 313 Connor McDonald
Oracle Database 12c: Enhanced Optimizer Statistics with Tom Kyte
 
09:11
Tom Kyte discusses enhanced optimizer statistics followed by a demo of on-load statistics gathering in Oracle Database 12c. "Online Statistics Gathering for Bulk Loads" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=TGSQL344 "Histograms" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=TGSQL366 "CREATE TABLE ... AS SELECT" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=DWHSG8317 "CREATE TABLE" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=SQLRF01402
Views: 8438 OracleDBVision
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/
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: 3862 SkillBuilders
How to Stabilize Performance with Oracle 12c Baselines Part 1
 
02:38
Learn how Baselines prevent performance from degrading when changes happen in your Oracle Databases. See Part 2 at http://skillbuilders.com/oracle-12c-baselines-tutorial
Views: 814 SkillBuilders
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: 254 DBMasters
Tracing SQL execution
 
23:16
Tracing SQL execution watch more videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjab, Tutorials Point India Private Limited
May 2019, Pisces: Release the Inner Victim
 
16:55
I hope this offering serves you. For personalized services, please visit www.rosegoldocean.com Keep in Touch! [email protected] Personal IG with Cosmic Updates: @rosegoldocean Cosmic Updates on FB: www.facebook.com/rosegoldocean Podcast: https://soundcloud.com/user-576010818 Tips are appreciated! http://paypal.me/rosegoldviviane $rosegoldocean venmo: @rosegoldocean
Views: 40 rosegoldocean
Local Vs Global Partitioned Index in Oracle 11g
 
17:30
The Video Explains the difference between Local Partitioned Indexes(Prefixed vs Non Prefixed Indexes). and Global Partitioned Index along with the challenges in maintaining Global partitioned Indexes when the underlying tables partitioned is dropped/truncated/Merged/Moved. Local Partitioned Index Shares the same boundaries as the table and are in the same number as table partitions they are widely used in DSS and DWH systems. While Global Partitioned Index are predominantly used in OLTP systems
Views: 8872 Tech Coach
smtp_out_server and sending mail from the database
 
08:47
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 #smtp #utl_mail #oracle Music: Night Owl (Broke For Free) #oracle #sql #performance
Views: 337 Connor McDonald
List partitioning in Oracle : Part 3
 
23:37
This video explains list partitioning in detail with 2 real project examples. I recommend watching these 2 videos on partitioning prior to watching the current one. 1. https://www.youtube.com/watch?v=m3q4lrE671Y&t=25s 2. https://www.youtube.com/watch?v=OQ8LXbxLI5g&t=1312s
Views: 7137 Tech Coach
Should you need a license to be a DBA or Developer?
 
09:12
You need a license to drive, because screwing up is potentially very dangerous. But the same applies for your database and applications. Should you be certified for them? blog: https://connor-mcdonald.com twitter: https://twitter.com/connor_mc_d Subscribe for new tech videos every week Alex Zaballa: http://alexzaballa.blogspot.com/ Oracle certification: https://education.oracle.com/certification OCM (Oracle Certified Master): https://blogs.oracle.com/certification/three-reasons-becoming-an-oracle-certified-master-should-be-on-your-radar My first RAC book: https://www.apress.com/gp/book/9781430229582 Music: Night Owl (Broke For Free) Kevin MacLeod (incomptech) #oracle #dba #certification
Views: 291 Connor McDonald
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
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: 284 SkillBuilders
Oracle Histograms Example
 
03:40
An excerpt from "Oracle SQL Tuning Video Tutorial" topic "Oracle Histograms in Oracle 12c" +91 991 2323 000 [email protected] Oracle SQL Tuning Video Tutorial https://dbvidya.talentlms.com/catalog/info/id:125 Oracle DBA Performance Tuning https://dbvidya.talentlms.com/catalog/info/id:128 Dimensional Modeling Video Tutorial https://dbvidya.talentlms.com/catalog/info/id:131 Erwin Tool Training Video Tutorial https://dbvidya.talentlms.com/catalog/info/id:130 Oracle SQL Performance Tuning Training Online : http://www.dbvidya.com/course/sql-tuning-advanced/ http://www.dbvidya.com/course/performance-tuning-for-dba/ Oracle Performance Tuning Online Training : http://www.dbvidya.com/course/perform... http://www.dbvidya.com/course/dimensional-modeling/ Oracle Performance Tuning Videos Tutorial for DBA and Developers : http://www.dbvidya.com/oracle-perform... Oracle AWR Tutorial: http://www.dbvidya.com/course/oracle-... Erwin Tool Online Training : http://www.dbvidya.com/course/erwin-t... ER Data Modeling Course : http://www.dbvidya.com/course/er-mode... Dimensional Modeling Training Online : http://www.dbvidya.com/course/dimensi... Oracle Database Blogs : http://www.dbvidya.com/blog/
Views: 94 DbVidya
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
Adaptive Cursor Sharing ACS
 
01:23:00
SQL Master Training Class Carlos Sierra - Using Oracle's Adaptive Cursor (ACS) feature
Views: 1676 NoCOUG Channel
DDBoost 2.1 plugin for Oracle RMAN upgrade on AIX platform
 
10:49
DDBoost 2.1 plugin install
Views: 233 Will L
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: 1015 SkillBuilders
ORACLE WORLD - Understanding Oracle Optimizer Statistics part-2nd
 
10:09
Hello friends in this video i'm just showing to you what is optimizer statistics into oracle,optimizer help to improve the performance of sql statements during execution period. #ORACLEWORLD #OptimizerStatistics Oracle database Unbeatable,Unbreakable Platform.
Views: 2413 Oracle World
Oracle Cloud Story (by PVG)
 
24:30
Rehearsing to create a video about the "Oracle Cloud Story"...
Views: 121 Pablo V. Gomez
How to Generate "buffer busy waits" Wait Events
 
02:14
Video designed for my March 2016 blog post. See https://community.oracle.com/blogs/dearDBA/
Views: 273 fd4242
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: 2344 SkillBuilders
AskTOM Office Hours: Lockdown Profiles in Multitenant
 
36:59
On May 8 2018, Can Tuzla, Senior PM for Multitenant covered a new isolation concept introduced in 12.2, called Lockdown Profiles. He reviewed isolation practices since 12.1 and explained the benefits of Lockdown Profiles with various use cases. 03:24 What is a lockdown profile? 10:27 Capabilities enabled by lockdown profiles 21:10 A working example 25:37 Q&A begins AskTOM Office Hours offers free, monthly training and tips on how to make the most of Oracle Database, from Oracle product managers, developers and evangelists. https://asktom.oracle.com/ Oracle Developers portal: https://developer.oracle.com/ Sign up for an Oracle Cloud trial: https://cloud.oracle.com/en_US/tryit music: bensound.com
Views: 85 Oracle Developers
If tfue was crouch peeking on console it would look like this! - Fortnite battle royale highlights
 
04:05
If you enjoyed the video please like, subscribe and turn on post notification so you never miss a new video! SHAREfactory™ https://store.playstation.com/#!/en-il/tid=CUSA00572_00
Views: 103 Rockenrules
DB Optimizer - Karen Morton
 
07:49
Karen Morton, Oracle ACE and performance tuning specialist, describes her experience using DB Optimizer at Fidelity Information Services (FIS). DB Optimizer has helped Karen discover problems that were previously undetected by native tools.
Complex Group By Query
 
03:52
A more complex example with two queries, one using HAVING and one using a SubQuery to join back to the main table as a Corelated Quer
Views: 263 Hemant K Chitale
SnapCenter- Clone DEV/TEST to AWS Cloud for an Oracle database
 
04:01
This video shows how to use SnapCenter to quickly and space efficiently clone an oracle production database to an alternate host running in a public cloud (AWS, Azure) or a private cloud. Want to learn more? Visit the SnapCenter Resources page: https://mysupport.netapp.com/snapcenter/resources
Views: 622 NetApp TechComm TV
Managing Skewed Data
 
07:44
This video shows how to troubleshoot performance issues with skewed data when using parallel processing. Copyright © 2012 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.
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: 1164 SkillBuilders
Configuring Approval Policies in Oracle Enterprise Data Management Cloud
 
06:23
In this tutorial, you learn how to configure approval policies to govern data changes in Oracle Enterprise Data Management Cloud.
Indexes Overview and B Tree Index
 
38:05
Indexes Overview and B Tree Index watch more videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjab, Tutorials Point India Private Limited
SQL Tuning with Histograms Wrap-Up Part 4 of 4
 
01:13
Learn how to tune SQL with Oracle Histograms! In this part of the tutorial, SkillBuilders' Oracle Certified Master John Watson wraps up the points made and provides conclusions and advice - not to be missed! Watch all lesson, FREE, at http://www.skillbuilders.com/How-to-Tune-Oracle-12c-SQL-with-Histograms.
Views: 587 SkillBuilders