It is a function of how many you actually open and since each one could be a different size -- it is not possible to say how much 40 open ones would be short of getting your 40 together -- measuring the pga use, opening them and fetching a bit, and then measuring again. Have the developers stop it. When you mention "do not parse inside a loop" which parse do you mean soft or hard. That was that guy's question that why you check the Shared Pool just for dictionary privilidges alone? Provide an answer or move on to the next question.
nest...