-
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...
-
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).
-
u can check it through
show parameter shared_servers
~KD.DBA~
-
Originally Posted by dhar_kiran
u can check it through
show parameter shared_servers
that wont tell you if it is being used though
-
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.
Last edited by dhar_kiran; 10-28-2005 at 05:39 AM.
~KD.DBA~
-
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.
Assistance is Futile...
-
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.
-
for finding shared or dedicated how about checking v$dipatcher.
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|