Database Reference
In-Depth Information
/
INT RESOURCE_NAME CU MU IA LV
---- -------------------- ---------- ---------- ---------- ----------
4 gcs_resources 267451 902764 2933330 2933330
gcs_shadows 370593 1201829 2933330 2933330
ges_big_msgs 15 177 1730 UNLIMITED
ges_cache_ress 1935 10779 0 UNLIMITED
ges_locks 117376 122591 30568 UNLIMITED
ges_procs 52 250 507 507
ges_reg_msgs 112 423 1730 UNLIMITED
ges_ress 207337 214851 23093 UNLIMITED
ges_rsv_msgs 0 2 1000 1000
5
gcs_resources 733332 1225463 733332 733332
gcs_shadows 666100 1108372 733332 733332
ges_big_msgs 19 665 1730 UNLIMITED
ges_cache_ress 65694 66002 0 UNLIMITED
ges_locks 116840 122653 30568 UNLIMITED
ges_procs 50 361 507 507
ges_reg_msgs 112 2327 1730 UNLIMITED
ges_ress 290784 296283 23093 UNLIMITED
ges_rsv_msgs 0 1 1000 1000
6 gcs_resources 434030 1539482 3666663 3666663
gcs_shadows 412483 1465106 3666663 3666663
ges_big_msgs 19 1136 1730 UNLIMITED
ges_cache_ress 48859 49008 0 UNLIMITED
ges_locks 162986 167576 30568 UNLIMITED
ges_procs 57 275 507 507
ges_reg_msgs 148 2933 1730 UNLIMITED
ges_ress 211414 292337 23093 UNLIMITED
ges_rsv_msgs 0 1 1000 1000
8 gcs_resources 346997 1154116 3666663 3666663
gcs_shadows 428505 1504463 3666663 3666663
ges_big_msgs 21 558 1730 UNLIMITED
ges_cache_ress 1935 14602 0 UNLIMITED
ges_locks 178960 183777 30568 UNLIMITED
ges_procs 75 337 507 507
ges_reg_msgs 123 475 1730 UNLIMITED
ges_ress 208104 276539 23093 UNLIMITED
ges_rsv_msgs 0 2 1000 1000
Step 2
Instance 5 could be low on global resources; the MU (
MAXIMUM_UTILIZATION
) has increased and is significantly
high (1225463), whereas the IA
(INITIAL_ALLOCATION
) and the CU (
CURRENT_UTILIZATION
) are identical and low,
indicating at times instance 5 was low on shared pool resources or there was significant utilization of global resources.
The memory allocated for GES resources and communications buffers is part of the SGA and shared pool. It is
not used by the library cache and also cannot be configured via the server parameter file.
Search WWH ::
Custom Search