From oracle-l-bounce@freelists.org Mon Oct 24 08:47:59 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j9ODlxmP010762 for ; Mon, 24 Oct 2005 08:47:59 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j9ODlnvX010731 for ; Mon, 24 Oct 2005 08:47:49 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 45B3120CE88; Mon, 24 Oct 2005 08:45:48 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 05554-07; Mon, 24 Oct 2005 08:45:48 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C2F3120CE6F; Mon, 24 Oct 2005 08:45:47 -0500 (EST) X-IronPort-AV: i="3.97,245,1125896400"; d="scan'208"; a="52287363:sNHT23193443" X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Subject: RE: Managing developers recommendations Date: Mon, 24 Oct 2005 08:43:37 -0500 Message-ID: <7ED53A68952D3B4C9540B4EFA5C76E36010BA4C8@CWYMSX04.Corp.Acxiom.net> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Managing developers recommendations Thread-Index: AcXSYAt75/CaO81NQhGqv++UHZpcewGP/Oaw From: "Herring Dave - dherri" To: Cc: X-OriginalArrivalTime: 24 Oct 2005 13:43:51.0724 (UTC) FILETIME=[F802FEC0:01C5D8A0] Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis Content-Type: text/plain; charset="us-ascii" X-archive-position: 27417 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Dave.Herring@acxiom.com Precedence: normal Reply-To: Dave.Herring@acxiom.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-3.5 required=5.0 tests=AWL,BAYES_00 autolearn=ham version=2.63 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 ------------------------------------- > -----Original Message----- > From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] > On Behalf Of Yechiel Adar > Sent: Sunday, October 16, 2005 10:43 AM > Cc: oracle-l@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