Re: Memory needed for upgrade to 18c

Hello Stefan,

Thank you very much for your answer.

1. We did not change any parameter related to memory. Furthermore, we got the same issue (memory usage increased), 2 years ago, when we upgraded from 11.2.0.4 to 12.1.0.2.
2. We have 22 single instances at that server. It will take time if we determine the the consumption of each process.

*$ ps -ef|wc**
**    3423   30419  238850**
**8:58:13 z004969:/users/ucib/z004969 **
**$ ps -ef|grep smon|grep -v grep|wc**
**      22     198    1498*

On 5/17/19 9:42 AM, Stefan Koehler wrote:
> Hello Thanh,
> ah AIX and Oracle is like Tom and Jerry ;-)
>
> Maybe the good old "USLA heap" problem is back again. However if you have not changed any parameter (e.g. SGA_TARGET, MEMORY_TARGET, PGA_AGGREGATE_TARGET) and you are not using more (over-allocated) PGA than before than it is very likely caused by heap memory consumption of each Oracle process - you can check the memory and break it down with "svmon" very easily ( http://www-01.ibm.com/support/docview.wss?uid=isg3T1012834 ).
>
> Best Regards
> Stefan Koehler
>
> Independent Oracle performance consultant and researcher
> Website: http://www.soocs.de
> Twitter: _at_OracleSK
>
>> Thanh NGUYEN <ttrnguyen_at_gmail.com> hat am 16. Mai 2019 um 21:31 geschrieben:
>>
>> Hello,
>> Aix 7.2 ML03
>> We upgraded 5 instances from 12.1.0.2 to 18c, without changing any
>> parameter.
>> Then we observed that memory is used more than before the upgrade,
>> nearly 2GB more for each.
>> Do you have any experience/explanation about that please?
>> Thank you in advance.
>> Best regards,
>> Thanh NGUYEN
>>
>> --
>> http://www.freelists.org/webpage/oracle-l

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