Find out Maximum, Current Limit of Oracle Resources (Session, Process, Lock) using v$resource_limit


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.
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google