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_rl
,gv$instance gv_i
WHERE 1 = 1
AND gv_rl.INST_ID = gv_i.INST_ID
AND gv_rl.LIMIT_VALUE <> ' UNLIMITED'
ORDER BY gv_rl.RESOURCE_NAME;
