RE: ASSM - dynamic memory resizing
- From: "Hameed, Amir" <Amir.Hameed@xxxxxxxxx>
- To: <kaygopal@xxxxxxxxx>, "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 30 Nov 2007 12:56:38 -0500
When I run the following statement, I see the result as shown below:
select LOCALITY, sum(GRANSIZE) gransize from sys.x$ksmge group by
LOCALITY
;
LOCALITY SUM_GRANSIZE
---------- ---------------
129 3,254,779,904
5 2,130,706,432
1 2,147,483,648
2 2,130,706,432
3 2,130,706,432
0 2,147,483,648
4 2,130,706,432
---------------
sum 16,072,572,928
I understand that numbers 0-5 refer to the memory boards on the system.
In my case there are six boards (24 dual-core CPUs) and each board has
memory on it. What does number 129 refer to?
-----Original Message-----
From: Taylor, Chris David [mailto:Chris.Taylor@xxxxxxxxxxxxxxx]
Sent: Friday, November 30, 2007 11:53 AM
To: kaygopal@xxxxxxxxx; Hameed, Amir
Cc: Oracle-L Freelists
Subject: RE: ASSM - dynamic memory resizing
Personally, I love it when ASSM forces the shared pool to 3x the size of
the buffer cache, by taking memory _away_ from the buffer cache.
That's fantastic. Gotta love it.
I know, I know. "Bind Variables". Tell that to PeopleSoft who is Oracle
:)
Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-354-4799
Email: chris.taylor@xxxxxxxxxxxxxxx
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of K Gopalakrishnan
Sent: Friday, November 30, 2007 10:47 AM
To: Amir.Hameed@xxxxxxxxx
Cc: Oracle-L Freelists
Subject: Re: ASSM - dynamic memory resizing
Amir,
The frequency depends on the memory pressure. I am not aware whether
there are any fixed intervals , where MMAN checks the memory
allocations. However you can trace the operations using
"_memory_management_tracing".
-Gopal
On Nov 30, 2007 8:50 AM, Hameed, Amir <Amir.Hameed@xxxxxxxxx> wrote:
> Folks,
> Does anyone know what process does the dynamic memory resizing when
ASSM
> is enabled? Also, what is the frequency of this operation or is it
> triggered by some event? From the v$sga_dynamic
> _components.last_oper_time, this does not seem to be triggered at
fixed
> time intervals.
>
> Thanks
> Amir
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Best Regards,
K Gopalakrishnan
Co-Author: Oracle Wait Interface, Oracle Press 2004
http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/
Author: Oracle Database 10g RAC Handbook, Oracle Press 2006
http://www.amazon.com/gp/product/007146509X/
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
