How many shared servers are to be configured?

hi Friends

How can we determine how many shared servers are needed when we are using 
shared server configuration in database? 

Swathigo,

Do yourself a favor and drop shared server idea altogether -- stick with 
dedicated server on the database.

If you have a middle-tier then use a connection pool on it (application server) 
or better yet go with 11gR2 Database Resident Connection Pool (DRCP).

HTH,
- Vitaliy

Hi Vitaly

But the problem we had was we have many users(almost 750 users were beiong 
connected) connecting to our application and connections are not getting 
released and we are not able to connect database through nornmal sql plus. So 
we are shutdown databse and restarting it. Previous to this only upto 250 users 
were connected.Now users have increased. So we were advised to change 
cobfiguration to MTS and use connection pool in our Application server ie 
Weblogic. Our databse size is now 190GB.

regards
swathi


> Swathigo,
> 
> Do yourself a favor and drop shared server idea altogether -- stick with 
> dedicated server on the database.
> 
> If you have a middle-tier then use a connection pool on it (application 
> server) or better yet go with 11gR2 Database Resident Connection Pool 
> (DRCP).
> 
> HTH,
> - Vitaliy

You should NEVER use both (application server connection pool and database 
shared servers together) -- choose only one.  In your case your best solution 
is to use ONLY application server connection pool and to keep dedicated server 
on the database.

Hi Vitaliy

thanks for the guidance. will be configuring as suggested.

Regards
Swathi