APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Slow login to APEX application

Krishna VashisthaMay 5 2011 — edited May 26 2011

I was working with Oracle 11g R1 with Apex 4.0, with all my applications running absolutely fine. I recently upgraded my database to Oracle 11g R2. Since then, just after fresh up-gradation of my development environment, i tried to login to one of my application and resulted to a long wait of 5min to pass through my custom built Authentication Scheme.
i still have access to my previous environment with Oracle 11g R1 version, and still its flying high with good results, but no idea what is causing this issue in Oracle 11g R2.

I tried some of the suggestion provided here at OTN forums, like increasing the default value of SHARED_SERVERS from 1 to 5, but no help. Had also verified the same SHARED_SERVERS value on my previous environment setup with Oracle 11g R1, which was found to be set with the default value as 1.

ALTER system SET shared_servers = 5 scope=both;
ALTER system register;

I tried to set with SHARED_SERVERS = 50, after reboot, the applications responded well in time and was perfect. But the very next morning, again the performance of the app's login was back to the 5min long wait time. I verified the SHARED_SERVERS value, but no help, it was 50 already.

So I'm clueless about this situation.
Is Oracle 11g R2 causing the difference?

Kindly suggest please.