[Oracle]APP-OFA-48232 Another transaction is already being performed on this asset
當發現這個錯誤時,可以使用以下SQL來判斷是否Table Lock,來進行排除
SELECT A.SESSION_ID, B.OBJECT_NAME
FROM V$LOCKED_OBJECT A, DBA_OBJECTS B
WHERE A.OBJECT_ID = B.OBJECT_ID
AND B.OBJECT_NAME LIKE 'FA%'
AND B.OBJECT_TYPE = 'TABLE';
沒有留言:
張貼留言