Re: Memory consumption and swap utilization - Oracle

Posted by satish on May 28, 2019; 4:58am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Memory-consumption-and-swap-utilization-Oracle-tp7410p7411.html

Dear Erman,

The actual issue was

Issue:

1)the listener was getting stuck and it is not accepting any connections.However we are not able to see any errors in alert log or listener log.

2)During the issue,we are unable to bring down the listener or even we not able to check the status of listener,the command is just hanging

We are able to connect as sysdba and run queries on database.

processes 2000
sessions 3000
sga_max_size 5G
sga_target_size 5G
pga_aggregate_target 1356M
sort_area_size 65536

There is no indication of memory problem in any logs

Every week,we are facing this and we are rebooting the server as we are not able to shut down the database

Thank you