Problem with database connection

gigi

gigi

VIP Member
Hi All,
We are testing (stress test) an EnterpriseOne 9.1 installation. Our configuration is:
- Database Oracle 11gR2 RAC - 2 nodes on 2 Solaris servers
- Enterprise server Win 2008 R2
- 2 WebLogic server on Linux Redhat (test executed activating one instance for one server, two intance for one server and finally two instances for two servers)

EnterpriseOne Tool Release is 9.1.0.4

Within third test we reached up to 400 hundreds users.
Starting from first test (one instance for one server) through last server we encountered a big problem with database connection. I mean for example:
- 30 users connected. 198 Oracle database sessions opened from only one web server (156 sessions are querying F986110)

- 150 users connected. 950 Oracle database sessions opened from only one web server (750/800 sessions are querying on F986110)

Anyone knows if there are known problems related to database connections for "Recent Reports" within carousel? Or related to wsj application?
Thanks in advance
gg
 
We registered with Oracle Application Test Suite a script to insert a sales order, manage request and suggestion (advance warehouse). Analyzing this script we encountered 28 calls to "Recent Reports" (recentreport.mafservice)
 
Found and resolved this.......and got the T-Shirt:

Solution ID 1488975.1

Issue occurs on all releases of 9.1.0.X..resolved in 9.1.2.X

I've installed a POC for 9.1.0.4 at 12 locations.
 
Thanks a lot Colin!!!!!
I contact Oracle support for POC.

Have a nice day!!!!!
gg
 
Back
Top