2023-01-31

[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';

沒有留言:

張貼留言