Hi
1. How can I view whether my database is running in Dedicated Server mode?
2. How can I change that to Shared server mode?
Thanks
Giri
Printable View
Hi
1. How can I view whether my database is running in Dedicated Server mode?
2. How can I change that to Shared server mode?
Thanks
Giri
Can we change such configuration after creation of DB or
Only at the time of creation of Db..?
Thanks giri
Do your home work! RTFM
http://download-west.oracle.com/docs...proc.htm#13880
:D
You can change from dedicated to shared server when your db is deployed. You'll have to alter the ini-file and bounce the db.Quote:
Originally posted by engiri
Can we change such configuration after creation of DB or
Only at the time of creation of Db..?
Thanks giri
Why are you switching to shared server? It is only necessary when your db can't cope with the amount of concurrent users. When you reach your connection limit, only then it's time to go for a shared server configuration...
But I recommend reading the doc's first...
HTH
I've also had to use Shared server when the dedicated sessions were taking up too much RAM. I had one app where each Dedicated Session took 20-50+ MEG of memory. With 30+ sessions, and a box that had only 2 Gig of memory, it was killing the machine. Went to shared server and the problem went away.Quote:
When you reach your connection limit, only then it's time to go for a shared server configuration...
Jodie
You know the reason that it's saving you memeory though, don't you? It's because it's choking the number of sessions that can be active at any point in time.Quote:
Originally posted by jodie
I've also had to use Shared server when the dedicated sessions were taking up too much RAM. I had one app where each Dedicated Session took 20-50+ MEG of memory. With 30+ sessions, and a box that had only 2 Gig of memory, it was killing the machine. Went to shared server and the problem went away.
Jodie
20-50Mb per user seems like a huge amount though. I'd be suprised if you couldn't have knocked it down. Or added more memory
the two are not mutually exclusive, you know. It's often desirable to have a mixed environment of shared and dedicated connections on the same instance.Quote:
Originally posted by engiri
2. How can I change that to Shared server mode?
[QUOTE]Originally posted by efrijters
[B]You can change from dedicated to shared server when your db is deployed. You'll have to alter the ini-file and bounce the db.
Why are you switching to shared server? It is only necessary when your db can't cope with the amount of concurrent users. When you reach your connection limit, only then it's time to go for a shared server configuration...
SORRY.. WHAT ARE THE MANDATORY PARAMETERS TO BE APPLIED IN
THE INI FILE..?
YES.. MY USERS ARE INCREASED .. AND IT IS HIGHLY REQUIRED TO GO FOR SHARED SHARED SERVER...
HOW TO RESTRICT SOME USERS TO CONNECT IN DEDICATED MODE AND
ALLOWING OTHERS IN SHARED MODE..
THANKS
GIRI
DISPATCHERS (Mandatory)
MAX_DISPATCHERS
SHARED_SERVERS
MAX_SHARED_SERVERS
SHARED_SERVER_SESSIONS
And give attention to
LARGE_POOL_SIZE
In Tnsnames.ora
TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = TEST)
(SERVER=DEDICATED)
)
)
We are using 8.06 where the dispatchers concept
will not be there..?
what can I do in this case..?
Giri
In 8.0, the parameters are different, They are
mts_dispatchers
mts_max_dispatchers
mts_servers
mts_max_servers