Re: PL/SQL Development Tool Of Choice
Date: Wed, 18 Jul 2012 09:36:13 -0700 (PDT)
Message-ID: <1342629373.90229.YahooMailNeo_at_web121005.mail.ne1.yahoo.com>
Nope, not at all... how do you think Jeff Smith and I started talking a couple years back? I believe he thought it was funny that I didn't use TOAD and asked me why, so I told him... :P
Kellyn Pot'Vin
Senior Technical Consultant
Enkitec
DBAKevlar.com
From: Norman Dunbar <oracle_at_dunbar-it.co.uk> To: oracle-l_at_freelists.org
Sent: Wednesday, July 18, 2012 9:47 AM
Subject: Re: PL/SQL Development Tool Of Choice
On 18/07/12 16:11, Kellyn Pot'vin wrote:
> 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.
> ....
I've forwarded a copy of Kellyn's email to the Toad Developers for comment. Hope you don't mind. Knowing them, if there is a problem, they will fix it PDQ.
Cheers,
Norm.
-- Norman Dunbar Dunbar IT Consultants Ltd Registered address: Thorpe House 61 Richardshaw Lane Pudsey West Yorkshire United Kingdom LS28 7EL Company Number: 05132767 -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Wed Jul 18 2012 - 11:36:13 CDT