SGA Free memory 2006-02-08 - By genegurevich@(protected)
I am at 9204 and I was experiencing ora-4031 (See ora-4031.ora-code.com). That's why I started watching
the free memory.
thank you
Gene Gurevich
"Hameed, Amir"
<Amir.Hameed@(protected)
x.com> To
<genegurevich@(protected)
02/08/2006 11:38 >, <oracle-l@(protected)>
AM cc
Subject
RE: SGA Free memory
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
thank you
Gene Gurevich
Oracle Engineering
224-405-4079
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
|
|
