RE: RE: Frustration with Toad Debugger
- From: "Niall Litchfield" <n-litchfield@xxxxxxxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 24 Feb 2004 21:47:34 +0000
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@xxxxxxxxxxxxx [mailto:AC.GWIA.oracle-l@xxxxxxxxxxxxx]
Sent: Tue 24/02/2004 18:57
To: oracle-l@xxxxxxxxxxxxx; ryan.gaffuri@xxxxxxx
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@xxxxxxxxxxxxxxx>
> Date: 2004/02/24 Tue PM 01:50:03 EST
> To: <oracle-l@xxxxxxxxxxxxx>
> 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@xxxxxxx [mailto:ryan.gaffuri@xxxxxxx]
> Sent: Tuesday, February 24, 2004 1:42 PM
> To: oracle-l@xxxxxxxxxxxxx
> 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@xxxxxxxxx>
> > Date: 2004/02/24 Tue PM 01:23:01 EST
> > To: oracle-l@xxxxxxxxxxxxx
> > Subject: RE: Frustration with Toad Debugger
> >
> > Our Developers use 7.6.0.11
> >
> > - Kirti
> >
> > --- "Jesse, Rich" <Rich.Jesse@xxxxxxxxxxxxxxxxx> wrote:
> > > What versions of TOAD are y'all on?
> > >
> > > Rich
> > >
> > > Rich Jesse System/Database Administrator
> > > rich.jesse@xxxxxxxxxxxxxxxxx QuadTech, Sussex, WI USA
> > >
> > >
> > > > -----Original Message-----
> > > > From: Kirtikumar Deshpande [mailto:kirtikumar_deshpande@xxxxxxxxx] > >
> > > > > > Sent: Tuesday, February 24, 2004 12:09 PM
> > > > To: oracle-l@xxxxxxxxxxxxx
> > > > 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@xxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxx
> > > put 'unsubscribe' in the subject line.
> > > --
> > > Archives are at //www.freelists.org/archives/oracle-l/
> > > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> > > -----------------------------------------------------------------
> >
> >
> > __________________________________
> > Do you Yahoo!?
> > Yahoo! Mail SpamGuard - Read only the mail you want.
> > http://antispam.yahoo.com/tools
> > ----------------------------------------------------------------
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > ----------------------------------------------------------------
> > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at //www.freelists.org/archives/oracle-l/
> > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> > -----------------------------------------------------------------
> >
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
**********************************************************************
This email contains information intended for
the addressee only. It may be confidential
and may be the subject of legal and/or
professional privilege. Any dissemination,
distribution, copyright or use of this
communication without prior permission of
the sender is strictly prohibited.
**********************************************************************
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
