Home
Videos uploaded by user “Dan Hotka”
Lunch n Learn   Important Oracle Wait Events
 
09:56
Oracle Wait Events DB File Scattered Read and DB FIle Sequential Read...tips and techniques...
Views: 4306 Dan Hotka
2014 11 03 12 15 Oracle Lunch n Learn Explain Plan Syntax
 
19:27
Oracle Explain Plan content including Plan_Table setup, SQL*Plus and bind variables, and newer DBMS_XPLAN syntax.
Views: 3019 Dan Hotka
2014 11 10 12 15 Oracle Lunch N Learn with Dan Hotka
 
21:23
Oracle SQL Tuning Architecture. Dan reviews how Oracle RDBMS processes a SQL statement. He covers library management, result cache/deterministic, SQL Directives, and Adaptive Cursor Management.
Views: 141 Dan Hotka
Oracle SQL Performace Issues Review by Dan Hotka
 
22:46
Dan reviews common SQL performance issues along with some problem SQL...he has many tips for solving the issues.
Views: 252 Dan Hotka
Dan drives the Model T
 
02:33
Dan drives several of the Model T cars at the WAAAM Air and Car Museum in Hood River, OR in July 2017
Views: 61 Dan Hotka
2014 11 17 12 15 Oracle Lunch N Learn by Dan Hotka
 
15:09
Oracle Permutations and Query Transformation presentation. This is part of my SQL Tuning class...check out outlines on www.DanHotka.com
Views: 86 Dan Hotka
Oracle Internals  A Close Look at the CBO Trace
 
31:15
Oracle 10053 Trace, Cost-based Optimizer Trace Review
Views: 725 Dan Hotka
2015 01 12 11 15 TOAD Tips for Developers
 
17:20
TOAD Code Analysis tips and techniques
Views: 73 Dan Hotka
Rev up your Oracle Functions using Result Cache
 
11:56
Dan shows you how to dramatically increase function response time using a newer Oracle memory structure called Result Cache. Still on Oracle10? Dan has a solution for you as well.
Views: 113 Dan Hotka
2016 02 15 13 17 Dan Hotka Lunch n Learn  Advanced Explain Plan Content
 
25:05
Advanced Oracle Explain Plan Content
Views: 112 Dan Hotka
2015 02 02 11 15 Oracle Lunch  n Learn by Dan Hotka
 
08:43
Oracle12 Approx Count Syntax
Views: 51 Dan Hotka
Oracle OBIEE Using Key Performance Indicators (KPI s)
 
22:29
This video gives details on how to get Oracle's pre-setup OBIEE environment and does a nice walk thru of buiding and using KPI's.
Views: 307 Dan Hotka
TOAD Setup Options
 
20:28
Dan Hotka (www.DanHotka.com) covers part of his TOAD class in this video...on TOAD Setup Options.
Views: 183 Dan Hotka
2015 05 04 11 19 Oracle Wait Events   The Good Bad Ugly
 
12:24
May is Oracle Wait Events Month. This video covers the background and basics of what Oracle Wait Events are. I also cover how to get more information
Views: 790 Dan Hotka
Oracle Explain Plan Content
 
14:31
Dan goes thru some of the items you will find in an Explain Plan, what it means, and what you can do to improve it. This is one of Dan's Free Lunch 'n Learn Monday short webinars...sign up for these ad www.DanHotka.com
Views: 716 Dan Hotka
2016 01 19 11 17 Lunch n Learn  Finding Problem SQL  Why is my Oracle System slow
 
21:16
Finding Problem SQL in your Oracle Database
Views: 129 Dan Hotka
Oracle Scripting Contiued
 
09:40
Oracle Scripting continued. Dan shows a practical use for SQL*Plus variables...
Views: 139 Dan Hotka
2015 01 26 11 17 Lunch N Learn   Free Explain Plan Tool
 
18:07
How to use my FREE Oracle SQL Tuning Tool
Views: 45 Dan Hotka
2015 01 19 11 15 Lunch n Learn   SQL Developer Topic
 
14:47
SQL Developer building a Master Detail Browser
Views: 30 Dan Hotka
2015 03 02 11 17 Oracle Scripting Tips and Techniques
 
14:02
An introduction to Oracle scripting tips and techniques. I cover a pivot table in SQL*Plus...formatting the output nicely. I also cover a simple script that populates and uses the contents of a variable.
Views: 547 Dan Hotka
2015 03 23 11 18 Lunch N Learn Scripting Month Continues
 
13:06
SQL*Plus scripting techniques include error handling and a tablespace code snippet useful for application install type scrips.
Views: 22 Dan Hotka
DanHotka LunchnLearn Oracle12 1 0 2 New Features
 
08:43
This video is on Oracle12.1.0.2 New Features primarily covering new PDB syntax and options, 2 new Indexing Features, and important Procedure/Function permissions.
Views: 53 Dan Hotka
Dan SteamEngine WMV5
 
02:07
Dan driving Engine 40 at Ely, Nevada with their 'Be the Engineer' program.
Views: 48 Dan Hotka
2015 04 06 11 18 Oracle Lunch n Learn by Dan Hotka
 
09:39
Oracle SQL Creating SQL Examples
Views: 30 Dan Hotka
2015 03 30 11 18 Oracle Scripting Tips and Techniques
 
13:28
Oracle SQL*Plus mixed with PL/SQL (a 3-up Labels program) and some SQL creating SQL techniques
Views: 51 Dan Hotka
2016 03 07 11 16 Dan Hotka Lunch n Learn
 
13:47
Oracle12 Navigating the Plugable Database Environment
Views: 87 Dan Hotka
2014 10 27 12 18 SQL Developer Lunch n Learn 12 15pm
 
15:53
Oracle SQL Developer Setup and other Tips
Views: 66 Dan Hotka