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.