RE: Memory Question

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




Looking at your kernel version you are using AS2.1.
The only parameters you should have had to change are shmmax, sem
,shmall, semmni (some of the default are acceptable)
The commands indeed should return the correct output.

The OS should be using far less than 500MB.

As you can see in the info you posted.

Free: 154764
Buffers: 333072
Total "free" = 476MB

So OS memory used should be 4GB - 476MB - SGA - PGA

In any case an SGA this large with 4GB memory will cause issues as you
start using the DB from my experience.

-Tobias

-----Original Message-----
From: redhat-list-bounces@xxxxxxxxxx
[mailto:redhat-list-bounces@xxxxxxxxxx] On Behalf Of Parekh, Ketan
Sent: Wednesday, July 28, 2004 12:07 PM
To: redhat-list@xxxxxxxxxx
Subject: Memory Question

HI! Folks,

 

I need some help with memory stats. I have an Oracle database running. 

Below is he OS version : 

Linux tsonode1 2.4.9-e.25enterprise #1 SMP Fri Jun 6 17:55:13 EDT 2003
i686 unknown

 

oracle@tsonode1[tsodev1]$ free -t

                     total         used       free     shared    buffers
cached

Mem:       2058760    1814816     243944     742204     243924
213272

-/+ buffers/cache:      1357620     701140

Swap:      2096472     217516    1878956

Total:     4155232      2032332    2122900

 

>From the above as to what I understand is 

Total Physical memory is : 2 GB

USED                               1.35 GB is used

Free                                  701 Megs

 

So of the 1.35 used 

Oracle SGA is                             950 Megs

Oracle PGA ( Process memory )  260 Megs

Other non-oacle process             150 Megs

                        Total                 1.35 GB

 

Now there is a limitation on RH 2.1 Advanced server for having oracle
SGA > 1.8 GB. To increase the SGA we had to 

Changes to the memory settings and relinked the oracle binaries as
explained in the RH doc. 

 

OS : Linux tsonode2 2.4.9-e.46enterprise #1 SMP Wed Jun 30 18:11:26 EDT
2004 i686 unknown

 

                     total       used       free     shared    buffers
cached

Mem:       3863184    3708420     154764    2461228     333072
587348

-/+ buffers/cache:       2788000    1075184

Swap:      2096472       1116    2095356

Total:       5959656    3709536    2250120

 

SGA                  : 2.75 GB

PGA                  : 837 Megs

 

Total Physical memory is 4 GB on ths host.

 

So now the confusion part is is Oracle has sucked in 2.75 + 537 = 3.5 GB
- is the OS using only 500 megs ?

Does free -t , top vmstat commands show the right numbers after this
change in the kernel ?

 

BTW : both the free -t outputs are from diff nodes - I put them to
compare and see where am I going wrong here.

 

Thanks for your help..

 

Ketan

 

 

-- 
redhat-list mailing list
unsubscribe mailto:redhat-list-request@xxxxxxxxxx?subject=subscribe
https://www.redhat.com/mailman/listinfo/redhat-list


-- 
redhat-list mailing list
unsubscribe mailto:redhat-list-request@xxxxxxxxxx?subject=unsubscribe
https://www.redhat.com/mailman/listinfo/redhat-list

[Index of Archives]     [CentOS]     [Kernel Development]     [PAM]     [Fedora Users]     [Red Hat Development]     [Big List of Linux Books]     [Linux Admin]     [Gimp]     [Asterisk PBX]     [Yosemite News]     [Red Hat Crash Utility]


  Powered by Linux