Re: role based security, number of connections to Oracle etc -- question on understanding

>Here is my question. Does this all mean that for every user connected
>using the new system (ie the system in a browser not the old system
>with MS Access), there is a connection to the Oracle instance? Does
>this mean that if 520 users connected at once using the new system
>there would be at least 520 connections to the Oracle database? And is
>520 users a lot or could this be done in a better way.

Depends on how the middleware manages database connections. It may use connection pooling and re-authorize for certain instanceID for each call, then clean up and return connection to the pool. In this case, number of database sessions can be lower than the number of users and sessions are reused.

It may keep a dedicated session for each authorized user, in this case there will be 1-1 relationship between users and sessions. However, if the user simply closes the browser and there's no onclose event handler which could signal the middleware that the user finished with the application, there can be quite a few dead connections (established, but with no user behind them,) in this case, so the middleware should be able to track user activity and eventually timeout and close such sessions.

Given the amount of detail you have it's hard to tell which of the above (if any) is true.

Regards,

    Vladimir M. Zakharychev
    N-Networks, makers of Dynamic PSP(tm)     http://www.dynamicpsp.com Received on Sat May 13 2006 - 06:53:59 CDT