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.
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.
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
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.