This is normal behavior as chunks are flushed from and added to the shared pool, the memory fluctuates. As long as you are not seeing ORA-04031 (See ORA-04031.ora-code.com) error or contention on the shared pool latch is not too high, you are fine. What RDBMS version are you on?
-- --Original Message-- -- From: oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)] On Behalf Of genegurevich@(protected) Sent: Wednesday, February 08, 2006 12:28 PM To: oracle-l@(protected) Subject: Re: SGA Free memory
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
