Oracle RAC Resource utilization check Script
SELECT gv_i.INST_ID ,gv_i.INSTANCE_NAME ,gv_i.HOST_NAME ,gv_i.VERSION ,gv_i.STARTUP_TIME ,gv_i.STATUS ,gv_rl.RESOURCE_NAME ,gv_rl.CURRENT_UTILIZATION ,gv_rl.MAX_UTILIZATION ,gv_rl.INITIAL_ALLOCATION ,gv_rl.LIMIT_VALUE ,ROUND((gv_rl.MAX_UTILIZATION / gv_rl.LIMIT_VALUE) * 100, 2) AS "MAX(%)" ,ROUND((gv_rl.CURRENT_UTILIZATION / gv_rl.LIMIT_VALUE) * 100, 2) AS "CURRENT(%)" FROM gv$resource_limit gv_..
2019. 6. 21.
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.
