— chk_gv_res.sql
— mdw 01/08/01
— quick check on the gv$resource entries. NB most of use on OPS
col inst_id    form 999 head inst
col resource_name form a25 word wrap
col current_utilization head curr_util
col max_utilization     head max_util
col initial_allocation  head ini_alloc
col limit_value         head  Limit_val
spool chk_gv_res.lst
select * from gv$resource_limit where upper(resource_name) like upper(‘&res_name’)||’%’ order by inst_id,resource_name
/
clear colu
spool off