physical RAM versus the total SGA on the Linux 7.3

[mike2000]

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

[pando]

that's how linux works, it chches everything he can

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

[Shestakov]

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.

[mike2000]

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.