| shared server mode [message #459950] |
Wed, 09 June 2010 02:41  |
sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS
|
Member |
|
|
Hi all,
I have a sun server V890 with solaris 10 installed.
DB version is 10.2.0.1.0.
RAM: 32 gb
SGA : 6GB
I have increased the number of processes to 5000. The number of processes keep increasing.
Right now, i am using dedicated server mode. I am planning to moved to shared server mode.
I want to know whether after configuring shared server mode, will the situation be change with connection pooling. Furthermore, have 6 application servers.
4 are using wlogic and 2 are using Glass Fish application server.
If ever i am using shared server mode, the client can connect with JDBC or tnsnames or JDBC only?
thanks,
Sailesh
|
|
|
|
|
|
| Re: shared server mode [message #459956 is a reply to message #459952] |
Wed, 09 June 2010 03:05  |
sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS
|
Member |
|
|
Hi,
Thanks for your reply. Will shared server mode reduce my processes on the database. Does pooling using share server mode affect my clients.
Is there any advantages while using share server mode instead of dedicated server mode?
Thanks,
Sailesh
|
|
|
|
|
|
| Re: shared server mode [message #459977 is a reply to message #459968] |
Wed, 09 June 2010 04:54 |
sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS
|
Member |
|
|
Right now I have about 2000 concurrent users on my database. Will be wise to configure shared server mode. Furthermore, for the number of users i.e 2000 3000, can you just specify these parameter in number:
Shared_servers:
Max_shared_servers;
Shared_server_sessions:
Dispatchers:
Max_dispatches
Circuits:
What about wait on client side, if the number of virtual circuits is limited. Furthermore, according to your experience, a database of around 2000-3000 concurrent users what is most effective; shared or dedicated.
Please your help is invaluable for me.
|
|
|
|
| Re: shared server mode [message #459982 is a reply to message #459977] |
Wed, 09 June 2010 05:04 |
 |
Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...
|
Senior Member
Account Moderator |
|
|
Quote:can you just specify these parameter in number:
I can't, it depends on your application and server limits.
Quote:Furthermore, according to your experience, a database of around 2000-3000 concurrent users what is most effective; shared or dedicated.
Once again it depends on your application and server limit.
If your server well supports dedicated then it is better to use dedicated.
Regards
Michel
[Updated on: Wed, 09 June 2010 05:07] Report message to a moderator |
|
|
|
| Re: shared server mode [message #459993 is a reply to message #459982] |
Wed, 09 June 2010 05:28 |
sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS
|
Member |
|
|
Hi,
These are the initialisation parameters for shared server mode.
I am using weblogic 9.2 as application server.
Thanks,
Sailesh
|
|
|
|
|
|
| Re: shared server mode [message #460010 is a reply to message #460003] |
Wed, 09 June 2010 06:22 |
|
Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...
|
Senior Member
Account Moderator |
|
|
As you want.
For security purpose I recommend OCI driver (tnsnames) but this requires installing an Oracle client on the client side.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
