Dedicated vs Shared

Printable View

10-28-2005, 03:59 AM
topgun

Dedicated vs Shared

sir's / madam's
need advice

How can you check if what kind of server sertup is my
Oracle Database ? if dedicated or shared ? can i changed the
setup?

and whats the best setup for an OLTP type of database
which has at max of 250 users with 500 sessions...???
but its not always 250 users who are loged in -- it may be
below 50 users at a instance also...

shared or dedicated...?
8 G of RAM my setup (shared - i think)
SGA
shared pool ? 2Gig
buffer cache ? 856MB
large pool ? 1.2Gig
java pool ? 0 - since we dont use JAVA for this
PGA ? 2 Gig

thanks...
10-28-2005, 04:02 AM
davey23uk

I would use dedicated here, you dont seem to have that many sessions.

Anyway to check, look at the server column in v$session when people are connected, it will either say SHARED or DEDICATED (i think).
10-28-2005, 05:01 AM
dhar_kiran

u can check it through
show parameter shared_servers
10-28-2005, 05:18 AM
davey23uk

Quote:

Originally Posted by dhar_kiran

u can check it through
show parameter shared_servers

that wont tell you if it is being used though
10-28-2005, 05:35 AM
dhar_kiran

Quote:

Originally Posted by davey23uk

I would use dedicated here, you dont seem to have that many sessions.

Anyway to check, look at the server column in v$session when people are connected, it will either say SHARED or DEDICATED (i think).

but we can have dedicated sessions in shared server mode also.
if we use show parameter shared_servers and
output is >0 means shared server mode
if 0 then it means dedicated.
10-28-2005, 05:48 AM
waitecj

Quote:

Originally Posted by dhar_kiran

but we can have dedicated sessions in shared server mode also.
if we use show parameter shared_servers and
output is >0 means shared server mode
if 0 then it means dedicated.

shared_servers > 0 alone won't tell you if shared servers are being used.

If shared_servers > 0, but SERVER=DEDICATED is in TNSNAMES.ORA, then the connections are dedicated.
10-28-2005, 01:57 PM
serg1257

use shared server mode when you NAVE TO and your system cannot handle too many prosesses. And your have a lot of sessions which use pretty short transactions.
10-29-2005, 06:51 AM
paragp1981

for finding shared or dedicated how about checking v$dipatcher.
11-03-2005, 04:38 PM
wdfloyd

Also can check listener

You can do a lsnrctl services LISTENER_NAME to show how many dedicated and shared connections have been made. This will at least tell you if shared server connections have been made in the past even if they're aren't any connected right now.

As the other's have said, then you can look at the mts_ init parameters to see what is configured in the database. Typically, you will probably want to go with dedicated server 95% of the time unless there are valid reasons not too.