Dedicated vs Shared Question
SCDANMar 21 2013 — edited Mar 21 2013I am trying to understand if my DB is running dedicated or shared. I have read several posts here but some of the information is contradicting each other on my server. This is my analysis so far and it leads me to believe that I am running in dedicated server mode but I would love some help to better understand if I am right. Thanks in advance for your help!
1. We have a dispatcher but you always get on when you create a DB with DBCA and this does not mean the DB runs in shared.
SQL> show parameter dispatcher
NAME TYPE
------------------------------------ --------------------------------
VALUE
------------------------------
dispatchers string
(PROTOCOL=TCP)
max_dispatchers integer
2. Large_poole_size is 0 and I think if the DB is shared then it will use the large pool, otherwise use the shared pool.
SQL> show parameter large_pool
NAME TYPE
------------------------------------ --------------------------------
VALUE
------------------------------
large_pool_size big integer
0
3. If shared_servers is greater than 1 then the server is shared but ours is set to 1.
SQL> show parameter SHARED_SERVERS
NAME TYPE
------------------------------------ --------------------------------
VALUE
------------------------------
max_shared_servers integer
shared_servers integer
1
4. The tnsnames.ora file has SERVER=DEDICATED which means the DB will NOT be shared regardless of above.
5. ps -ef|grep $ORACLE_SID|grep d000 shows a dispatcher but I think this is just the default one.
oracle 4456 1 0 Mar17 ? 00:00:55 ora_d000_ENGTREQ1