How to kill an oracle session
conn as / sysdba or any dba user.
SQL> Alter system kill session 'sid,serial#' immediate;
OS level:
Windows:
orakill ORACLE_SID spid
The UNIX /Linux :
To kill the session on UNIX or Linux operating systems, first identify the session, then substitute the relevant SPID into the following command.
find out running oracle process
$ps -ef | grep ora
$kill -9 unix/linux process id
conn as / sysdba or any dba user.
SQL> Alter system kill session 'sid,serial#' immediate;
OS level:
Windows:
orakill ORACLE_SID spid
The UNIX /Linux :
To kill the session on UNIX or Linux operating systems, first identify the session, then substitute the relevant SPID into the following command.
find out running oracle process
$ps -ef | grep ora
$kill -9 unix/linux process id
No comments:
Post a Comment