Hello Stefan,
Yes. I monitored the PGA usage and I saw that the usage was increased
but around 200MB for each instance (one example attached), not 2GB.
Best regards,
Thanh NGUYEN
On 5/18/19 10:54 AM, Stefan Koehler wrote:
Hello Thanh,
to point 1) Even if you have not changed any parameter you might have an
increase in PGA usage as PGA_AGGREGATE_TARGET is just a soft-limit and you get
different execution plans with more PGA usage, etc.
to point 2) The idea is already simple as you don't need to check all
processes. Just grep one from a 12.1.0.2 instance and grep the same process
(e.g. a plain connected process/session without any workload) from a 18c
instance and compare with svmon. That's it.
Best Regards
Stefan Koehler
Independent Oracle performance consultant and researcher
Website: http://www.soocs.de
Twitter: @OracleSK
Thanh NGUYEN <ttrnguyen@xxxxxxxxx> hat am 18. Mai 2019 um 09:17 geschrieben:
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.
Do you have any simpler idea?
Best regards,
Thanh NGUYEN
------------------------
$ ps -ef|wc
3423 30419 238850
8:58:13 z004969:/users/ucib/z004969
$ ps -ef|grep smon|grep -v grep|wc
22 198 1498
