This discussion is archived
1 Reply Latest reply: Jul 26, 2012 7:07 AM by sb92075 RSS

Needs inputs about High Memory Usage by Oracle

sandy121 Newbie
Currently Being Moderated
We are getting an alert on a particular Solaris box that Oracle is using high Memory, stat as below:-
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
NPROC USERNAME SIZE RSS MEMORY TIME CPU
177 oracle 2654G 2639G 100% 42:38:44 19%


What may the steps we need to investigate apart from digging into the current running Oracle processes on the box?

Any inputs will be highly appreciated.

Edited by: 918868 on Jul 26, 2012 6:38 AM
  • 1. Re: Needs inputs about High Memory Usage by Oracle
    sb92075 Guru
    Currently Being Moderated
    918868 wrote:
    We are getting an alert on a particular Solaris box that Oracle is using high Memory, stat as below:-
    <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
    NPROC USERNAME SIZE RSS MEMORY TIME CPU
    177 oracle 2654G 2639G 100% 42:38:44 19%


    What may the steps we need to investigate apart from digging into the current running Oracle processes on the box?

    Any inputs will be highly appreciated.

    Edited by: 918868 on Jul 26, 2012 6:38 AM
    MEMORY is designed to be used.
    This alert in and of itself it meaningless.

    a lack of RAM can be seen when (si+so) > (bi+bo) from vmstat below
    bcm@bcm-laptop:~$ vmstat 6 10
    procs -----------memory---------- ---swap-- -----io---- -system-- ----cpu----
     r  b   swpd   free   buff  cache   si   so    bi    bo   in   cs us sy id wa
     3  0   5248  39104 287160 1905160    0    0    47    41   50  241 10  4 84  1
     2  0   5248  36808 287180 1907892    0    0     2    25 1409 3439 18 50 32  1
     2  0   5248  36684 287196 1907900    0    0     0    26 1423 3288 17 50 33  0
     2  0   5248  41992 287212 1907900    0    0     0    24 1495 3463 18 48 34  0
     1  0   5248  42412 287228 1907920    0    0     0    48 1489 3425 20 46 34  0
     1  0   5248  41876 287248 1907924    0    0     1    26 1392 3106 15 48 36  1
     2  0   5248  41892 287264 1907936    0    0     0    19 1408 3287 17 50 33  0
     1  0   5248  41900 287280 1908056    0    0    18    40 1482 3409 16 51 33  0
     2  0   5248  35800 287304 1908120    0    0     7    40 1363 3244 20 49 31  0
     1  0   5248  35848 287328 1908128    0    0     1    30 1447 3293 18 49 33  1
    bcm@bcm-laptop:~$ 

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points