OracleSessions
Kill a session
Needs both SID and SERIAL# from V$SESSION; the session and blocking scripts show them together. Add the instance ID as a third value on RAC.
Not yet verified. How scripts are tested
1-- 'sid,serial#' (on RAC: 'sid,serial#,@inst_id')2ALTER SYSTEM KILL SESSION '123,45678' IMMEDIATE;Save it as b-ora-kill.sql and run it with SQL> @b-ora-kill.
More Oracle scripts: Sessions
- Long operations with time remaining (all instances)Long operations still running on any instance, with percent done and elapsed, remaining and estimated total minutes. RMAN is left out because it has…
- SQL active for 30 minutes or more (all instances)Active application sessions whose current call has run for at least 1,800 seconds, with instance, program, OS process ID, SQL_ID, plan hash value and…
- Active user sessionsUser sessions doing work right now on every instance: who, from which OS user and machine, the module, what they're waiting on, the SQL_ID, when they…
- Session count by user and machineWho is connected, from where, and how many are active. The quickest way to spot a connection pool that has run away.
- Everything about one sessionPrompts for a SID and shows the user, OS details, program, current and previous SQL_ID, wait event and the OS process ID behind it.
- Find the session behind an OS process IDWhen top or ps shows an Oracle process burning CPU, enter its PID to see which session and SQL it belongs to.