I am working with a customer who has Discoverer 11.1.1.6 installed on Solaris. They use both Discoverer Plus and Discoverer Viewer but logging into the database from these tools is extremely slow. Here's a quick description of the problem:
End user navigates to the discover plus or viewer page (https://servername/discoverer/plus). This page displays very quickly. The user enters a username, password and database to connect to and clicks “Go”. The “Processing your request” page spins for anywhere from 1.5 to 30 minutes. Towards the end of the wait time I see a session created in the target database and the Discoverer page is displayed. At this point the users say that reports run normally. It’s just that initial connection that takes forever.
The performance seems to really bog down when the user connections reach about 120.
I have been monitoring and think I have ruled out the database, listener and network. I can make JDBC connections from the WebLogic server to the database and run queries almost instantly. The problem seems to be with discover, possibly the JDBC connection pools. Any ideas would be great. I don’t have much experience tuning WebLogic or Discoverer.
When I do a jvm thread dump on the WLS_DISCO server I see a bunch of these:
"SlowRequest BG processor 74" waiting for lock oracle.disco.remote.corba.OPMNSessionActivator@57d64a00 BLOCKED
Thanks!!!