标签归档:解锁

oracle ebs 解锁命令

以下是ebs解锁及相关辅助信息:

select (select ppf.full_name
          from per_people_f ppf, per_assignments_f paf, fnd_user fu
         where 1 = 1
           and ppf.person_id = paf.person_id
           and fu.employee_id = ppf.person_id
           and fu.user_name = vss.client_identifier
           and sysdate between ppf.effective_start_date and
               ppf.effective_end_date
           and sysdate between paf.effective_start_date and
               paf.effective_end_date
           and (fu.end_date is null or fu.end_date > sysdate)) user_name,
       (select fr.responsibility_name
          from fnd_responsibility_vl fr
         where fr.responsibility_key =
               (select substr(vss.action, instr(vss.action, '/') + 1)
                  from dual)) resp_name,
       (select fa.application_name
          from fnd_application_vl fa
         where fa.application_short_name =
               (select substr(vss.action, 1, instr(vss.action, '/')-1)
                  from dual)) prod_name,
       (select ff.user_form_name
          from fnd_form_vl ff
         where ff.form_name =
               (select substr(vss.module, instr(vss.module, ':', 1, 3) + 1)
                  from dual)) form_name,
       (select ff.description
          from fnd_form_vl ff
         where ff.form_name =
               (select substr(vss.module, instr(vss.module, ':', 1, 3) + 1)
                  from dual)) form_desc,
       dob.object_name table_name,
       vss.action action,
       vss.client_identifier user_code,
       vss.module,
       vss.machine,
       'alter system kill session ' || '''' || lo.session_id || ',' ||
       vss.serial# || ''';' kill_command,
       vss.osuser osuser,
       vss.process ap_pid,
       vps.spid db_pid,
       lo.locked_mode,
       lo.session_id,
       vss.serial#,
       vps.spid
  from v$locked_object lo, dba_objects dob, v$session vss, v$process vps
 where lo.object_id = dob.object_id
   and lo.session_id = vss.sid
   and vss.paddr = vps.addr
 order by resp_name asc, dob.object_name;