To check IT reached max utilization of process parameter. in Oracle

example to change the parameter for v$resource_limit  ALTER SYSTEM SET processes=10000 SCOPE=SPFILE;
SQL> select * from v$resource_limit ;
 
RESOURCE_NAME                  CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_AL LIMIT_VALU
------------------------------ ------------------- --------------- ---------- ----------
processes                                     1607            4000       4000       4000
sessions                                      1596            4005       4405       4405
enqueue_locks                                 1380            6280      57390      57390
enqueue_resources                              563            2901      19600  UNLIMITED
ges_procs                                        0               0          0          0
ges_ress                                         0               0          0  UNLIMITED
ges_locks                                        0               0          0  UNLIMITED
ges_cache_ress                                   0               0          0  UNLIMITED
ges_reg_msgs                                     0               0          0  UNLIMITED
ges_big_msgs                                     0               0          0  UNLIMITED
ges_rsv_msgs                                     0               0          0          0
gcs_resources                                    0               0          0          0
gcs_shadows                                      0               0          0          0
dml_locks                                       43             718      19380  UNLIMITED
temporary_table_locks                            0               3  UNLIMITED  UNLIMITED
transactions                                   306             722       4845  UNLIMITED
branches                                         1              13       4845  UNLIMITED
cmtcallbk                                        2               4       4845  UNLIMITED
sort_segment_locks                            1594            4451  UNLIMITED  UNLIMITED
max_rollback_segments                          136             361       4845      65535
max_shared_servers                               0               0  UNLIMITED  UNLIMITED
parallel_max_servers                          1324            3600       2560       3600
 
22 rows selected.



No comments: