title: Impact of Package Size to Performance in Oracle 10g
body: <p>Using Oracle 10g. The original Oracle designer for this project has moved on and those of us remaining are reasonable developer's for Oracle but we need some tuning and planning assistance. </p>
  
  <p>We have compartmentalized procedures in 'like' packages, some (many) of which have grown in size to include many (50 ish) procedures of varying complexities.</p>
  
  <p>At this point several small procedures (select ID from Contract where Item = 'xyz') in these larger packages take much longer 'than expected' to execute from inside a these packages (from TOAD, SQL Developer, or from .NET Oracle Provider) than it does if the proc is compiled on its own or into a smaller package. <em>(Tables are indexed)</em></p>
  
  <p>Should there be a performance cost for using such large packages even when calling relatively simple individual procedures or is there some 'other' factor we should be looking for?  </p>
  
  <p><em>(note: upgrade to Oracle 11 is planned but not 'imminent')</em></p>