Sunday, May 5, 2013

Database Initialization Parameters for R12

Database Initialization Parameter Sizing

This 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 Instance11-100 Users101-500 Users501-1000 Users1001-2000 Users
sga_target Footnote 11G1G2G3G14G
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
Total Memory Required Footnote 2~ 2 GB~ 3 GB~ 6 GB~ 13 GB~ 34 GB

Reference: Database Initialization Parameters for Oracle E-Business Suite Release 12 [ID 396009.1]

No comments:

Post a Comment