Videos uploaded by user “Dan Hotka”
Lunch n Learn   Important Oracle Wait Events
Oracle Wait Events DB File Scattered Read and DB FIle Sequential Read...tips and techniques...
Views: 5168 Dan Hotka
2014 11 03 12 15 Oracle Lunch n Learn Explain Plan Syntax
Oracle Explain Plan content including Plan_Table setup, SQL*Plus and bind variables, and newer DBMS_XPLAN syntax.
Views: 3124 Dan Hotka
Oracle SQL Performace Issues Review by Dan Hotka
Dan reviews common SQL performance issues along with some problem SQL...he has many tips for solving the issues.
Views: 284 Dan Hotka
Oracle Explain Plan Content
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: 749 Dan Hotka
Oracle Internals  A Close Look at the CBO Trace
Oracle 10053 Trace, Cost-based Optimizer Trace Review
Views: 832 Dan Hotka
2016 01 19 11 17 Lunch n Learn  Finding Problem SQL  Why is my Oracle System slow
Finding Problem SQL in your Oracle Database
Views: 154 Dan Hotka
2015 03 02 11 17 Oracle Scripting Tips and Techniques
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: 568 Dan Hotka
2014 11 17 12 15 Oracle Lunch N Learn by Dan Hotka
Oracle Permutations and Query Transformation presentation. This is part of my SQL Tuning class...check out outlines on www.DanHotka.com
Views: 94 Dan Hotka
TOAD Setup Options
Dan Hotka (www.DanHotka.com) covers part of his TOAD class in this video...on TOAD Setup Options.
Views: 543 Dan Hotka
Rev up your Oracle Functions using Result Cache
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: 125 Dan Hotka
2015 05 04 11 19 Oracle Wait Events   The Good Bad Ugly
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: 864 Dan Hotka
Oracle OBIEE Using Key Performance Indicators (KPI s)
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: 397 Dan Hotka
2014 11 10 12 15 Oracle Lunch N Learn with Dan Hotka
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: 152 Dan Hotka
Dan drives the Model T
Dan drives several of the Model T cars at the WAAAM Air and Car Museum in Hood River, OR in July 2017
Views: 69 Dan Hotka
2016 02 15 13 17 Dan Hotka Lunch n Learn  Advanced Explain Plan Content
Advanced Oracle Explain Plan Content
Views: 123 Dan Hotka
2015 01 26 11 17 Lunch N Learn   Free Explain Plan Tool
How to use my FREE Oracle SQL Tuning Tool
Views: 49 Dan Hotka
2015 01 12 11 15 TOAD Tips for Developers
TOAD Code Analysis tips and techniques
Views: 79 Dan Hotka
DanHotka LunchnLearn Oracle12 1 0 2 New Features
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: 71 Dan Hotka
2014 10 27 12 18 SQL Developer Lunch n Learn 12 15pm
Oracle SQL Developer Setup and other Tips
Views: 66 Dan Hotka
Dan SteamEngine WMV5
Dan driving Engine 40 at Ely, Nevada with their 'Be the Engineer' program.
Views: 54 Dan Hotka
2015 02 02 11 15 Oracle Lunch  n Learn by Dan Hotka
Oracle12 Approx Count Syntax
Views: 51 Dan Hotka
2015 03 23 11 18 Lunch N Learn Scripting Month Continues
SQL*Plus scripting techniques include error handling and a tablespace code snippet useful for application install type scrips.
Views: 22 Dan Hotka
2015 04 06 11 18 Oracle Lunch n Learn by Dan Hotka
Oracle SQL Creating SQL Examples
Views: 33 Dan Hotka
2015 01 19 11 15 Lunch n Learn   SQL Developer Topic
SQL Developer building a Master Detail Browser
Views: 29 Dan Hotka
2015 03 30 11 18 Oracle Scripting Tips and Techniques
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
Oracle12 Navigating the Plugable Database Environment
Views: 97 Dan Hotka
Oracle Scripting Contiued
Oracle Scripting continued. Dan shows a practical use for SQL*Plus variables...
Views: 175 Dan Hotka