11g Forms connections not getting closed
Hello All
We have a 2 node Forms and reports server clustered and uses webcache.
Forms& reports version: 11g 11.1.2.1.0
OS: RHEL 6.5
DB: 11.2.0.4
On production instance, we have an issue where there are too many forms processes running and consuming all the memory (32GB)
JVM controller has been implemented.
What we have noticed is the connections are not getting closed. If a user closes his browser without doing a logout, the frmweb processes still keeps running on the server consuming memory
Is there a way to isolate such stale connections ?
Any tuning parameters we would need to implement.
We also have the similar kind of issue with reports server, where we see 100's of report server process running , though the console says there are currently no report jobs running.