Could not reserve record
SELECT 'alter system kill session ''' || s.SID || ',' || s.serial# || '''', d.object_name, s.process,s.status, s.machine, s.module, s.action, s.logon_time, s.last_call_et,s.client_identifier FROM gv$locked_object g, dba_objects d, gv$session s WHERE g.object_id = d.object_id AND s.SID = g.session_id and s.status<>'ACTIVE' --and s.MODULE='APXINWKB' and d.OBJECT_NAME like 'AP%' -- and g.session_id in (2409) order by s.LOGON_TIME desc;
No comments:
Post a Comment