3 Replies Latest reply on Mar 22, 2016 11:44 AM by akuncoro

    Concept of Database Initialization Parameter Sizing on Doc. ID 396009.1

    akuncoro

      Hi,

       

      I have no knowledge about SGA or PGA, why PGA on Doc. ID 396009.1 is bigger than SGA?

      This section provides sizing recommendations based on the active Oracle E-Business Suite user counts. The following table should be used to size the relevant parameters:

      Parameter NameDevelopment or Test Instance 11-100 Users101-500 Users501-1000 Users1001-2000 Users
      processes200
      20080012002500
      sessions400400160024005000
      sga_target Footnote 1 1G1G2G3G14G
      shared_pool_size (csp)N/AN/AN/A1800M3000M
      shared_pool_reserved_size (csp)N/AN/AN/A180M300M
      shared_pool_size (no csp)400M600M800M1000M2000M
      shared_pool_reserved_size (no csp)40M60M80M100M100M
      pga_aggregate_target1G2G4G10G20G
      Total Memory Required Footnote 2~ 2 GB~ 3 GB~ 6 GB~ 13 GB~ 34 GB

      I need more information about that?

       

      Thanks,

      aKuncoro