Parse size of procedure

[ravenkumar]

How can i know my parse size of my procedure

I want to know my parse size of my procedure how can i know that can you give some example

[krishnaindia2007]

Use the following query

SELECT name,type, source_size, parsed_size
FROM dba_object_size
WHERE type ='PROCEDURE'
AND name ='PROCEDURENAME'


Here

SOURCE SIZE is Size of the source, in bytes. Must be in memory during compilation, or dynamic recompilation

PARSED SIZE is Size of the parsed form of the object, in bytes. Must be in memory when an object is being compiled that references this object