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.
Thanks!