Monday, June 12, 2017

Find Concurrent Manager Lock Session

SELECT v$access.sid, v$session.serial#
FROM v$session,v$access
WHERE v$access.sid = v$session.sid and v$access.object = ‘FND_CP_FNDSM’
GROUP BY v$access.sid, v$session.serial#;


alter system kill session ‘2000,1000’;

No comments:

Post a Comment