Run the query below to determine if you can lock an object in a particular env:
SELECT COUNT(*)
FROM MERC_WAKE M, STAT_OAENV_DETAILS O
WHERE M.SD_CD = TO_CHAR(O.AGENT_ID) AND M.AGENT_TYPE = 'O' AND ((SYSDATE - M.UPDATE_DT) * 24 * 60 * 60 ) > (30 * O.MERC_WAKE_MULTI)
AND O.DB_CD = 'env_cd';
If nothing shows up from the above query, then stat can locks the object. If 1 or more row show up then stat will not be able to lock the object. In that case, go to Tools | Table Dump Utility and run the following queries:
1. SELECT * FROM STAT_OAENV_DETAILS
WHERE AGENT_ID='ENTER_AGENT_ID';
2. SELECT * FROM STAT_AGENT
WHERE AGENT_ID='ENTER_AGENT_ID';
3. SELECT * FROM MERC_OA_AGENT_STATUS
WHERE AGENT_ID='ENTER_AGENT_ID';
4. SELECT * FROM OA_PATCH_APPLY_DRIVERS
WHERE AGENT_ID='ENTER_AGENT_ID';
Export the results to an excel sheet with headers and submit an SR to support. This issue required support to take a look at your data before we can give you the dml statements to execute against your db.
