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
-----------------------------------------------------------------
Received on Fri Mar 12 2004 - 08:01:00 CST
