▷ Oracle parameter check, 'UNLIMITED' (오라클 파라미터, UNLIMITED)

[ Oracle parameter check ]

--col RESOURCE_NAME for a22

select RESOURCE_NAME,
CURRENT_UTILIZATION AS "CURRENT",
MAX_UTILIZATION AS "MAX",
INITIAL_ALLOCATION AS "INITIAL",
LIMIT_VALUE AS "LIMIT",
decode(INITIAL_ALLOCATION, 0, '-', round(MAX_UTILIZATION/INITIAL_ALLOCATION*100,1)) as "Usages(%)"
from v$resource_limit
where LIMIT_VALUE not in (' UNLIMITED', '         0');