Here I am thinking about one problem which is not clear to me, I have a package with 100 procedures, but no procedure is callig the ther procedure internally. Then what I am feeling is that, if three end users are connected to the database, and three queried for the same or the different procedures which are in that package. Then the entire pacaage is loaded into memory per each call of the end user? Or once it is loaded into the SGA , it will be available to all requests?
The main thing is is is good to keep those many procedures in a package when one is independent of other, or it is better to create each and every procedure individually?
Please provide me any thing related links for these tuning concepts.