查詢RAC環境中例項間資源分配情況

查詢RAC環境中例項間資源分配情況

select * from gv$resource_limit order by RESOURCE_NAME

[@more@]

1* select * from gv$resource_limit order by RESOURCE_NAME

INST_ID RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_ALLOCATION LIMIT_VALUE
---------- ------------------------------ ------------------- --------------- -------------------- --------------------
1 branches 0 0 1820 UNLIMITED
2 branches 0 0 1820 UNLIMITED
2 cmtcallbk 0 2 1820 UNLIMITED
1 cmtcallbk 0 2 1820 UNLIMITED
1 dml_locks 0 280 7280 UNLIMITED
2 dml_locks 0 133 7280 UNLIMITED
2 enqueue_locks 42 93 20092 20092
1 enqueue_locks 40 87 20092 20092
2 enqueue_resources 42 115 7500 UNLIMITED
1 enqueue_resources 41 242 7500 UNLIMITED
1 gcs_resources 273224 287667 400056 400056
2 gcs_resources 388091 551736 639222 639222
2 gcs_shadows 398082 639182 639222 639222
1 gcs_shadows 287366 291812 400056 400056
1 ges_big_msgs 58 89 2015 UNLIMITED
2 ges_big_msgs 45 534 2015 UNLIMITED
2 ges_cache_ress 2884 6920 0 UNLIMITED
1 ges_cache_ress 2621 23659 0 UNLIMITED
2 ges_locks 0 0 48575 UNLIMITED
1 ges_locks 0 0 48575 UNLIMITED
2 ges_procs 145 368 1501 1501
1 ges_procs 302 586 1501 1501
2 ges_reg_msgs 128 970 3750 UNLIMITED
1 ges_reg_msgs 159 820 3750 UNLIMITED
1 ges_ress 0 0 31331 UNLIMITED
2 ges_ress 0 0 31331 UNLIMITED
2 ges_rsv_msgs 0 0 1000 1000
1 ges_rsv_msgs 0 0 1000 1000
2 max_rollback_segments 12 44 1820 65535
1 max_rollback_segments 12 270 1820 65535
2 max_shared_servers 1 1 UNLIMITED UNLIMITED
1 max_shared_servers 1 1 UNLIMITED UNLIMITED
1 parallel_max_servers 1 7 160 3600
2 parallel_max_servers 1 8 160 3600
2 processes 146 370 1500 1500
1 processes 303 588 1500 1500
1 sessions 311 597 1655 1655
2 sessions 153 379 1655 1655
2 sort_segment_locks 0 4 UNLIMITED UNLIMITED
1 sort_segment_locks 0 4 UNLIMITED UNLIMITED
1 temporary_table_locks 0 3 UNLIMITED UNLIMITED
2 temporary_table_locks 0 5 UNLIMITED UNLIMITED
1 transactions 7 272 1820 UNLIMITED
2 transactions 3 74 1820 UNLIMITED