Re: PL/SQL Development Tool Of Choice

From: Kellyn Pot'vin <>
Date: Wed, 18 Jul 2012 08:11:41 -0700 (PDT)
Message-ID: <>

Now I have to say, and this goes for most tools, that when I stated I would like to see TOAD go on a diet, I meant all the extra calls it makes to provide the user every piece of data at their fingertips, even when all they want is one, small bit of information. Let's say a developer is in TOAD and wants to see the name of table 'XYZ'.  When they click on it, TOAD also gathers for them, (just in case) all the column information, size information, extents, dependencies, partitions, constraints, etc.  This kind of added querying has a cost overall to the performance of the data dictionary and to a performance tuning DBA, if I start seeing waits on my TAB$, ICOL$, SEG$, IND$, etc. tables, then I'm going to want to know why this has started. 

If upon research, I find it's because I have 25+ users with TOAD, having it implemented as the user interface for AdHoc queries, then I'm not going to be as much a fan of it vs. if a DBA is utilizing it to do their day to day job. 

I just find that it needs a few different working modes is all-  Only go to the database when it needs to... :)

Kellyn Pot'Vin
Senior Technical Consultant

 From: Tim Hall <> To:
Sent: Wednesday, July 18, 2012 7:36 AM
Subject: Re: PL/SQL Development Tool Of Choice  

I don't have a problem with any company making money out of a product. I paid for a multi-platform unlimited upgrades license for UltraEdit because I like the product and it does what I need. I think there is room for open and closed products.

My point is TOAD is a money earner for Quest, yet they've done little to make it a better product over the years. New versions come out and they keep adding features (bloat), but it seems nobody has invested any time in the user experience, which is terrible. Actually, terrible is being incredibly kind. It was a horrible product when I first used it (before Quest bought it) and it still is.

Oracle were very lazy in this respect for many years, but now they are investing heavily in improving the user experience throughout there products. Check out their UX labs etc.

TOAD is like crack for PL/SQL developers. They need to go cold turkey and they will find out life is much better without it. They might just learn a little about databases also.

Just my opinion. Everyone is entitled to their opinion and I'm happy for people to disagree. :)


-- Received on Wed Jul 18 2012 - 10:11:41 CDT

Original text of this message