To disconnect the session use this :
Alter system disconnect session 'sid,serial#'
post_transaction;
- Richard Ji <richard.ji_at_mobilespring.com> wrote:
> You run oradebug from sqlplus.
>
> SQL> oradebug help
> HELP [command] Describe
> one or all commands
> SETMYPID Debug
> current process
> SETOSPID <ospid> Set OS pid
> of process to debug
> SETORAPID <orapid> ['force'] Set Oracle
> pid of process to debug
> DUMP <dump_name> <lvl> [addr] Invoke
> named dump
> DUMPSGA [bytes] Dump fixed
> SGA
> DUMPLIST Print a
> list of available dumps
> EVENT <text> Set trace
> event in process
> SESSION_EVENT <text> Set trace
> event in session
> output truncated ................
>
> -----Original Message-----
> Sent: Thursday, December 26, 2002 1:19 AM
> To: Multiple recipients of list ORACLE-L
>
>
> chao_ping,
>
> where to find the oradebug? is it a command?
> what should i do to run the oradebug?
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L"
> <ORACLE-L_at_fatcity.com>
> Sent: Thursday, December 26, 2002 1:33 PM
>
>
> shuan.tay\(PCI¾G¸R³Ô\),
> Hi, It is because oracle will have to wake up pmon
> to rollback those
> uncommitted transactions, so, the lock cannot be
> released befor the rollback
> complete.
> You have to wake. Some trick said in this list is
> that you use oradebug to
> wake up pmon manually, maybe will rollback the
> transactions faster:)
>
>
>
>
>
> Regards
> zhu chao
> msn:chao_ping_at_163.com
> www.happyit.net
> www.cnoug.org(ChinaOracle User Group)
>
> ======= 2002-12-25 19:48:00 ,you wrote£º=======
>
> >Dear all DBAs,
> >
> >Is there any way to remove the lock of table which
> status is already marked
> as "killed"?
> >No matter how many times i try to kill the session,
> it still marked as
> "killed",
> >but it still won't release the lock.
> >
> >Thanks in advance.
>
> = = = = = = = = = = = = = = = = = = = =
>
>
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: chao_ping
> INET: chao_ping_at_vip.163.com
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: =?big5?B?c2h1YW4udGF5XChQQ0m+R7hSs9RcKQ==?=
> INET: shuan.tay_at_pci.co.id
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Richard Ji
> INET: richard.ji_at_mobilespring.com
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
>
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ashraf Salaymeh
INET: ashraf_salaymeh_at_yahoo.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Thu Dec 26 2002 - 02:23:50 CST