4 Replies Latest reply: Jan 30, 2013 11:36 AM by Helios-GunesEROL RSS

    11.5.10.2 to R12.1.3 upgrade

    615419
      why the Database size is bigger in R12 than in 11i after upgrade?
        • 1. Re: 11.5.10.2 to R12.1.3 upgrade
          Srini Chavali-Oracle
          Mainly because of 3 reasons

          1. R12 has more code than 11i, so this will account for an increase in the SYSTEM tablespace.
          2. R12 has additional modules over 11i, so this will account for increases in DATA and INDEX (and other) tablespaces for the new tables and indexes.
          3. Data in existing modules (such as Financials) has been rearchitected and additional tables/indexes have been created and the upgrade populates them, while leaving data in the old unused tables. This will also account for an increase in size of the DATA and INDEX (and other) tablespaces.

          HTH
          Srini
          • 2. Re: 11.5.10.2 to R12.1.3 upgrade
            Helios-GunesEROL
            Hi;
            why the Database size is bigger in R12 than in 11i after upgrade?
            R12 has many new future so it also has huge setup than r11. So its normal behaviour to have bigger db size

            Regard
            Helios
            • 3. Re: 11.5.10.2 to R12.1.3 upgrade
              Hussein Sawwan-Oracle
              user612416 wrote:
              why the Database size is bigger in R12 than in 11i after upgrade?
              - More Schemas
              - More Database Objects
              - More Data

              Please see (Oracle Applications Release 12 Upgrade Sizing and Best Practices [ID 399362.1]).

              Thansk,
              Hussein
              • 4. Re: 11.5.10.2 to R12.1.3 upgrade
                Helios-GunesEROL
                Hi Hussein Sawwan
                why the Database size is bigger in R12 than in 11i after upgrade?
                - More Schemas
                - More Database Objects
                - More Data

                Please see (Oracle Applications Release 12 Upgrade Sizing and Best Practices [ID 399362.1]).
                Great note sharing as you always do ;)

                Regard
                Helios