In this case may be more than a user sharing the same session and updating the data,
Solution:-
1. Find Table lock.
login with apps and fire below commend
SQL> 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;
OWNER OBJECT_NAME OBJECT_TYPE SID SERIAL# STATUS OSUSER MACHINE
------------------------------ ------------------------------------- ------------------------------------- ---------- ---------- -------- ------------------------------ ----------------------------------------------------------------
APPLSYS FND_CONCURRENT_REQUESTS TABLE 11 21 INACTIVE applmgr sujeet.oracle.com
INV MTL_MWB_GTMP2 TABLE 318 124 applmgr sujeet.oracle.com
SQL> 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 2 3
4 ;
OWNER OBJECT_NAME ORACLE_USERNAME OS_USER_NAME
------------------------------ ------------------------------------- --------------- ---------------
INV MTL_MWB_GTMP2 APPS applmgr
APPLSYS FND_CONCURRENT_REQUESTS APPS applmgr
2. After find table lock release it...
User below commend to release table lock.
Here SID-11, Serial no-21.
SQL> alter system kill session '11,21';
System altered.
Solution:-
1. Find Table lock.
login with apps and fire below commend
SQL> 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;
OWNER OBJECT_NAME OBJECT_TYPE SID SERIAL# STATUS OSUSER MACHINE
------------------------------ ------------------------------------- ------------------------------------- ---------- ---------- -------- ------------------------------ ----------------------------------------------------------------
APPLSYS FND_CONCURRENT_REQUESTS TABLE 11 21 INACTIVE applmgr sujeet.oracle.com
INV MTL_MWB_GTMP2 TABLE 318 124 applmgr sujeet.oracle.com
SQL> 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 2 3
4 ;
OWNER OBJECT_NAME ORACLE_USERNAME OS_USER_NAME
------------------------------ ------------------------------------- --------------- ---------------
INV MTL_MWB_GTMP2 APPS applmgr
APPLSYS FND_CONCURRENT_REQUESTS APPS applmgr
2. After find table lock release it...
User below commend to release table lock.
Here SID-11, Serial no-21.
SQL> alter system kill session '11,21';
System altered.
Retest issue. I hope issue resolve.
No comments:
Post a Comment