Performance issue when multiple users trying to login into Oracle EBS 12.1 at the same time:
Oracle EBS 12.1
Oracle Database 11.2.0.4
Problem Statement:
Multiple users trying to Login to Oracle Apps at same time , ie, when one of the Global Business Unit Comes online.
Most of the connections hangs doing nothing. For those who are already logged in , the forms navigation is extremely slow.
Resolution:
- The performance problem is related
with the fact that a lot of users are connecting at the same time and some
connections get hung for some minutes doing nothing,
it could be due to the fact that oracle 11g jdbc
driver is hanging/blocked by /dev/random ,ie, entropy pool empty.
Usually Forms keeps a pool of jdbc
connections.If more connections are needed, it needs to create
new connections, and sometimes JDBC takes some time to create the connections
because of the /dev/random problem.
The below is the solution:
- -Create
soft link : change in linux /dev/random to be
a link to /dev/urandom.
This will be in effect till the server is rebooted.
In
context files, adding the following in
all the jvm_start_options (forms, oacore, oafm):
-Djava.security.egd=file:/dev/./urandom
And run autoconfig.
Note: Entropy
is the random things generated by a computer and used by Linux to generate
random numbers. Linux
uses the key strokes by an user to generate entropy and the entropy generates
the random numbers in /dev/random.
