From oracle-l-bounce@freelists.org Sat Mar 13 02:08:09 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2D889w05500 for ; Sat, 13 Mar 2004 02:08:09 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i2D87wo05493 for ; Sat, 13 Mar 2004 02:07:58 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6D04F395218; Sat, 13 Mar 2004 03:07:05 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Sat, 13 Mar 2004 03:05:49 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from www.magma.co.in (unknown [202.144.98.234]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CBBC03951F4 for ; Sat, 13 Mar 2004 03:05:43 -0500 (EST) Received: from sbagal200 (localhost.localdomain [127.0.0.1]) by www.magma.co.in (8.12.5/8.12.5) with SMTP id i2D9JT2P029945 for ; Sat, 13 Mar 2004 14:49:30 +0530 Message-ID: <01b901c408d3$8bdaa3e0$0a0610ac@lan.magma.co.in> From: "DBA" To: References: <2705.172.16.7.231.1079011948.squirrel@www.magma.co.in> <20040311124541.GA13518@medo.adelphia.net> <5518.172.16.7.231.1079014534.squirrel@www.magma.co.in> <20040311140618.GA1588@mladen.wangtrading.com> <3132.220.226.8.102.1079103575.squirrel@www.magma.co.in> <20040312140404.GI1600@mladen.wangtrading.com> Subject: Re: oradebug Date: Sat, 13 Mar 2004 13:46:54 +0530 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 X-archive-position: 782 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: dba@magma.co.in Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l 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 To: 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@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@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@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@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@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@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 -----------------------------------------------------------------