SELECT
   c.owner,
   c.object_name,
   c.object_type,
   b.sid,
   b.serial#,
   'ALTER SYSTEM KILL SESSION ''' || b.sid || ', ' || b.serial# || ''';' AS KILL_COMMAND,
   b.status,
   b.osuser,
   b.machine
From
   v$locked_object a ,

   v$session b,
   dba_objects c
where
   b.sid = a.session_id
and
   a.object_id = c.object_id

and c.object_name not in ('AD_ROLE', 'AD_TAB', 'K_INDEX', 'R_REQUESTTYPE', 'AD_RECENTITEM', 'AD_CLIENT', 'AD_BROADCASTMESSAGE', 'AD_ORG', 'C_BPARTNER', 'AD_PROCESS' ,  'AD_ARCHIVE', 'AD_ATTACHMENT', 'AD_CHANGELOG', 'AD_COLUMN', 'AD_NOTE', 'AD_MESSAGE', 'AD_SESSION', 'AD_TABLE', 'AD_SEQUENCE', 'CM_WEBPROJECT', 'AD_WF_ACTIVITY', 'AD_WINDOW', 'AD_USER', 'C_DOCTYPE')
and b.status like 'ACTIVE'
--and b.sid = '1622'
--and b.machine = 'WORKGROUP\ABC'
--and b.machine = 'BVP_NT05'
--and c.object_name in ( 'HIS_SERVICE_MEDICTESTGROUP')
;