Submitted by jp_vijaykumar on Wed, 2010-04-14 22:56
KILLING USERS SESSIONS IN ORACLE
Author JP Vijaykumar Oracle DBA
Date Apr 14th 2010
A detailed discussion on redo, undo and Oracle's read consistency are
beyond the scope of this document.
A detailed discussion on setup, troubleshooting of user connections
in MTS environment is beyond the scope of this document.
Before embarking on a killing spree of Oracle sessions, let us explore
the options, limitations, dos and don'ts.
Submitted by jp_vijaykumar on Mon, 2009-12-14 18:36
KILLING SESSIONS IN ORACLE
Author JP Vijaykumar
Date Jan 27th 2009
Modified Jan 29th 2009
One of my procedure is taking long time to complete. I want to kill my job and
re-run the procedure after incorporating HINTS.
Let us explore the options to kill long running jobs.
From the v$session, I found that my session is active.
select username, osuser,sid,serial#,status from v$session where sid=57;
Submitted by jp_vijaykumar on Sat, 2009-11-14 20:23
Many a time, developers ask for procedures to kill there own sessions in the oracle db.
Many of our developers are scattered around the globe in different time zones.
During on-call rotation, developers will be calling me, round the clock, to kill their sessions.