Hi,
So I started to look into database and OS parameters and here is what I found!
OS:
oracle soft nofile 8192
oracle hard nofile 65536
oracle soft nproc 8192
oracle hard nproc 16384
oracle soft stack 10240
oracle hard stack 32768
SQL> SHOW PARAMETER SESSION;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
java_max_sessionspace_size integer 0
java_soft_sessionspace_limit integer 0
license_max_sessions integer 0
license_sessions_warning integer 0
session_cached_cursors integer 50
session_max_open_files integer 20
sessions integer 928
shared_server_sessions integer
SQL> select count(*) from dba_data_files;
COUNT(*)
----------
80
SQL>
I this blog (https://techno4us.blogspot.com/2017/10/performance-tuning-sessionmaxopenfiles.html ) I can see there is a relation between the number of databases and the number of session_max_open_files. So my question is:
1. Should i really increase the value for session_max_open_files?
2.In oracle doumentation this is mentioned about the RANGE OF VALUES for seesion_max_open_files:
1 to either 50 or the value of MAX_OPEN_FILES defined at the operating system level, whichever is less
Since I have 20 in my database does this mean that oracle overrides the -oracle soft nofile 8192- on the OS level and consideres 20 instead?!?!
Anybody have an idea about this?!
I appreciate you comments and recommandations!