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.


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: