Kill/Terminate session of an object in Oracle backend

–Get sid and serial# for object
SELECT object_name,
machine,
s.sid,
s.serial#
FROM gv$locked_object l, dba_objects o, gv$session s
WHERE l.object_id = o.object_id
AND l.session_id = s.sid
AND o.object_name = :object_name

–KILL SESSION SQL:
ALTER SYSTEM KILL SESSION ‘sid, serial#’

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s