ORACLE v$resource_limit

select * from v$resource_limit;

아래와 같은 결과로 processes, sessions 의 개수가 LIMIT 를 넘어서면

ORACLE 에러가 발생할수 있다.

ORA-03113: 통신 채널에 EOF 가 있습니다

processes 108 116       150       150

sessions 111 119       170       170

enqueue_locks 35 48      2300      2300

enqueue_resources 35 61       968 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 0 72       748 UNLIMITED

temporary_table_locks 0 3 UNLIMITED UNLIMITED

transactions 0 16       187 UNLIMITED

branches 0 16       187 UNLIMITED

cmtcallbk 0 1       187 UNLIMITED

sort_segment_locks 0 4 UNLIMITED UNLIMITED

max_rollback_segments 11 11       187     65535

max_shared_servers 1 1 UNLIMITED UNLIMITED

parallel_max_servers 0 0        40      3600