We have recently added a lot of new packages to our system, and trying to determine incremental memory usage from a prior version of our product. I know I can get the
sharable_mem value from
v$db_object_cache. However, that will not include all packages in our schema, as they may be aged out.
Is there any way to determine the memory size of a package that is not in the object cache? And, I do not mean lines of source code (
ALL_SOURCE), but size of whatever it is that oracle does under the hood to compile/parse the package.