When you try to login in Essbase it will take sometime more than 10 Mins to load.
This generates stuck threads in the EAS logs.
This is due to Setting sqlnet.expire_time=10 is missing from SQLNET.ora.
The following line should be added to SQLNET.ora file:
Create an Oracle 11g database with AL32UTF8 character set encoding, and set the following database parameters:
OPEN_CURSORS – 5000
PROCESSES – 1000
SESSIONS – 2000
SESSION_CACHED_CURSORS – 200
The sqlnet.ora file in the database server should have the following setting: sqlnet.expire_time=10.