DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Wednesday, January 3, 2018

                                     Query to check the concurrent manager lock 


This query is used for finding out the concurrent manager locks when shutdown takes long time to down the ICM/CM . Mostly we find this type of locks in RAC ebs setup environments.



Query
--------

SELECT gv$access.sid, gv$session.serial#,gv$session.inst_id,gv$session.status,gv$session.process  FROM gv$session,gv$access WHERE gv$access.sid = gv$session.sid and gv$access.object = 'FND_CP_FNDSM' GROUP BY gv$access.sid, gv$session.serial#,gv$session.inst_id,gv$session.status,gv$session.process;

No comments: