I am brand new to being a DBA and have not really been trained in how to be a DBA. We have recently moved our system to a Windows Server 2008 R2 box with Application Express 4.2.1.00.08 and
Listener 2.0 with ASM. During a certain time range we have several users trying to access the same program. It doesn't take very many users to lock up the system so that no one can get to it. I would
really appreciate any help in trying to solve this problem. Thank you in advance!
Check web server and database logs if there is useful information about problem.
You should try debug application
These blog post might also help
My Blog: http://dbswh.webhop.net/htmldb/f?p=BLOG:HOME:0