Published
Oracle Database SQL Tuning tutorial. Learn what direct and indirect reads are and what impact they have on tuning SQL in Oracle Database.
In this free tutorial from www.SkillBuilders.com, Oracle Master DBA John Watson will explain and demonstrate what direct / indirect reads are, pros and cons, why they can cause instability in the performance of your SQL (unpredictable response time), why stored outlines, SQL plan baselines and hints usually don't help.
Perhaps most importantly, John will tell you what you can do about it.
Intended Audience: Experience Oracle DBA's, developers and anyone with Oracle SQL tuning experience.
In this free tutorial from www.SkillBuilders.com, Oracle Master DBA John Watson will explain and demonstrate what direct / indirect reads are, pros and cons, why they can cause instability in the performance of your SQL (unpredictable response time), why stored outlines, SQL plan baselines and hints usually don't help.
Perhaps most importantly, John will tell you what you can do about it.
Intended Audience: Experience Oracle DBA's, developers and anyone with Oracle SQL tuning experience.
- Category
- Success
Sign in or sign up to post comments.
Be the first to comment
Up Next
Autoplay
-
00:54
Oracle Database SQL Tuning with Constraints - Lesson 1 of 5
-
02:43
Four Steps to Oracle SQL Tuning - A Methodolgy
-
11:49
How to Tune Oracle Data Guard 12c - Tuning, Upgrade, and Migration
-
11:49
How to Tune Oracle Data Guard 12c - Tuning, Upgrade, and Migration
-
00:40
Grilling with Direct Versus Indirect Heat - CHOW Tip
-
08:20
Oracle SQL Tuning - Explain Plan Lies?
-
03:02
Oracle SQL Tuning with Foreign Key Constraints
-
13:26
Oracle Database In-Memory: State of the Database Discussion
-
15:37
SQL Tuning with Oracle Database 12c - Re-Optimizing Execution Plans
-
09:47
Oracle Instance Recovery Tutorial - Module 5 - Demo - What Oracle Database does when DML is Executed
-
06:47
Running Oracle Database on Oracle Linux on Oracle x86
-
27:26
SQL Tuning for Beginners Part 1 - Tuning Methodology and Basic Optimization Concepts
-
14:05
Oracle Autonomous Database – Put Your Database on Autopilot
-
31:23
Oracle Database In-Memory: Database Innovation Panel
-
12:29
Oracle Database 12c Security - Session 3 - Review Oracle Virtual Private Database
-
11:11
Database Industry Experts Discuss Oracle Database In-Memory
-
13:39
Oracle SQL Tuning - Oracle Execution Plans for Beginners
-
02:28
Oracle SQL Tuning with Unique Constraints
-
09:20
SQL Tuning with Oracle Database 12c Histograms
-
01:54
Oracle Instance Recovery Tutorial - Module 13 - Oracle - The Incorruptible Database
-
02:28
Oracle SQL Tuning with NOT NULL Constraints
-
05:28
Database-level Storage Analytics for Oracle Database 12c
