Hi,

We have our oracle 10g database running on a shared mode configuration.

We have set the SESSIONS_PER_USER parameter in DBA_PROFILES for the current user to 400.

Now when we connect through the application and reach 100 inactive connections, we get this error "connection timeout".
This problem is machine specific.
Like if I connect the application to the db from machine "A" and it reaches 100 inactive sessions, it times out but at the same time I am able to connect the application from machine "B"..and even this machine B timesout after reaching 100 inactive connections.

Can anyone help me with this...if I ve given SESSIONS_PER_USER to be 400 for the user, why does it stop giving connections after 100?

Thanks
Sam