Wednesday, 23 November 2016

How to check locks on ICM !!!


Simple output query
+++++++++++++++

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#;
  2    3    4
       SID    SERIAL#
---------- ----------
      2208        442


No comments:

Post a Comment