Hi All,

We have a front end web application in ASP.net with c#.

The problem is

Our Databse Architecture designed as

Master tables are stored in the master user schema.

The transaction tables are stored in the specific user's schema.

Now we are using master connection for master user schema objects and grant permission to the users for some master objects.

For user's schema objects we are using that specific user connection.

Now it opens each connection for each user.Now there 250 users are there in our production environment.

50-60 users are accessing concurrently tha database through the web application.

All the users are under the single role.

If the number of users will be increased in future,What are the problems occur?

Is there any limitation for oracle connection from application server?

>> All the users are under the single role.

That's OK, so long as it enforces security properly.

*************************************************************
>> Is there any limitation for oracle connection from application server?

Perhaps a few million, but nothing that you would need to worry about.

Oracle 10gAS (on the right server) can support thousands of concurrent users, no problem.

We are using ASP.NET with c#.