advertisements
_____________________________________________________________________________________________________________________
V$resource_limit dynamic view provides the details of resources like sessions, processes, locks etc. It has the initialization values for the resources, maximum limit reached after the last database startup and current utilization of the resource.
SQL> desc v$resource_limit
Name
--------------------------------------
RESOURCE_NAME = Name of the resource CURRENT_UTILIZATION = Number of resource currently being used MAX_UTILIZATION = Maximum consumption of the resource since last starup
INITIAL_ALLOCATION = Initial allocation for the resource
LIMIT_VALUE = This value can be greater than the initial allocation
SQL> show parameter session
NAME TYPE VALUE
------------------------------------ ----------- ------------
sessions integer 1560
SQL> show parameter process
NAME TYPE VALUE
------------------------------------ ----------- ------------
processes integer 1024
SQL> select resource_name, current_utilization cur_util ,max_utilization max_util ,INITIAL_ALLOCATION Allocated from v$resource_limit;
RESOURCE_NAME CUR_UTIL MAX_UTIL ALLOCATED
------------------------------ ---------- ---------- ---------------
processes 122 402 1024
sessions 133 416 1560
enqueue_locks 99 409 19710
enqueue_resources 25 115 8884
ges_procs 117 395 1025
ges_ress 41876 182563 34248
ges_locks 12446 111329 50845
ges_cache_ress 5953 9077 0
ges_reg_msgs 144 1889 2778
ges_big_msgs 24 543 1888
ges_rsv_msgs 0 0 1000
gcs_resources 38227 188110 166766
gcs_shadows 33841 124864 166766
dml_locks 0 0 6864
temporary_table_locks 0 3 UNLIMITED
transactions 0 0 1716
branches 0 1 1716
cmtcallbk 0 2 1716
max_rollback_segments 12 13 1716
sort_segment_locks 0 34 UNLIMITED
k2q_locks 0 1 3120
max_shared_servers 1 1 UNLIMITED
parallel_max_servers 1 21 20
23 rows selected.
_____________________________________________________________________________________________________________________
0 comments:
Post a Comment