Post date: Nov 09, 2010 1:47:29 PM
SELECT t2.object_id,t2.object_name,t1.session_id,t3.serial#, t3.module, t3.action,
'ALTER SYSTEM KILL SESSION' || CHR (10) || CHR (39) || t1.session_id ||','||t3.serial#||CHR (39)||';' Copy_paste
FROM v$locked_object t1, dba_objects t2, v$session t3
WHERE t2.object_id = t1.object_id
AND t3.SID = t1.session_id
--AND t2.object_type = 'TABLE'
--AND t2.object_name LIKE 'MTI%' --> Kalau diketahui nama tablenya, pakai line ini, misal HZ_ORGANIZATION_PROFILES, masukkan HZ%
AND UPPER(ACTION) LIKE '%' --> Kalau mau pakai nama user pakai line ini, tetapi kalau dari APPS ada petunjuk tabel yg kena lock mending pakai table
--ORDER BY 2,3,4