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