![]() Gv$session gvs WHERE (gvh.id1, gvh.id2) IN (SELECT id1, Serial, gvh.inst_id instance_id FROM gv$lock gvh, gv$lock gvw, Miladin Modrakovic offers this script to detect andīEGIN FOR x IN (SELECT gvh.SID sessid, gvs.serial# ![]() Session, and dba_blockers and dba_waiters cannotĪlways help identify blocking RAC sessions. Killing a session in RAC is different than killing an ordinary blocking ![]() Gv$lock and gv$session views to locate a blocking session in RAC. How to I find Oracle blocking sessions in RAC?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |