Total Occupied space in SGA by Procedure

[Felix]

Hi,

Can anyone of you help me in finding the total space occupied by the procedure or function or PL/SQL in sga.

It very urgent.

thanks in advance.

With regards

[ligang]

In V$librarycache , a column called namespace .
I forgot which value is indicate the function or procedure .

Please check it out

[tamilselvan]

SELECT TYPE, SUM(SHARABLE_MEM) FROM V$DB_OBJECT_CACHE
GROUP BY TYPE;