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