Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Size of SGA needed to run pinning script ADXGNPIN.sql in OA Release11i

Size of SGA needed to run pinning script ADXGNPIN.sql in OA Release11i

From: Scott Lockhart <sdlockhart_at_bigplanet.com>
Date: Thu, 26 Oct 2000 13:04:23 -0500
Message-Id: <10661.120343@fatcity.com>


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 Received on Thu Oct 26 2000 - 13:04:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US