DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Free size in SGA

Hybrid View

  1. #1
    Join Date
    Apr 2003
    Location
    Pune,Maharashtra. India.
    Posts
    245

    Free size in SGA

    hi,
    Can we have any view or datadictionary,query by which we could get to know. How much space is free out of our sga.

    Rgds
    Parag

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Code:
    SQL> select round((sum(decode(name, 'free memory', bytes, 0))))
      2  from v$sgastat
      3
    SQL>
    SQL> /
    
    ROUND((SUM(DECODE(NAME,'FREEMEMORY',BYTES,0))))
    -----------------------------------------------
                                          558360344
    regards
    Hrishy

  3. #3
    Join Date
    Apr 2003
    Location
    Pune,Maharashtra. India.
    Posts
    245
    Thanks Hrishy

  4. #4
    Join Date
    Apr 2003
    Location
    Pune,Maharashtra. India.
    Posts
    245
    ggnanaraj,
    Thanks man for your quick reply it helped m a lot. but i think query given by hrishy is more specific coz it gives correct free space and your query will give free space only in shared pool. When i queried
    select * from v$sgastat;

    i noticed...

    large pool free memory 16777216
    java pool free memory 117440512

    they are the part of SGA . But i have not configured them just its a free space . Will it get used if need arises. like increasing any parameter.

  5. #5
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    select bytes from v$sgastat where name = 'free memory' and pool = 'shared pool';

    HTH

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