ORACLE RAC LOCK Check Scripts
오라클 데이터베이스 RAC Global Lock Scripts * 2018-04 최초생성 * 2018-05 Lock Type 추가 SELECT GV_S.INST_ID, GV_S.SID AS GV_SESSION_ID, GLS.SID AS GV_LOCK_SID, GV_S.INST_ID AS GV_SESSION_ID, GV_S.SERIAL#, LPAD(' ', (LEVEL - 1) * 4, ' ') || DECODE(LEVEL, 1, '', 'L-->') || GV_S.USERNAME AS USERNAME, GV_S.STATUS, GV_S.PROCESS, GV_S.SCHEMANAME, GV_S.OSUSER, GV_S.PROCESS, GV_S.MACHINE, GV_S.TERMINAL, GV_S.PROGRAM, ..
2018. 8. 9.