Why and When would you use a package instead of standalone procedures? Which one increases performence - package or standalone procedure?

Questions by gangadhar6708

Showing Answers 1 - 1 of 1 Answers

mailtonagaraja

  • Mar 24th, 2011
 

Hi ,
   1) In Package we can combile all related objects into one component, whenever you refer or call any object in the package , full package will be copied to the memory , so that next time when you refer to any object in the package , it will be very fast .
Package will give good performance when we are using more objects in the package (like 80%of the objects).

When we use 20% of the objects and the package is still sitting in memory , it will not give much performance .

2) Prodedure , each time you call , it has to copy from main memory to local.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions