Pages

Sunday, October 21, 2012

Multi User session Kill in Oracle


To kill the inactive users login in Oracle from any schema in a database.If any unwanted transactions were kept withput roll back it will block the buffer memory, then it leads to database block.Using this query we can find out the User and the machine number, so that we can kill the bolcking transaction.   

SELECT   SYS.v_$lock.SID, machine, program, object_name, logon_time, osuser
    FROM SYS.v_$lock, SYS.v_$session, all_objects
   WHERE SYS.v_$lock.SID = SYS.v_$session.SID
     AND SYS.v_$lock.id1 = all_objects.object_id
     AND SYS.v_$lock.TYPE = 'TM'
ORDER BY SYS.v_$lock.SID, machine, program

1 comment:

  1. Your contents are completely awesome and share worthy. I really appreciate your efforts that you put on this. Keep sharing. For more What Is Buffer Memory related information visit Open Naukri

    ReplyDelete