Total Occupied space in SGA by Procedure
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Total Occupied space in SGA by Procedure

  1. #1
    Join Date
    Sep 2000
    Location
    Singapore
    Posts
    32
    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
    Felix
    DBA

  2. #2
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433
    In V$librarycache , a column called namespace .
    I forgot which value is indicate the function or procedure .

    Please check it out

  3. #3
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    SELECT TYPE, SUM(SHARABLE_MEM) FROM V$DB_OBJECT_CACHE
    GROUP BY TYPE;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width