Re: PL/SQL Development Tool Of Choice
Date: Wed, 18 Jul 2012 08:18:16 -0700 (PDT)
Message-ID: <1342624696.27687.YahooMailNeo_at_web121003.mail.ne1.yahoo.com>
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_at_ingrambarge.com> To: "'kellyn.potvin_at_ymail.com'" <kellyn.potvin_at_ymail.com>; "'tim_at_oracle-base.com'" <tim_at_oracle-base.com>; "'oracle_at_dunbar-it.co.uk'" <oracle_at_dunbar-it.co.uk> Cc: "'oracle-l_at_freelists.org'" <oracle-l_at_freelists.org> 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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Kellyn Pot'vin
Sent: Wednesday, July 18, 2012 10:12 AM
To: tim_at_oracle-base.com; oracle_at_dunbar-it.co.uk
Cc: oracle-l_at_freelists.org
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_at_oracle-base.com>
To: oracle_at_dunbar-it.co.uk
Cc: oracle-l_at_freelists.org
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
Received on Wed Jul 18 2012 - 10:18:16 CDT