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

Thread: SGA Free memory dynamics

  1. #1
    Join Date
    Jan 2006
    Posts
    1

    SGA Free memory dynamics

    Hi all:

    I am watching the usage of the SGA on my database via the following command:

    select to_char(sysdate,'mm-dd-yyyy hh24:mi:ss'), name, bytes/(1024*1024) from v$sgastat, dual
    where pool like '%shared%' and name = 'free memory' order by bytes asc
    ;

    I am running it every 10 seconds. Recently I saw the free memory going from 25M to 145M over the course
    of 10 sec. I'm wondering what could have caused it. Would appreciate any suggestions

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Do you flush out SHARED POOL periodically?

    Tamil

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