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

Thread: Computing for SGA

  1. 02-22-2001, 04:24 PM #1
    edsperez
    edsperez is offline Member
    Join Date
    Jan 2001
    Location
    St. Louis. MO
    Posts
    151

    Question

    Hi Guys,

    I just want to ask what are the things that needs to be consider in estimating the size of SGA (System Global Area) for a new database? Normally I make the adjustment once the database is running. I look at the OEM performance monitor and base from there I make adjustment on the init.ora parameters.

    Suppose I have a single box and I have to create several oracle instances, What things do I need to consider and what formula to use to compute SGA?

    Thanks,

    Perez
    Reply With Quote Reply With Quote
  2. 02-22-2001, 04:50 PM #2
    sreddy's Avatar
    sreddy
    sreddy is offline Senior Advisor
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    It depends upon the version of Oracle you will be using. Follow this link.

    [url]http://www.dbasupport.com/forums/showthread.php?threadid=6910[/url]
    Reddy,Sam
    Reply With Quote Reply With Quote
  3. 02-22-2001, 06:42 PM #3
    edsperez
    edsperez is offline Member
    Join Date
    Jan 2001
    Location
    St. Louis. MO
    Posts
    151
    Thanks a lot

    [QUOTE][i]Originally posted by sreddy [/i]
    [B]It depends upon the version of Oracle you will be using. Follow this link.

    [url]http://www.dbasupport.com/forums/showthread.php?threadid=6910[/url] [/B][/QUOTE]
    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