Working on Dedicated Server, will it cause any problem!! [message #59375] |
Fri, 14 November 2003 00:05 |
sachin kumar gupta
Messages: 157 Registered: March 2003
|
Senior Member |
|
|
Hi,
I have Oracle 9i on Windows 2K Server. I have one db named MIS. Accidently I went through services.ora file where I found :
mis = (ORACLE_DATABASE, jupiter, (DESCRIPTION=(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = jupiter)(PORT = 1521)) ) (CONNECT_DATA=(SID=MIS)(SERVER=DEDICATED))), (PROP=(LSNRS=listener_jupiter)(ORACLE_HOME=d:oracleora90)(ORACLE_SID=MIS)))
& I got to know that server is in dedicated mode. I think it should be better in shared mode. Even I haven't faced any problem till now in dedicated mode.
Shall any changes if made to shared mode will harm to users?? Or I leave that as it is (in future users should not complaint).Pls. let me know.
TIA,
Sachin
|
|
|
|
Re: Working on Dedicated Server, will it cause any problem!! [message #59378 is a reply to message #59375] |
Fri, 14 November 2003 05:27 |
Thiru
Messages: 1089 Registered: May 2002
|
Senior Member |
|
|
Sachin,
Why do you think shared is better ?
IF you can avoid it , AVOID it. Dedicated gives you much better performance! Always try to use dedicated servers unless you are totally starved of resources,have 100s and 1000s of connections that connect & disconnect very frequently and if you have no other choice..
If you can scale up with dedicated servers,then continue use them.If you cant further scale your usage using dedicated,then you 'may' want to consider shared servers. Even then I would fight with my IT director to get more resources(ie CPU,memory), instead of going to shared.
-Thiru
|
|
|
|
|
|