hi mladen,
I hope there are no developers around this list.But ur point is well taken
,We have a Company policy of enlightning the Developers so that they utilize
ORACLE Better and in course some of them gets a little more enlightened
than usual but thats I guess is better than having Developers who confuses
full tablescan IS ALLWAYS FASTER THAN INDEX RANGE SCAN.What do u say.But it
makes my job on Security front hectic. Thanks a mil for the reply.
Deep
----- Original Message -----
From: Mladen Gogala <mladen_at_wangtrading.com>
To: <oracle-l_at_freelists.org>
Sent: Friday, March 12, 2004 7:34 PM
Subject: Re: oradebug
> Developers that get access to oradebug should be taken aside and executed
quietly,
> the same as marketing personnel which gets access to computer magazines.
Suspend
> blocks IO for the whole database and is an implementation of "ALTER SYSTEM
SUSPEND".
> It basically brings the database in the state where nobody can do any
phyisical
> I/O, which is the ultimate optimization of BCHR. I doubt that you'll find
it very
> useful, though. If you want to test it, log in as SYSDBA, during peak
hours and
> execute "ALTER SYSTEM SUSPEND". Your BCHR is going to be 100%.
>
>
> On 03/12/2004 09:59:35 AM, Database Admin wrote:
> > Thats what the entire thing is abt .One of teh developers was playing
> > arnd with oradebug in a demo server on typing oradebug help he got a
option
> > listed as "SUSPEND" now we are trying to play around with it some
more.Can
> > you guide me to some docs regarding this.I am currently checking only
the
> > Oracle Doc.
> > thanks
> > Deep
> > > What would suspending a session actually mean? There is no such
session
> > > state as "suspended".
> > >
> > > On 03/11/2004 09:15:34 AM, Database Admin wrote:
> > >> Hi Mladen,
> > >> thanks man I knw that but I am unable to SUSPEND a session using
> > >> oadebug suspend pid;
> > >> it asks for more params ,where can I find this info.I sent u a per
> > >> mail abt this on wangtrading it bounced.Do reply
> > >> cheers
> > >> Deep
> > >> >
> > >> > On 03/11/2004 08:32:28 AM, Database Admin wrote:
> > >> >> Hi,
> > >> >> Can u enlighten me abt oradebug.
> > >> >
> > >> > No. Just type oradebug help and try it. No enlightenment necessary.
> > >> -- Mladen Gogala
> > >> > Oracle DBA
> > >> > ----------------------------------------------------------------
> > >> 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
> > >> -----------------------------------------------------------------
> > >>
> > >>
> > >>
> > >> ----------------------------------------------------------------
> > >> 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
> > >> -----------------------------------------------------------------
> > >>
> > > ----------------------------------------------------------------
> > > 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
> > > -----------------------------------------------------------------
> >
> >
> >
> > ----------------------------------------------------------------
> > 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
> > -----------------------------------------------------------------
> >
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------
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 Sat Mar 13 2004 - 02:08:09 CST
