Thanks for the question, gökhan.
Asked: August 07, 2023 - 1:23 pm UTC
Last updated: August 15, 2023 - 2:12 am UTC
Version: 11G
Viewed 1000+ times
You Asked
hi tom,
First of all, thank you for making such a site.
I am Gökhan from Turkey. I am a system administrator in a private lab.
I've been having a problem with oracle lately and neither the developers nor I could find the cause of this problem. If you have any idea your experience will save me from this problem.
The problem is:
watching with this command on oracle
SELECT * FROM V_SYSTEM_INFO;
Normally the situation is as follows:
Sessions / Active sessions 244 32
Process count / Max/Limit 257 260/8000
But suddenly the number of processes starts to increase, but the number of sessions does not. finally oracle crashes and the final state is as follows:
Sessions / Active sessions 446 324
Process count / Max/Limit 2394 2395/8000
The max process limit used to be 2000 and it was enough for us. I made 8000 to try. but still the crash persists.
I would be very happy if you have any idea about it.
Server: Windows Server 2022
Oracle:11G
and Connor said...
There is no such view as V_SYSTEM_INFO or V$SYSTEM_INFO, so can you clarify - where are you getting this information from?
Maybe run something like this and pass it back to us
SQL> select * from v$resource_limit order by 1;
RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_ALLOCATION LIMIT_VALUE
------------------------------ ------------------- --------------- -------------------- --------------
branches 0 0 1610 UNLIMITED
cmtcallbk 0 2 1610 UNLIMITED
dml_locks 0 31 6440 UNLIMITED
enqueue_locks 37 55 17260 17260
enqueue_resources 31 66 6660 UNLIMITED
gcs_resources 0 0 0 UNLIMITED
gcs_shadows 0 0 0 UNLIMITED
ges_big_msgs 0 0 0 UNLIMITED
ges_cache_ress 0 0 0 UNLIMITED
ges_locks 0 0 0 UNLIMITED
ges_procs 0 0 0 0
ges_reg_msgs 0 0 0 UNLIMITED
ges_ress 0 0 0 UNLIMITED
ges_rsv_msgs 0 0 0 0
k2q_locks 0 0 2928 UNLIMITED
max_rollback_segments 22 22 1610 65535
max_shared_servers 1 2 UNLIMITED UNLIMITED
parallel_max_servers 24 24 240 32767
processes 113 131 960 960
sessions 128 162 1464 1464
smartio_buffer_memory 0 0 0 UNLIMITED
smartio_metadata_memory 0 0 0 UNLIMITED
smartio_overhead_memory 0 0 0 UNLIMITED
smartio_sessions 0 0 0 UNLIMITED
sort_segment_locks 0 4 UNLIMITED UNLIMITED
temporary_table_locks 0 7 UNLIMITED UNLIMITED
transactions 1 4 1610 UNLIMITED
Rating
(2 ratings)
Is this answer out of date? If it is, please let us know via a Comment