Friday, 5 October 2012

APPS Error

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;
 

Reference: 

 

No comments:

Post a Comment