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
Printable View
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
In V$librarycache , a column called namespace .
I forgot which value is indicate the function or procedure .
Please check it out
SELECT TYPE, SUM(SHARABLE_MEM) FROM V$DB_OBJECT_CACHE
GROUP BY TYPE;