TOracle Session

[Ahmed Samir]

I developed an ISAPI application that uses TOracleSession. The problem is after reaching 59 session in memory all sessions are destroyed and new sessions is created. During this small laps of time (between destroying and re-creating) a lot of requests get an "Internal Server Error" as an answer. Is there any method to increase the number of sessions processes in the TOracle session component. And if not is there a solution for not having this error.

thanks

 

[Marco Kalter]

59 sessions is a lot, but it would be useful to know what the "Internal Server Error" actually is. Maybe you have run into some limit.

------------------
Marco Kalter
Allround Automations

 

[Ahmed Samir]

What I do is: I test the application by an application called web application stress. I test with about 450 threads (users) since the application will be used by about 3000 users. so the no. of hits per seconds reaches 20 - 24. I use a COM connection and I set the max number of connections to 100.
what could be the error. I don't have this errors when about 6 users uses the application normally. however I need to stress it because the large no. of users I have

 

[PColbert]

Originally posted by mkalter:
59 sessions is a lot, but it would be useful to know what the "Internal Server Error" actually is. Maybe you have run into some limit.

I believe you are right. An Oracle server here defaults to SESSIONS=69 (see table v$parameter). Our friend may need to explicitly increase this parameter. The upper limit is 32767 on Oracle 8.0.

I do not know how much additional memory this might require. If it does not require much memory, please let me know, as using multple sessions could solve some problems for me.