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

Thread: Dedicated vs Shared

Threaded View

  1. 10-28-2005, 05:35 AM #3
    dhar_kiran
    dhar_kiran is offline Junior Member
    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 05:39 AM.
    ~KD.DBA~
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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