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.
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;
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment