This content has been marked as final. Show 27 replies
Howard excellent post. there are memory caveats too to adding shared servers with the use of the large pool and a whole lot of bugs. Oracle still hasnt been able to perfect the technology but its still better than nothing.
howard, it is really nice post..Thank you..!
Excellent explaination. Thanks
so that, If I am using 11g, which oracle paramater should be used? mts_dispatcher or dispatcher?
thanks a ton.
i am right away sitting on test box,,,testing on stuffs you explained.
Thanks Howard jr for this wonderfull explanation . As in DEDICATED architecture , every connectted user will have a Unix process (PID) assign to it where as
in SHARED architecture , new connection does not cause new server process to be spawned, does that mean in MTS or SHARED server , it does not create
any Unix PID for for connected user ?
Hope i described my doubt clear.
Howardjr... that explanation was simply delightful. Thank you.
Congratulation for your excellent post on dedicated/shared server.
We can easily find whether your database is running in dedicated or shared server by the following command:
ps -ef|grep $ORACLE_SID|grep d000
If the above command shows any output then the database is running in shared server mode. Otherwise its running in dedicated mode.
->Replace $ORACLE_SID with your instance name
->d000 is the dispatcher process
So for your very first OTN post, you dig up a thread of 2007 and post to it... a whole 5 years later?!!
You have started your participation on OTN brilliantly... NOT
I am a fresher. When i checked how to find dedicated server, i read all the posts. so i want to share my thought with you people. Hope you dont mind this.
Edited by: NagarajanS on Jul 24, 2012 1:12 AM
Do NOT resurrect old and dead threads. Have something to say or ask, post a new thread on the subject (and include references to old threads if you think that adds value).
Do NOT hijack other people's threads to ask your question.
Two very simply DO NOT DO rules. Please adhere to them.
what a great sense of humor!!!
So for your very first OTN post, you dig up a thread of 2007 and post to it... a whole 5 years later?!! You have started your participation on OTN brilliantly... NOT
what an excellent choice of words!!
you make me laugh from heart man.
i was unable to stop me from praising you.
Edited by: Maahjoor on 16-Jan-2013 00:44