-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|