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