RE: ASSM - dynamic memory resizing

From: David Kurtz <info_at_go-faster.co.uk>
Date: Sat, 1 Dec 2007 08:57:19 -0000
Message-ID: <01b801c833f8$2f1943b0$0a0a0a0a@GOFASTER4>

Are you also running with Unicode?
If so, the PeopleSoft implementation of that will aggravate the situation further.

Prior to Apps 9.0, every character column in the PeopleSoft schema is implemented like this:
...
EMPLID VARCHAR2(33) CHECK LENGTH(EMPLID)<=11, ...

regards

---

David Kurtz
Go-Faster Consultancy Ltd.
tel: +44 (0)7771 760660
fax: +44 (0)7092 348865
mailto:david.kurtz_at_go-faster.co.uk
web: www.go-faster.co.uk
Book: PeopleSoft for the Oracle DBA: http://www.psftdba.com DBA Blogs: PeopleSoft: http://blog.psftdba.com, Oracle: http://blog.go-faster.co.uk
PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba

>-----Original Message-----
>From: oracle-l-bounce_at_freelists.org
>[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Taylor, Chris David
>Sent: Friday, November 30, 2007 4:53 PM
>To: kaygopal_at_gmail.com; Amir.Hameed_at_xerox.com
>Cc: Oracle-L Freelists
>Subject: RE: ASSM - dynamic memory resizing
>Importance: High
>
>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_at_ingrambarge.com
>
>-----Original Message-----
>From: oracle-l-bounce_at_freelists.org
>[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of K Gopalakrishnan
>Sent: Friday, November 30, 2007 10:47 AM
>To: Amir.Hameed_at_xerox.com
>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_at_xerox.com> 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
>>
>> --
>> http://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/
>--
>http://www.freelists.org/webpage/oracle-l
>
>
>
>
>--
>http://www.freelists.org/webpage/oracle-l
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Sat Dec 01 2007 - 02:57:19 CST