Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

The state of Dell Toad: Oracle DBAs and how they can still benefit

Since Dell acquired Quest Software, maker of the Toad tool for Oracle databases and applications, some questions have arisen about what would happen.

The majority of Oracle database administrators (DBAs) are familiar with Toad, but don't really use it. That silent majority tends to see Toad as just an application development tool and little else. However, nothing could be further from the truth. Since Dell acquired Quest Software, Toad has become Dell Toad. And Toad Oracle includes much more than development tools. The product also incorporates database administration, database security and a plethora of other tools, all designed to make an Oracle DBA's life a little easier.

Dell is looking to stress that extra functionality to entice more developers into Dell Toad, whose primary market competitor is Oracle's own SQL Developer toolkit. What's more, Dell has extended Toad's Oracle functionality into other database systems, including products such as Toad for SQL Server, Toad for Sybase and Toad for DB2. That proves important since DBAs today often have to work with more than one database vendor, and having tool sets that are similar between database platforms can be a boon to productivity and can sharply reduce learning curves.

A closer look at Dell Toad for Oracle

Dell Toad comes in multiple versions (or editions), and the respective feature sets vary based upon which one is selected. Currently, Dell offers seven different editions of Toad, which is probably best described by Dell's own product sheet.

Serious developers and senior Oracle DBAs will most likely be interested in Toad DBA Suite for Oracle (or the more robust RAC Edition). Now in version 11.6, Toad Oracle offers additional functionality. Included with the package is a collaboration module, which allows users to share scripts, files and documents with each other. That takes place in the Toad World Repository. The repository can be directly accessed via the Dell Toad application.

With hundreds of other features, it becomes clear that Dell Toad is meant to replace multiple other products and combine and unify the management and development of enterprise-level databases. Many of the administration tools, as well as most of the development tools, are designed with speed in mind, turning what was once dozens of manual steps into a few carefully executed mouse clicks.

Perhaps one of the biggest challenges facing Dell Toad is the fact that the primary competitor, Oracle SQL Developer, is a free product. That in turn can wreak havoc with total cost of ownership calculations, making it seem that Toad Oracle is nothing more than an expensive luxury. However, there are several reasons why Toad is still a valid choice for those looking to enhance productivity and streamline application development.

First and foremost is the quality of code created by Toad's rapid application development environment. Here, Dell Toad offers code analysis, which is an automated function that can review generated code based upon rules. The advantage here is that coding rules can be applied and created code can be quickly judged to see if it falls within quality guidelines. That process can save countless debugging and analysis hours and can prevent security or other problems before they occur.

Another benefit offered by Dell Toad comes in the form of application performance -- Toad Oracle includes a comprehensive suite of tools that identifies and "tunes" PL/SQL and SQL statements using a very simple interface or a comprehensive optimization environment. That ensures development can take care of application performance issues rather than passing the buck over to DBAs.

Toad also makes it much easier to maintain code; the included Code Analysis feature ensures that coding changes are more simplified than manual tasks, offer improvements to consistency, and reduces the introduction of errors.

Perhaps one of the most important benefits offered by Toad comes in the form of collaboration. Dell Toad makes it easy to collaborate settings, database connections, templates, and code-review standards among team members. That improves code consistency, minimizes errors and enhances productivity. The team work ideology also introduces project management concepts into the development environment, resulting in more professional-looking applications and consistency in development tasks.

The benefits offered by Toad all add up to one specific element: productivity, which in turn demonstrates the value of Toad. With Toad Oracle, organizations can have more resilient applications, much faster than with SQL Developer, and those applications will prove easier to maintain and modify over time.

About the author:
Frank J. Ohlhorst is an award-winning technology journalist, professional speaker and IT business consultant with more than 25 years of experience. He served as a network administrator and applications programmer at the U.S. Department of Energy before forming his own computer consulting firm, which can be found at ohlhorst.net.

Dig Deeper on Oracle DBA tools

Join the conversation


Send me notifications when other members comment.

Please create a username to comment.

Do you use Toad for Oracle?
Familiarity, habit, and a reliable and robust set of tools.
Its ease of use to develop and maintain databases. To ensure the databases are properly performing and automating maintenance. I find Oracle tools severely lacking and the article does an excellent job of pointing this out.
Toad for Oracle is the best tool for Oracle developers and database administrators
I use it for running script from the developer and also use it for creating tables.
Everyday, from development through administration
Wonderful product! Long live Toad!
I guess everyone on the internet needs to know I'm a dog now
Been working with Toad for a decade. Love it. I'm now investigating Toad for other platforms and the new data provisioning piece called Toad Data Point. Lots of new stuff since I looked last.
Excellent as both development tool and as a utlity to aid in DBA work.
its too expensive. I first used toad back in the day when it was free and managed by the original programmer of the tool. After Quest bought it, they jacked up the price. Dell should revisit the price. I don't think Toad should be free. Just 66% less in cost.
Also, no Mac version yet? Don't know
I wish to try
Unbelievably valuable product. I would be half as productive without this tool.

Great to see that Dell is supporting forward progress.
I have it, but have really use it in my daily duties as DBA.
I have been a DBA for 17 years, and I have found that many DBA's user TOAD. I prefer it over all other tools, including Oracle Enterpise Manager Grid for daily dba tasks.
Latest 12.0 version is awsome!
too expensive , as oem and sql-developer are free
too pricey, needs to be about 1/3 of the cost
Not only do I not use TOAD, I will not recommend TOAD to anyone but the casual user. It is so far behind Oracle tools that their tuning module does not use the OWI counters. Tuning is still done using 30 year old techniques. Want it right, use Oracle tools from Oracle.