Dedicated vs Shared
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: Dedicated vs Shared

  1. #1
    Join Date
    Sep 2005
    Location
    Philippines
    Posts
    21

    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...

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    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).

  3. #3
    Join Date
    Sep 2005
    Location
    Delhi
    Posts
    78
    u can check it through
    show parameter shared_servers
    ~KD.DBA~

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    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

  5. #5
    Join Date
    Sep 2005
    Location
    Delhi
    Posts
    78
    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.
    Last edited by dhar_kiran; 10-28-2005 at 06:39 AM.
    ~KD.DBA~

  6. #6
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    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.
    Assistance is Futile...

  7. #7
    Join Date
    Oct 2005
    Posts
    10
    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.

  8. #8
    Join Date
    Apr 2003
    Location
    Pune,Maharashtra. India.
    Posts
    245
    for finding shared or dedicated how about checking v$dipatcher.

  9. #9
    Join Date
    Nov 2005
    Location
    Indianapolis
    Posts
    24

    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
  •  


Click Here to Expand Forum to Full Width