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?