This discussion is archived
2 Replies Latest reply: Apr 20, 2013 1:55 AM by KR10822864 RSS

SGA size for new Database

shiva_oracle Newbie
Currently Being Moderated
Version: Oracle 11gR2

I want to setup a new database for an application. Application may have 800 users.

How do calculate the initial size of the SGA for this new database. Is there any formula to determine the SGA size for a database. How do we know a database has appropriate SGA size?
  • 1. Re: SGA size for new Database
    sybrand_b Guru
    Currently Being Moderated
    Is there any formula to determine the SGA size for a database.
    There is no formula
    How do we know a database has appropriate SGA size?
    By using a view like v$sga_target_advice

    ---------------
    Sybrand Bakker
    Senior Oracle DBA
  • 2. Re: SGA size for new Database
    KR10822864 Pro
    Currently Being Moderated
    shiva_oracle wrote:
    Version: Oracle 11gR2

    I want to setup a new database for an application. Application may have 800 users.

    How do calculate the initial size of the SGA for this new database. Is there any formula to determine the SGA size for a database. How do we know a database has appropriate SGA size?
    refer below links.

    SGA and PGA size
    http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:30011178429375

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points