Re: Oracle and ASP Error

Thomas,

We did try your suggestion and you were right, it did improve the performance! We still had the error coming up though. We are going to try to install the Oracle application on the web server and see what happens there instead.

I'll report back with the results (hopefully good!)

J

"Thomas T" <T_at_T> wrote in message news:3e95a2e9$1_at_rutgers.edu...
> "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 - 15:40:14 CDT