Guestimating memory requirements after upgrade
I'm working on a project to upgrade about 80 production databases (and 300+ test/dev) from 9i to either 10g or 11g, and 10g to 11g depending on the restrictions of the applications. Most are on Solaris 9 or 10 with a few on Windows 2003. There are databases at just about every patchset.
I'm trying to guestimate the memory requirements, and wondered if anyone has a simple algorithm for extrapolating from the memory required at 9i to the 10g/11g requirements, or from 10g to 11g.
By trial and error, I've worked a minimum requirement for 10g of 220-300M, depending on the OS version (Solaris 9 seems to need more than Solaris 10), compared with the minimum of 312M in utlu102i.sql.
I'm trying to guestimate the memory requirements, and wondered if anyone has a simple algorithm for extrapolating from the memory required at 9i to the 10g/11g requirements, or from 10g to 11g.
By trial and error, I've worked a minimum requirement for 10g of 220-300M, depending on the OS version (Solaris 9 seems to need more than Solaris 10), compared with the minimum of 312M in utlu102i.sql.
0