Re: PL/SQL Development Tool Of Choice
- From: Kellyn Pot'vin <kellyn.potvin@xxxxxxxxx>
- To: "Taylor, Chris David" <ChrisDavid.Taylor@xxxxxxxxxxxxxxx>, "'tim@xxxxxxxxxxxxxxx'" <tim@xxxxxxxxxxxxxxx>, "'oracle@xxxxxxxxxxxxxxx'" <oracle@xxxxxxxxxxxxxxx>
- Date: Wed, 18 Jul 2012 08:18:16 -0700 (PDT)
I actually traced sessions when it occurred at my last company. I did find
this to be an "out of the box" configuration and was able to lighten it up
quite a bit by changing preferences... :)
Oracle's SQL Developer wasn't as bad, it was lightest over all and PL/SQL
Developer was the best but took a big dive after the 9.x release and required
reconfiguring- big time! :)
Kellyn Pot'Vin
Senior Technical Consultant
Enkitec
DBAKevlar.com
________________________________
From: "Taylor, Chris David" <ChrisDavid.Taylor@xxxxxxxxxxxxxxx>
To: "'kellyn.potvin@xxxxxxxxx'" <kellyn.potvin@xxxxxxxxx>;
"'tim@xxxxxxxxxxxxxxx'" <tim@xxxxxxxxxxxxxxx>; "'oracle@xxxxxxxxxxxxxxx'"
<oracle@xxxxxxxxxxxxxxx>
Cc: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
Sent: Wednesday, July 18, 2012 9:14 AM
Subject: RE: PL/SQL Development Tool Of Choice
Kellyn,
Can you provide an example of where Toad does this as I'm unfamiliar with this
behavior in the way I use Toad - perfectly willing to admit that I may not have
seen it even if it is occurring.
Thanks,
Chris Taylor
"Quality is never an accident; it is always the result of intelligent effort."
-- John Ruskin (English Writer 1819-1900)
Any views and/or opinions expressed herein are my own and do not necessarily
reflect the views of Ingram Industries, its affiliates, its subsidiaries or its
employees.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Kellyn Pot'vin
Sent: Wednesday, July 18, 2012 10: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...
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
