-
Changing Dedicated server to Shared Server
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
-
-
Originally posted by engiri
Can we change such configuration after creation of DB or
Only at the time of creation of Db..?
Thanks giri
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...
But I recommend reading the doc's first...
HTH
An expert is one who knows more and more about less and less until he knows absolutely everything about nothing.
-
When you reach your connection limit, only then it's time to go for a shared server configuration...
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
-
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
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.
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
-
Re: Changing Dedicated server to Shared Server
Originally posted by engiri
2. How can I change that to Shared server mode?
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 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)
)
)
Last edited by Thomasps; 12-05-2003 at 02:56 AM.
-
We are using 8.06 where the dispatchers concept
will not be there..?
what can I do in this case..?
Giri
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
|