| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RE: Frustration with Toad Debugger
It's "just development" but in a cost-conscious company, developers
sitting on their hands because the development database is hosed is
wasted money. Development to me is only a half-step down from
production. It needs to be backed up and recoverable nonetheless.
-----Original Message-----
From: ryan.gaffuri_at_cox.net [mailto:ryan.gaffuri_at_cox.net]
Sent: Wednesday, February 25, 2004 7:48 AM
To: oracle-l_at_freelists.org
Subject: RE: RE: Frustration with Toad Debugger
its just development. i guess it depends on the nature of the developer. We dont let the software engineers have any privileges, but the database developers can do just about everything in development.
>
> From: "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk>
> Date: 2004/02/24 Tue PM 04:47:34 EST
> To: <oracle-l_at_freelists.org>
> Subject: RE: RE: Frustration with Toad Debugger
>
> apologies for the double post - one should make it without all them
fancy equalities.
>
> SQL> create spfile from pfile;
> File created.
> SQL> create user dev identified by dont_trust_em;
> User created.
> SQL> grant create session,alter system to dev;
> Grant succeeded.
> SQL> startup force;
> ORACLE instance started.
> Total System Global Area 122755896 bytes
> Fixed Size 453432 bytes
> Variable Size 88080384 bytes
> Database Buffers 33554432 bytes
> Redo Buffers 667648 bytes
> Database mounted.
> Database opened.
> SQL> conn dev/dont_trust_em
> Connected.
> SQL> alter system set sql_trace=true scope=spfile;
> System altered.
> SQL> alter system set timed_statistics=false;
> System altered.
> SQL> alter system set db_cache_size=20m;
> System altered.
> SQL>
>
> need I go on...
>
> Niall
>
> -----Original Message-----
> From: AC.GWIA.oracle-l_at_freelists.org
[mailto:AC.GWIA.oracle-l_at_freelists.org]
> Sent: Tue 24/02/2004 18:57
> To: oracle-l_at_freelists.org; ryan.gaffuri_at_cox.net
> Cc:
> Subject: RE: RE: Frustration with Toad Debugger
>
>
>
> in development? that is silly. there is no reason why a developer
shouldnt be
> able to kill his own session.
>
> >
> > From: "Koivu, Lisa" <Lisa.Koivu_at_Cendant-TRG.com>
> > Date: 2004/02/24 Tue PM 01:50:03 EST
> > To: <oracle-l_at_freelists.org>
> > Subject: RE: RE: Frustration with Toad Debugger
> >
> > Are you kidding, I'd never give a developer alter system priv. I
> > wrapped it in a package and made it schema-specific as to what
sessions > they can kill.
> >
> >
> > -----Original Message-----
> > From: ryan.gaffuri_at_cox.net [mailto:ryan.gaffuri_at_cox.net]
> > Sent: Tuesday, February 24, 2004 1:42 PM
> > To: oracle-l_at_freelists.org
> > Subject: Re: RE: Frustration with Toad Debugger
> >
> > is it really that bad for you to give developers the ability to kill
> > sessions? if your afraid of general alter system privileges you can
wrap > it in a package?
> >
> >
> > >
> > > From: Kirtikumar Deshpande <kirtikumar_deshpande_at_yahoo.com>
> > > Date: 2004/02/24 Tue PM 01:23:01 EST
> > > To: oracle-l_at_freelists.org
> > > Subject: RE: Frustration with Toad Debugger
> > >
> > > Our Developers use 7.6.0.11
> > >
> > > - Kirti
> > >
> > > --- "Jesse, Rich" <Rich.Jesse_at_quadtechworld.com> wrote:
> > > > What versions of TOAD are y'all on?
> > > >
> > > > Rich
> > > >
> > > > Rich Jesse System/Database Administrator
> > > > rich.jesse_at_quadtechworld.com QuadTech, Sussex, WI USA
> > > >
> > > >
> > > > > -----Original Message-----
> > > > > From: Kirtikumar Deshpande
[mailto:kirtikumar_deshpande_at_yahoo.com] > > > > Sent: Tuesday, February
24, 2004 12:09 PM
> > > > > To: oracle-l_at_freelists.org
> > > > > Subject: Re: Frustration with Toad Debugger
> > > > >
> > > > >
> > > > > Lisa,
> > > > > So, you are the only one..
> > > > >
> > > > > I get gazzillion requests from our Developers to kill their
> > > > > hung TOAD sessions when they play with
> > > > > this debugger thing. I doubt if this is a completely bug free
> > > > > begugger!!
> > > > >
> > > > > - Kirti
> > > > >
> > > > >
> > > > >
> > > > > --- "Koivu, Lisa" <Lisa.Koivu_at_Cendant-TRG.com> wrote:
> > > > > > Hi everyone,
> > > > > >
> > > > > > Has anyone ever gotten this to work??? I have tried several
> > > > > different
> > > > > > times to use it, and it gets stuck at the Set Parameters
> > > > > dialog box.
> > > > > >
> > > > > > I tried to look at the yahoo group, but it's blocked from
here. > > > > >> > > >
> > > > > > Thanks
> > > > > >
> > > > > > Lisa Koivu
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > > ----------------------------------------------------------------
> > > > To unsubscribe send email to: oracle-l-request_at_freelists.org
> > > > put 'unsubscribe' in the subject line.
> > > > --
> > > > Archives are at http://www.freelists.org/archives/oracle-l/
> > > > FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> > > >
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- "The sender believes that this E-Mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking proactive and remedial action about viruses and other defects. The sender's business entity is not liable for any loss or damage arising in any way from this message or its attachments." ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Wed Feb 25 2004 - 07:48:17 CST
 |
 |