gcs_resources at 100% on V$RESOURCE_LIMIT
112131Jun 12 2007 — edited Jun 14 2007Hi folks.
A query in V$RESOURCE_LIMIT shows 100% of utilization for gcs_shadows and gcs_resources. Is that a problem? If it is a problem, how do I fix / tune it?
INIT LIMIT CURR CURR MAX MAX
RESOURCE_NAME ALLOC VALUE UTILIZ PCT UTILIZ PCT
--------------------- ---------- ---------- ------- ---- ------- ----
gcs_resources 226590 226590 126431 56 226590 100
gcs_shadows 226590 226590 126864 56 226590 100
sessions 885 885 250 28 609 69
processes 800 800 245 31 532 67
ges_procs 801 801 244 30 530 66
enqueue_locks 10672 10672 90 1 199 2
branches 973 UNLIMITED 10 0 38 0
cmtcallbk 973 UNLIMITED 1 0 3 0
dml_locks 3892 UNLIMITED 15 0 470 0
enqueue_resources 4112 UNLIMITED 64 0 200 0
ges_big_msgs 1934 UNLIMITED 30 0 530 0
ges_cache_ress 0 UNLIMITED 4098 0 58463 0
ges_locks 25951 UNLIMITED 0 0 0 0
ges_reg_msgs 2350 UNLIMITED 271 0 1760 0
ges_ress 16806 UNLIMITED 0 0 0 0
ges_rsv_msgs 1000 1000 0 0 0 0
max_rollback_segments 973 65535 32 0 84 0
max_shared_servers UNLIMITED UNLIMITED 1 0 1 0
parallel_max_servers 0 3600 1 0 10 0
sort_segment_locks UNLIMITED UNLIMITED 54 0 73 0
temporary_table_locks UNLIMITED UNLIMITED 0 0 3 0
transactions 973 UNLIMITED 15 0 92 0
Thanks in advance,
Danilo