DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Oracle used all my ram, why?

  1. #1
    Join Date
    Nov 2000
    Posts
    440

    Oracle used all my ram, why?

    os: Oracle enterprise linux
    oracle: 10.2.0.3
    ram:16 gig

    Situation:
    I have 3 instances on my machine.
    They should take maximum 2 gig of ram all together.
    But my ram is all used up by oracle anyway.

    Anyone has an idea?



    SQL> select instance_name from v$instance;

    INSTANCE_NAME
    ----------------
    juk_dev

    SQL> show parameter sga;

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    lock_sga boolean FALSE
    pre_page_sga boolean FALSE
    sga_max_size big integer 272M
    sga_target big integer 272M
    SQL> show parameter pga;

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    pga_aggregate_target big integer 90M



    SQL> select instance_name from v$instance;

    INSTANCE_NAME
    ----------------
    mus_dev

    SQL> show parameter sga;

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    lock_sga boolean FALSE
    pre_page_sga boolean FALSE
    sga_max_size big integer 272M
    sga_target big integer 272M
    SQL> show parameter pga;

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    pga_aggregate_target big integer 90M


    SQL> select instance_name from v$instance;

    INSTANCE_NAME
    ----------------
    crn_dev

    SQL> show parameter sga;

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    lock_sga boolean FALSE
    pre_page_sga boolean FALSE
    sga_max_size big integer 272M
    sga_target big integer 272M
    SQL> show parameter pga;

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    pga_aggregate_target big integer 90M






    top - 11:00:26 up 7 days, 14:26, 2 users, load average: 0.24, 0.06, 0.02
    Tasks: 194 total, 1 running, 193 sleeping, 0 stopped, 0 zombie
    Cpu(s): 0.1% us, 0.1% sy, 0.0% ni, 99.8% id, 0.0% wa, 0.0% hi, 0.0% si
    Mem: 16633368k total, 15852732k used, 780636k free, 86796k buffers
    Swap: 4096532k total, 72892k used, 4023640k free, 15103816k cached

    PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
    31627 oracle 16 0 393m 222m 192m S 0 1.4 0:46.10 oracle
    31633 oracle 16 0 363m 221m 217m S 0 1.4 0:11.73 oracle
    26416 oracle 16 0 384m 213m 192m S 0 1.3 14:51.40 oracle
    24175 oracle 16 0 363m 167m 163m S 0 1.0 0:23.89 oracle
    31103 oracle 16 0 362m 156m 153m S 0 1.0 0:07.07 oracle
    11659 oracle 15 0 363m 149m 147m S 0 0.9 0:30.59 oracle
    449 oracle 16 0 363m 146m 143m S 0 0.9 0:04.64 oracle
    8641 oracle 15 0 362m 142m 139m S 0 0.9 0:03.57 oracle
    443 oracle 16 0 376m 141m 128m S 0 0.9 5:38.09 oracle
    31109 oracle 15 0 362m 138m 135m S 0 0.9 0:09.41 oracle
    24152 oracle 16 0 363m 115m 112m S 0 0.7 0:51.03 oracle
    31639 oracle 16 0 363m 115m 111m S 0 0.7 0:03.79 oracle
    24162 oracle 16 0 363m 115m 111m S 0 0.7 0:36.68 oracle
    453 oracle 16 0 362m 97m 94m S 0 0.6 0:01.39 oracle
    31625 oracle 16 0 361m 86m 85m S 0 0.5 0:00.15 oracle
    31637 oracle 16 0 362m 86m 83m S 0 0.5 0:04.66 oracle
    455 oracle 16 0 363m 83m 79m S 0 0.5 0:01.36 oracle
    31101 oracle 16 0 361m 82m 81m S 0 0.5 0:00.17 oracle
    3093 oracle 16 0 363m 73m 70m S 0 0.5 0:00.75 oracle
    31115 oracle 16 0 363m 71m 67m S 0 0.4 0:03.34 oracle
    20028 oracle 16 0 362m 68m 65m S 0 0.4 0:04.47 oracle
    24192 oracle 16 0 362m 62m 60m S 0 0.4 0:00.61 oracle
    441 oracle 16 0 361m 60m 59m S 0 0.4 0:00.06 oracle
    18002 oracle 16 0 363m 60m 57m S 0 0.4 0:43.23 oracle
    31725 oracle 16 0 362m 57m 55m S 0 0.4 0:00.72 oracle
    24196 oracle 16 0 362m 56m 52m S 0 0.3 0:00.58 oracle
    31113 oracle 16 0 362m 55m 52m S 0 0.3 0:04.52 oracle
    19241 oracle 16 0 362m 55m 52m S 0 0.3 0:03.08 oracle
    24194 oracle 17 0 362m 51m 48m S 0 0.3 0:00.62 oracle
    2252 oracle 16 0 363m 50m 47m S 0 0.3 0:00.26 oracle
    20379 oracle 15 0 362m 41m 38m S 0 0.3 0:00.09 oracle
    15572 oracle 16 0 362m 37m 35m S 0 0.2 0:00.12 oracle
    8510 oracle 15 0 362m 37m 34m S 0 0.2 0:00.14 oracle
    20422 oracle 16 0 362m 36m 33m S 0 0.2 0:00.08 oracle
    8370 oracle 15 0 362m 33m 30m S 0 0.2 0:00.11 oracle
    20524 oracle 15 0 362m 32m 30m S 0 0.2 0:00.09 oracle
    4943 oracle 16 0 362m 28m 26m S 0 0.2 0:00.06 oracle
    2276 oracle 16 0 362m 28m 25m S 0 0.2 0:00.04 oracle
    12036 oracle 16 0 362m 27m 25m S 0 0.2 0:00.06 oracle
    24125 oracle 25 0 144m 26m 9032 S 0 0.2 0:53.03 emagent
    14517 oracle 15 0 361m 26m 24m S 0 0.2 0:00.03 oracle
    31670 oracle 16 0 362m 26m 23m S 0 0.2 0:00.05 oracle
    3088 oracle 15 0 361m 25m 24m S 0 0.2 0:00.07 oracle
    14095 oracle 16 0 361m 25m 23m S 0 0.2 0:00.03 oracle
    31635 oracle 16 0 361m 24m 22m S 0 0.2 0:00.03 oracle
    457 oracle 16 0 361m 23m 22m S 0 0.1 0:00.30 oracle
    551 oracle 16 0 362m 23m 21m S 0 0.1 0:00.04 oracle
    559 oracle 16 0 362m 23m 21m S 0 0.1 0:00.04 oracle
    31631 oracle 16 0 365m 23m 20m S 0 0.1 0:06.77 oracle
    31158 oracle 16 0 361m 23m 21m S 0 0.1 0:00.03 oracle
    2272 oracle 16 0 361m 22m 21m S 0 0.1 0:00.02 oracle
    31107 oracle 16 0 365m 22m 19m S 0 0.1 0:05.52 oracle

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    why do you think all your memory is being used up by Oracle?
    Jeff Hunter

  3. #3
    Join Date
    Nov 2000
    Posts
    440
    The top command.

    top - 12:23:22 up 7 days, 15:49, 2 users, load average: 0.04, 0.03, 0.00
    Tasks: 197 total, 1 running, 196 sleeping, 0 stopped, 0 zombie
    Cpu(s): 0.1% us, 0.1% sy, 0.0% ni, 99.8% id, 0.0% wa, 0.0% hi, 0.0% si
    Mem: 16633368k total, 15957772k used, 675596k free, 95200k buffers
    Swap: 4096532k total, 72768k used, 4023764k free, 15206652k cached


    see the detail in my post

  4. #4
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Can you confirm again with vmstat?
    "What is past is PROLOGUE"

  5. #5
    Join Date
    Nov 2000
    Posts
    440
    [oracle@dbdev bdump]$ vmstat
    procs -----------memory---------- ---swap-- -----io---- --system-- ----cpu----
    r b swpd free buff cache si so bi bo in cs us sy id wa
    0 0 72076 194316 96752 15679120 0 0 100 744 15 11 4 1 95 1

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    you need to learn about shared memory and how top misrepresents it

  7. #7
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width