2 Replies Latest reply: Apr 20, 2013 3:55 AM by KR10822864 RSS

    SGA size for new Database

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