RE: Managing developers recommendations

From: Herring Dave - dherri <Dave.Herring_at_acxiom.com>
Date: Mon, 24 Oct 2005 08:43:37 -0500
Message-ID: <7ED53A68952D3B4C9540B4EFA5C76E36010BA4C8@CWYMSX04.Corp.Acxiom.net>

Concerning TOAD on any databases in your envs, do you run into issues with people scrolling through data? In TOAD you can enter something like 'SELECT * FROM huge_tb', then page down periodically to checkout what the data looks like. This isn't an option in more simple tools like SQL*Plus Worksheet (all that extra effort of filtering on rownum is required).

My concern is the impact on the database. From what I can tell, the PX slaves stay associated with the session indefinitely, until a new query is entered or they exit TOAD. We have QA folks you'll run queries like this on production to checkout data for QA purposes or looking into a potential problem, which causes a report of min on long running queries to constantly show their PX slaves.

How do you deal with situations like this? I'll also checkout yahoo for forums specific to TOAD but thought I'd respond to this thread to get a jump start.

Thanks.

Dave

Dave Herring, DBA
Acxiom Corporation
3333 Finley
Downers Grove, IL 60515
wk: 630.944.4762
<mailto:dherri_at_acxiom.com>

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org

[mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Yechiel Adar
> Sent: Sunday, October 16, 2005 10:43 AM
> Cc: oracle-l_at_freelists.org
> Subject: Re: Managing developers recommendations
>
> If you ask nicely, you can buy the read only version of TOAD.
> This way they can look but can not do harm.
> It is also cheaper. :-)
>
> We use TOAD for the DBA group and PlSqlDeveloper for developers.
> You can buy about 10 PlSqlDeveloper licenses for the price of one
TOAD.
> If you buy large quantities you get even better ratio.
>
> Adar Yechiel
> Rechovot, Israel
>
> Fred Smith wrote:
>
> > they will "accidentally" drop important objects left-and-right.
> --
> http://www.freelists.org/webpage/oracle-l

The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged.

If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited.

If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system.

Thank You.

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Oct 24 2005 - 08:47:59 CDT