Kill the database session by executing the SQL statement ALTER SYSTEM KILL SESSION ','. SQL> SELECT s.SID, s.SERIAL#, p.SPID, s.PROGRAM
ORACLE KILL SESSION BY SID SERIAL NUMBER
by entering the following command as UNIX user oracle:ĭetermine the Session Identifier (SID) and the Session Serial Number (SERIAL#) of the database session which corresponds to the operating system PID you determined in Step 1: Oracle 8606 8605 99 16:35 ? 00:59:28 oraclealeph21 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))Ĭonnect to the Oracle database with privilege sysdba, e.g. In this case the parent process has an sqlplus process as its child, and that sqlplus process has a database server process as its child:Īleph 8482 32481 0 16:35 pts/1 00:00:00 csh -f p_custom_02 USM50,loanst,09,Īleph 8605 8482 0 16:35 pts/1 00:00:00 sqlplus USM50 loanst 09 a script that called SQL*Plus which in turn opened the database session.
This way,developers can be more productive and not wait for a DBA to do the hunting. I have created a procedure to kill your own session. You know the parent process which initiated the database session you want to kill, e.g. oracle KILL MY OWN SESSION for developers (without system privilege ) It is a common request from development to kill some run-away sessions so that they can re-run the application or query. In this case the UNIX command top may report the corresponding operating system process as one of the top consumers of CPU time and provide its PID. You suspect that a database session is spinning and consuming a significant amount of CPU time. kill session and process Hi TomWhen we do alter system kill sid, serial. Alternative way to kill a session is using ALTER SYSTEM DISCONNECT SESSION command. I dont want to just lock the database and let the users quit gracefully. SQL> alter system kill session ‘sid, serial, instid’ NOTE: If you don’t want to put instid, then goto the instance from where user is connected and then kill it. We often get task to kill multiple sessions which are active,inactive and the session related with a particular program. 2 people found this article useful This article was helpful.
Kill an unwanted Oracle database session in a clean way.ĭetermine the process ID (PID) of the operating system process which corresponds to the database session. I need to quickly (and forcibly) kill off all external sessions connecting to my oracle database without the supervision of and administrator. This entry was posted in Monitoring and tagged generate, kill, rac, session, sqlid.
0 kommentar(er)
