Re: PL/SQL Development Tool Of Choice
- From: Kellyn Pot'vin <kellyn.potvin@xxxxxxxxx>
- To: "tim@xxxxxxxxxxxxxxx" <tim@xxxxxxxxxxxxxxx>, "oracle@xxxxxxxxxxxxxxx" <oracle@xxxxxxxxxxxxxxx>
- Date: Wed, 18 Jul 2012 08:11:41 -0700 (PDT)
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
Enkitec
DBAKevlar.com
________________________________
From: Tim Hall <tim@xxxxxxxxxxxxxxx>
To: oracle@xxxxxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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. :)
Cheers
Tim...
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
