killed shared server sessions (mts) not getting killed
- From: "Jeffrey Beckstrom" <JBECKSTROM@xxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>, <ORACLE-L@xxxxxxxxxxxxx>,<oracledba@xxxxxxxxxxx>, <oracle-rdbms@xxxxxxxxxxxxxxx>
- Date: Mon, 17 May 2004 10:47:45 -0400
Killing a shared servers session using: alter system kill session
'&1,&2' immediate;
However, the session does not kill if active. If inactive, and issue
this command then the killed session gets a 3113 error on next command.
However, if session is active then it does not get killed. Status in
v$session remains as active.
I ended up killing the session by using orakill <db> <thread id>. This
kills the shared server process which is then restarted. Is this what
must be done if the session is in an active status?
Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
- » killed shared server sessions (mts) not getting killed
