Is there a good way to have some idea on what your Threads and websockets should be set to in IFS Middleware server? We have increased these many times over the years but I’d like to be more proactive instead of waiting for a problem to crop up and after reviewing HTTP logs we can see we need more websockets.
FYI - currently we are at 3600 Threads and 2700 Websockets.
this query is reporting 3383 open connections.
select sum(a.value) from v$sesstat a, v$statname b, v$session s WHERE A.statistic# = b.statistic# AND s.SID=A.SID AND b.NAME = 'opened cursors current';