Re: PL/SQL Development Tool Of Choice
- From: Norman Dunbar <oracle@xxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 18 Jul 2012 16:47:44 +0100
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
--
//www.freelists.org/webpage/oracle-l
Other related posts: