Home » RDBMS Server » Server Administration » Kill Session
Kill Session [message #54823] Mon, 09 December 2002 00:45 Go to next message
Ashish Patel
Messages: 2
Registered: September 2001
Junior Member
ALTER SYSTEM DISCONNECT SESSION 'SID, SERIAL#' POST_TRANSACTION;
ALTER SYSTEM KILL SESSION 'SID, SERIAL#';

These 2 commands are mentioned in the Oracle Document and Working on the prompt. but belowing command is not mentioned in the Oracle Documentation But Its also working on the SQL prompt, SO please give me brief information about this command (Explain)

ALTER SYSTEM DISCONNECT SESSION 'SID, SERIAL#' IMMEDIATE;
Re: Kill Session [message #54825 is a reply to message #54823] Mon, 09 December 2002 01:25 Go to previous message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Look here:
http://download-west.oracle.com/docs/cd/A97630_01/server.920/a96540/statements_23a.htm#2053825

MHE
Previous Topic: No ARCHIVE LOGS and no REDO LOGS.. Can I recover DB?
Next Topic: SET TRANSACTION USE ROLLBACK SEGMENT
Goto Forum:
  


Current Time: Fri Sep 20 05:53:05 CDT 2024