| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> killed shared server sessions (mts) not getting killed
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
 |
 |