Database Tuning (MOSC)

MOSC Banner

Help need to troubleshoot the Memory usage in the database

While checking the database server using the top command, I found that the idle memory is 1GB out of 123GB. Need help to find which process or sessions are consuming more memory?

Top command output:

==================

MiB Mem : 126922.2 total,  1168.7 free, 70705.7 used, 55047.8 buff/cache

MiB Swap: 17404.0 total, 13703.1 free,  3700.9 used. 54968.3 avail Mem

$ free -g

=============

        total    used    free   shared  buff/cache  available

Mem:      123     69       0     0     53     53

Swap:      16      3     13


Thanks

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center