Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Dedicated vs Shared Question

SCDANMar 21 2013 — edited Mar 21 2013
I 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
This post has been answered by Pavan DBA on Mar 21 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 18 2013
Added on Mar 21 2013
16 comments
1,995 views