Re: PL/SQL Development Tool Of Choice
From: Norman Dunbar <oracle_at_dunbar-it.co.uk>
Date: Wed, 18 Jul 2012 16:47:44 +0100
Message-ID: <5006DAA0.5040606_at_dunbar-it.co.uk>
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.
> ....
Date: Wed, 18 Jul 2012 16:47:44 +0100
Message-ID: <5006DAA0.5040606_at_dunbar-it.co.uk>
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-lReceived on Wed Jul 18 2012 - 10:47:44 CDT