physical RAM versus the total SGA on the Linux 7.3
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: physical RAM versus the total SGA on the Linux 7.3

  1. #1
    Join Date
    Sep 2002
    Posts
    411
    Hi all,

    I have Oracle 9i running on Linux 7.3. The total RAM on the box is baout 600M, there is nothing running on the box except one Oracle instance.

    Below is the memory consumed on the box:



    CPU states: 0.0% user, 0.3% system, 0.0% nice, 99.6% idle
    Mem: 643692K av, 632184K used, 11508K free, 0K shrd, 175920K buff
    Swap: 1518100K av, 56140K used, 1461960K free 349248K cached


    but when I look into the total or SGA and this is what I get:



    SQL> show sga

    Total System Global Area 114364796 bytes
    Fixed Size 450940 bytes
    Variable Size 88080384 bytes
    Database Buffers 25165824 bytes
    Redo Buffers 667648 bytes

    I don't get this, is this the behavior in Linux 7.3???

    Could someone please give me some hint???
    Thanks


  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    that's how linux works, it chches everything he can

    next time post linux distribution, 7.3 can be Suse or Redhat

  3. #3
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    How many users (i thing dedicated sessions) u have?
    What value has sort_area_size?
    Do applications use store procedures/packages with a lot of internal calls?
    Ur information is not full.

  4. #4
    Join Date
    Sep 2002
    Posts
    411
    Pando,

    that's what I heard from somewhere and I don't recall, but it's weird for Linux to do that b/c do you think the system will use more swap file??? So if Linux claims as much as it should, what is Linux going to do with the RAM, does he leave as reserve???



    Shestakov

    I don't have that many users on this database, the max is about 5 users.

    The sort_area_size=524288

    we don't use store procedures/packages with a lot of internal call.

    The memory will peak up when I analyze the tables in the database and it stay there even it's done.


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