Main Menu

Lunch 'n Learn Lectures   

Lunch 'n Learn Registration

Register for a Class

Training Topics & Outlines

  • 1 Low Price

  • Up to 15 People

  • 25 People over the web!

Training at your Desk! (sm)

  • Instructor-led training over the web!

  • Half Day Lectures

  • Hands-on Lab


Toad Unleashed Download



  Speaking Topics


Dan Hotka:

Contact us



Oracle Training made Easy


Dan specializes in Onsite, Web-based Oracle Training, and Self-Paced Training.  No need to have your staff travel...Dan can come to you with his portable computer lab!

Dan Hotka is a Training Specialist and an Oracle ACE Director who has over 37 years in the computer industry, over 31 years of experience with Oracle products.  

His experience with the Oracle RDBMS dates back to the Oracle V4.0 days.  Dan enjoys sharing his knowledge of the Oracle RDBMS.  Dan is well-published with 14 Oracle books and well over 200 printed articles.  

He is frequently published in Oracle trade journals, and regularly speaks at Oracle conferences and user groups around the world. 

New EMAIL Address!

Take note:  contact Dan now at:

The old will continue to work for a while but DO switch over to this new account.  

Thank you

 Click here to register and ask to be added to the email announcement list!

...replay and slide links are below...

Follow me on Twitter:  @DanHotka

Useful Tool: Active SQL..."Why is my App slow?"

This tool quickly answers the question of "Why is my Oracle slow".  I created this tool based on cool syntax I learned from my ACE Director connection with Oracle Corp.  

This tool displays the current executing SQL, perhaps the same SQL that is slowing your Oracle-based application.  It also displays SQL code from the Library Cache (V$SQL).  No additional Oracle licensing required.

It can show the current SQL executing along with what it is currently doing (the wait event it is currently working on).

  • Works with Oracle10+
  • Works great with Standard Edition Oracle (where OEM is not available)
  • Works great where ever your App is located
  • Works great with Cloud solutions/remote solutions/inhouse solutions
  • Includes all the cool tuning features of SQL Tuner
  • Pricing starts at $99 USD per Oracle licensing available
  • Click here for details

Class Pricing for both Onsite and Web-based courses!

I price classes more like a consulting engagement.  I don't price by the head as other training outfits do.  This creates incredible savings to you!  

My pricing is all-inclusive...which means...this price covers course guide, the lab computers, lab environment, my travel and lodging (excludes airline ticket..)...1 price that is easy to compute.  No hidden fees.  

Review my offerings...let me know how I can help.


Self-Paced Classes, with hands-on labs, by Dan Hotka

Yes, I'm a movie star!  Take the class on-line/self paced at Safari Books.

Click here to see Dan Hotka in Safari Books Online.  Free trials are available to watch most anything...take this information to your HR department!

Fall Promotions!  Use these discount codes when ordering my videos/books...receive huge discounts:

Short URL:

 (code) HOTKAVID40 to be used at InformIT Checkout for 40% off- Expires: 12/31/2016


Purchase the video:

Oracle SQL Performance Tuning for Developers Live Lessons

Oracle PL/SQL Programming Live Lessons

Oracle SQL Live Lessons

Advanced PL/SQL Tips and Techniques 

PL/SQL Fundamentals thru Advanced Topics

OBIEE Reports and Dashboards  

Toad for Oracle  

...follows the book but just chucked full of Toad tips and techniques


New Toad Book:  Toad for Oracle Unleashed - click here for more details


Lunch n Learn

No Registration...just click and learn at your lunch time!

Click here to review the recording 

Click here to review the presentation slides

Click here to review prior lectures

All lectures are 12:15pm Eastern and Central time zones.  The recordings and presentation slides will be posted shortly after each lecture.

Want an email announcement? Click here and ask to be added to the email announcement list!


Oracle ACEs and Oracle ACE Directors are known for their strong credentials as Oracle community enthusiasts and advocates, with candidates nominated by anyone in the Oracle Technology and Applications communities.

Check out the Oracle Ace community

Check out Oracle ACE Director Lewis Cunningham's Oracle ACE Cookbook!



Popular Classes:

SQL Tuning Tips and Techniques (2-days)

Advanced PL/SQL Tips and Techniques (3-days)
...special pricing when registering for both!

(both of these classes can be easily run using just the TOAD tool!)

OBIEE Reports and Dashboards for End Users (3-days)

SQL Tuning Advanced Topics (1-day)


TOAD classes, Scripting Techniques, Unix/Linux, SQL Reports, Discoverer, APEX Admin, OBIEE Admin, and more!

Ask Dan to set these up at your site.

I regularly blog on TOAD World!


Check out my latest book: Oracle SQL Tuning: A Close Look at Oracle Hints

Click here to order


last updated 4/26/2016