RE: PL/SQL Development Tool Of Choice

I would recommend DataPro

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Kellyn Pot'vin
Sent: Wednesday, July 18, 2012 8:12 AM
To: tim@xxxxxxxxxxxxxxx; oracle@xxxxxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: PL/SQL Development Tool Of Choice

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...
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l

Other related posts: