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
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