-
find out memory size
I need to know how much memory this program unit UTILPKG will need when loaded in memory: How would i findout from this output???
SQL> SELECT * FROM USER_OBJECT_SIZE WHERE NAME = 'UTILPKG'
Here is the output.
NAME SOURCE_SIZE PARSED_SIZE CODE_SIZE RROR_SIZE
--------------------------------------------------------------------------
UTILPKG 122805 152819 25382 0
UTILPKG 26039 0 16859 0
Last edited by pranavgovind; 07-19-2007 at 03:05 PM.
-
The lazyness of some people still amazes me, yet doesn't surprise me anymore.
Here... http://download.oracle.com/docs/cd/B...536/ch2578.htm
Last edited by PAVB; 07-19-2007 at 06:13 PM.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|