Message-Id: <10661.120343@fatcity.com> From: Scott Lockhart Date: Thu, 26 Oct 2000 13:04:23 -0500 Subject: Size of SGA needed to run pinning script ADXGNPIN.sql in OA Release11i Folks, In an Oracle Applications Release 11i implementation, has anyone run the ADXGNPIN.sql script unaltered, so that it pins everything? If so, any idea how much memory this requires? I will eventually pin just the objects we really use, but I would like to know worse case how much memory is needed for the full-blown ADXGNPIN.sql on Release 11i. I am working on a new Release11i implementation, and the present SGA is puny (say 350 MB). Running ADXGNPIN.sql as is fails due to lack of space in the SGA (what a surprise :). I'm trying to establish a sizing for the SGA, and would like to determine how much to dedicate strictly for the shared pool and pinned objects. Thanks in advance, Scott Lockhart Senior Consultant