DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Changing Dedicated server to Shared Server

  1. #1
    Join Date
    Apr 2003
    Posts
    353

    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

  2. #2
    Join Date
    Apr 2003
    Posts
    353
    Can we change such configuration after creation of DB or
    Only at the time of creation of Db..?

    Thanks giri

  3. #3
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  4. #4
    Join Date
    Oct 2002
    Location
    Breda, The Netherlands
    Posts
    317
    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.

  5. #5
    Join Date
    Sep 2001
    Location
    Ohio
    Posts
    334
    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

  6. #6
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    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
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  7. #7
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253

    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.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  8. #8
    Join Date
    Apr 2003
    Posts
    353
    [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

  9. #9
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    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.
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  10. #10
    Join Date
    Apr 2003
    Posts
    353
    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
  •  


Click Here to Expand Forum to Full Width