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

Thread: What should be the SGA size, when we have 50 GB of RAM in the server

  1. 11-14-2006, 05:34 AM #1
    skdas
    skdas is offline Member
    Join Date
    Jul 2002
    Posts
    205

    What should be the SGA size, when we have 50 GB of RAM in the server

    Hi,

    What should be the SGA size, when we have 50 GB of RAM in the server?

    What should be the size of dba cache size..?

    This is in Oracle 9.2.0.5.
    Reply With Quote Reply With Quote
  2. 11-14-2006, 05:42 AM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    totally dependant on your application, not how much memory your server has
    Reply With Quote Reply With Quote
  3. 11-14-2006, 06:09 AM #3
    skdas
    skdas is offline Member
    Join Date
    Jul 2002
    Posts
    205
    There should be some maximum till which, I can use.. For example out of 50 GB. Till how much GB I can assign for SGA..?
    Reply With Quote Reply With Quote
  4. 11-14-2006, 09:11 AM #4
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    doesnt matter what the maximum is, you use what your application needs, no more no less
    Reply With Quote Reply With Quote
  5. 11-14-2006, 09:37 AM #5
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    you have to count the number of users as well
    Reply With Quote Reply With Quote
  6. 11-14-2006, 06:04 PM #6
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Quote Originally Posted by skdas
    There should be some maximum till which, I can use.. For example out of 50 GB. Till how much GB I can assign for SGA..?
    50
    Jeff Hunter
    Reply With Quote Reply With Quote
  7. 11-14-2006, 08:59 PM #7
    ixion
    ixion is offline Senior Member
    Join Date
    Jun 2006
    Posts
    259
    Quote Originally Posted by marist89
    50
    I got a good laugh on that one !

    Was that 50 bytes?
    Reply With Quote Reply With Quote
  8. 11-15-2006, 03:19 AM #8
    simply_dba's Avatar
    simply_dba
    simply_dba is offline Senior Member
    Join Date
    Nov 2004
    Location
    Mumbai, India
    Posts
    452
    I got a good laugh on that one !
    Why ?
    There are three kinds of lies: Lies, damned lies, and benchmarks...

    Unix is user friendly. It's just very particular about who it's friends are.

    Oracle 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