How can find Locked Object in Oracle Apps R12 ?or How can find Locked object name and Oracle User name in Oracle Apps R12?
Query 1 -
SELECT b.owner
, b.object_name
, a.oracle_username
, a.os_user_name
FROM v$locked_object a
, all_objects b
WHERE a.object_id = b.object_id
Query 2 -
SELECT c.owner
, c.object_name
, c.object_type
, b.SID
, b.serial#
, b.status
, b.osuser
, b.machine
FROM v$locked_object a
, v$session b
, dba_objects c
WHERE b.SID = a.session_id
AND a.object_id = c.object_id;
Query 3 -
SELECT a.session_id
, a.oracle_username
, a.os_user_name
, b.owner "OBJECT OWNER"
, b.object_name
, b.object_type
, a.locked_mode
FROM ( SELECT object_id
, session_id
, oracle_username
, os_user_name
, locked_mode
FROM v$locked_object ) a
, ( SELECT object_id
, owner
, object_name
, object_type
FROM dba_objects ) b
WHERE a.object_id = b.object_id;
“A GUIDE FOR ORACLE E-BUSINESS SUITE” – A complete Solution and Learning platform For Oracle Apps R12/11i, Training, India Localization, Technical, P2P, O2C, Drop-shipment, AR/AP Cycle, Implementation, Bug or error in Oracle Apps R12/11i, Up-gradation, Support, Alert, Personalization, Discoverer management, OracleApps R12/11i Module, Finance, SCM, MRP, ASCP, WIP, BOM, FA, AP, AR, OM, INV, AOL, MOAC, TCA structure, Project Accounting, CM, Functional,Oracle DBA, ERP, Techno-functional, OAF, Oracle Apps Interview Question and Error in Oracle apps R12/11i. For More Information Visit on www.OracleAppsGuide.com Or Subscribe your email-id on OracleAppsGuide.
