RE: KIll Session in - RAC DB

Actually, it's not very fun or exciting.  

On my 9.2.0.8 on Solaris:
SQL> select sid,serial# from v$session where paddr in(select paddr from v$bgprocess where name = 'PMON');  

  SID SERIAL#
----- -------

    1 1  

1 row selected.  

SQL> alter system kill session '1,1';
alter system kill session '1,1'
*

ERROR at line 1:
ORA-00029: session is not a user session

You also can't kill your own current session: SQL> select sid,serial# from v$session where sid in(select sid from v$mystat where rownum=1);  

  SID SERIAL#
----- -------
  150 3820  

1 row selected.  

SQL> alter system kill session '150,3820'; alter system kill session '150,3820'
*

ERROR at line 1:
ORA-00027: cannot kill current session  

-Mark  

-- 
Mark J. Bobak 
Senior Oracle Architect 
ProQuest/CSA 

"There are 10 types of people in the world:  Those who understand
binary, and those who don't." 

 

________________________________

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of rjamya
Sent: Friday, April 13, 2007 1:11 PM
To: Oracle Discussion List
Subject: Re: KIll Session in - RAC DB


so, I can put in sid,serial for pmon or smon into the table and watch
fun 8:)

rjamya


On 4/13/07, Jared Still < jkstill_at_gmail.com <mailto:jkstill_at_gmail.com> >
wrote: 

	I like that.  :)
	
	
	
	On 4/13/07, Tanel Poder <tanel.poder.003_at_mail.ee> wrote: 

		Hi,
		 
		Write a pl/sql daemon which runs in every instance,
wakes up once per minute and scans for a shared table for insance, sid
and serial# combination to kill. If it finds anything matching local
instance ID, it kills that session(s).
		



--
http://www.freelists.org/webpage/oracle-l