Re: Oracle and ASP Error

"Jay" <jerry280_at_yahoo.com> wrote in message news:_vfla.428$Aa.29226_at_news.uswest.net...
> Jim,
>
> The DBA looked this up in his Oracle book and that's where we found the
> details about it. The function was fully tested directly against the
> database before putting it in the application.
>
> What we've found to be the cause of our error is the amount of users
> accessing the application. At night when there are 7 - 10 users, there are
> no problems. During the day when the user count goes up, the problems
begin.
> Would this be due to the fact that Oracle is not installed on the web
> server?
>
> J

Did you try the changes I mentioned in my reply, on comp.database.oracle.misc? The changes I mentioned affect the amount of resources used by your application; it seems like you're producing extra load on the web server.

Is the Oracle server you're connecting to on a different subnet? Have you tuned your Oracle server to allow for enough concurrent sessions?

-Thomas Received on Thu Apr 10 2003 - 11:49:02 CDT