ORACLE FAQ: Determining Package Size

Here is my contribution to the newsgroup Satar Naghshineh
SatarNag_at_aol.com

ORACLE WORLDWIDE SUPPORT FAQs (from the 7.3 Tuning Manual)

Problem: Determining Package Size

Scenario
Prior to 7.0.15, the complied code for a package was split into more than one piece, each piece being only about 12k in size. Since this release the 64k restriction was lifted however packages larger than 100k can still have problems compiling. It is therefore recommended that the code size of a package should not be greater than 100k. In addition, any larger package must be pinned in the shared pool for other resources. Therefore if a large number of packages are being pinned, the shared pool may need to be increased in size.

Solution
To determine the package code size use the column CODE_SIZE in the view DBA_OBJECT_SIZE. The column PARSED_SIZE is the size of the parsed code for the package.

***END*** hoped it helped Received on Fri Aug 22 1997 - 00:00:00 CDT