Toad World


Dan Hotka
Follow /7 Feb 2017 at 3:51pm / Oracle Blog

Oracle 12.2 New Feature: Longer object/column names

Hi, Maybe you have wanted to use longer object names to be more descriptive. The Oracle RDBMS now supports up to 128 positions for both object and column names! The current naming length convention is 30. The other naming rules still apply such as...
271 0 /
Dan Hotka
Follow /7 Feb 2017 at 3:24pm / Oracle Blog

Oracle 12.2 In-memory New Features

I was able to attend the Oracle Open World 2016 event this past fall. Last April, I posted a nice series on In-memory, material I had gathered from Oracle PM Andy Revenes (heck of a nice guy). Here are the Oracle12.2. new features for In-Memory from...
266 0 /
Dan Hotka
Follow /6 Feb 2017 at 9:25pm / Oracle Blog

Oracle Behavior Differences Between Releases

A question came to me from a DBA friend asking about SQL differences between releases of the database. IE: behavioral differences in SQL processing. The question posed by this person was that they felt that some older SQL was not forward compatible...
473 0 /
Dan Hotka
Follow /11 Jan 2017 at 8:01pm / Oracle Blog

Toad Tips and Techniques

Toad Tips and Techniques Hi, 2017 is upon us. Toad ventures into another year! Toad can do so many things but I think people sometimes forget the little things that Toad has to offer. Let’s start with one of my favorite topics for people...
1840 0 /
Dan Hotka
Follow /3 Jan 2017 at 3:29pm / Oracle Blog

Toad Explain Plan Advanced options

I have used the Toad explain plan advanced options to show SQL bind variable content for a while. I want to show you how to get this advanced information when doing SQL tuning with Toad. When tuning SQL that contain bind variables, it is important to...
172 0 /
Dan Hotka
Follow /13 Dec 2016 at 5:09pm / Oracle Blog

Application Tuning Question Using Toad

…from the mail bag… Hi Dan, I've seen a situation several times lately that I need your interpretation of. There was a query running and I was watching it in Toad. It showed the session as ACTIVE, the wait event as...
200 0 /
Dan Hotka
Follow /13 Dec 2016 at 4:08pm / Oracle Blog

Toad Explain Plan Tip - returning actual SQL execution explain plan

If you have been in my tuning class or read my tuning blogs, I carry on at length about the importance of reviewing the explain plan with which the SQL executed, not an explain plan because you needed to have one. The explain plan button on Toad’s...
129 0 /
Dan Hotka
Follow /13 Dec 2016 at 3:59pm / Oracle Blog

Oracle 12.2 New Features for Developers - Conditional Compilation Part 2

We continue this series of blogs on New Features for Developers with some updated conditional compilation features. Oracle10 introduced conditional compilation, or the ability to compile PL/SQL lines of code depending on the database version being...
245 0 /
Dan Hotka
Follow /9 Dec 2016 at 6:46pm / Oracle Blog

Oracle Block Internals Part 6

This is the final article in our Block Internals article series. It covers a couple of other issues you could have with long-running transactions. This article also covers how direct path loading works. Direct path loading doesn’t create a problem...
414 0 /
Dan Hotka
Follow /31 Oct 2016 at 3:15pm / Oracle Blog

Webinar Followup

Hi, This blog contains some questions about material I covered in the recent SQL Performance Tuning webinars I did for Toad World. IF you have questions about Oracle, PL/SQL, performance tuning…funnel them to me at . I’ll...
246 0 /