Oracle Explain Plan content including Plan_Table setup, SQL*Plus and bind variables, and newer DBMS_XPLAN syntax.
Views: 3112 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
Finding Problem SQL in your Oracle Database
Views: 152 Dan Hotka
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: 840 Dan Hotka
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: 357 Dan Hotka
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: 555 Dan Hotka
How to use my FREE Oracle SQL Tuning Tool
Views: 48 Dan Hotka
Oracle SQL Developer Setup and other Tips
Views: 66 Dan Hotka
Oracle12 Approx Count Syntax
Views: 51 Dan Hotka
SQL*Plus scripting techniques include error handling and a tablespace code snippet useful for application install type scrips.
Views: 22 Dan Hotka
Oracle SQL Creating SQL Examples
Views: 32 Dan Hotka
SQL Developer building a Master Detail Browser
Views: 29 Dan Hotka
Oracle SQL*Plus mixed with PL/SQL (a 3-up Labels program) and some SQL creating SQL techniques
Views: 50 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: 149 Dan Hotka
Advanced Oracle Explain Plan Content
Views: 120 Dan Hotka