Memory at 100% LRH Ent 4.0

Hogan, Audrey Mobley amhogan at tva.gov
Thu Feb 21 16:22:06 UTC 2008 

Ryan:  How did you know it was waiting for IO from the storage system? 

-----Original Message-----
From: redhat-sysadmin-list-bounces at redhat.com [mailto:redhat-sysadmin-list-bounces at redhat.com] On Behalf Of Sweat, Ryan
Sent: Wednesday, February 20, 2008 7:11 PM
To: redhat-sysadmin-list at redhat.com
Subject: RE: Memory at 100% LRH Ent 4.0

Is the issue a performance problem and you suspect the culprit is memory?  This output shows your system is waiting for IO from your storage system.  You aren't out of memory, but you do have less than 1GB available.  How many database instances are you running?  Can you provide the same statistics with Oracle not running?  Also attach a copy of ps aux output?

> -----Original Message-----
> From: redhat-sysadmin-list-bounces at redhat.com 
> [mailto:redhat-sysadmin-list-bounces at redhat.com] On Behalf Of 
> Mario Henley Becerril Geldis
> Sent: Wednesday, February 20, 2008 6:35 PM
> To: redhat-sysadmin-list at redhat.com
> Subject: RE: Memory at 100% LRH Ent 4.0
> 
> Thank you,
> 
> The Oracle SGA have 8GB.  
> 
> $ more /proc/meminfo
> MemTotal:     16409832 kB
> MemFree:        224688 kB
> Buffers:         17296 kB
> Cached:         461900 kB
> SwapCached:          0 kB
> Active:        2144412 kB
> Inactive:       346400 kB
> HighTotal:           0 kB
> HighFree:            0 kB
> LowTotal:     16409832 kB
> LowFree:        224688 kB
> SwapTotal:    33554424 kB
> SwapFree:     33553604 kB
> Dirty:            3992 kB
> Writeback:           0 kB
> Mapped:        2116692 kB
> Slab:          2524412 kB
> CommitLimit:  37040748 kB
> Committed_AS: 14651952 kB
> PageTables:      64536 kB
> VmallocTotal: 536870911 kB
> VmallocUsed:    281244 kB
> VmallocChunk: 536589591 kB
> HugePages_Total:  4608
> HugePages_Free:    511
> Hugepagesize:     2048 kB
> 
> 
> $ top
> top - 18:34:35 up 21 days, 15:59,  4 users,  load average: 
> 7.08, 6.52, 5.45
> Tasks: 963 total,   3 running, 960 sleeping,   0 stopped,   0 zombie
> Cpu(s):  8.8% us, 15.4% sy,  0.0% ni, 62.3% id, 12.8% wa,  
> 0.1% hi,  0.7% si
> Mem:  16409832k total, 16187624k used,   222208k free,    
> 17452k buffers
> Swap: 33554424k total,      820k used, 33553604k free,   
> 463444k cached
> 
>   PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
> 20837 oracle    16   0 8631m 8.3g 8.0g S    0 53.1   3:22.17 oracle
> 20794 oracle    16   0 8519m 8.2g 8.0g S    0 52.4   8:19.70 oracle
> 20641 oracle    16   0 8487m 8.2g 8.0g S    0 52.2   9:43.38 oracle
> 20649 oracle    16   0 8455m 8.1g 8.0g S    0 52.0   4:25.92 oracle
> 20845 oracle    16   0 8439m 8.1g 8.0g S    0 51.9   3:58.00 oracle
> 21033 oracle    15   0 8342m 8.0g 8.0g S    8 51.3 137:16.89 oracle
>  8676 oracle    16   0 8333m 8.0g 8.0g S    0 51.3   2:00.25 oracle
>  8664 oracle    16   0 8339m 8.0g 8.0g S    0 51.3  10:23.07 oracle
> 21047 oracle    15   0 8341m 8.0g 8.0g S    0 51.3 139:15.43 oracle
> 21043 oracle    15   0 8342m 8.0g 8.0g S    0 51.3 134:08.43 oracle
> 20923 oracle    15   0 8341m 8.0g 8.0g S    0 51.3 139:50.04 oracle
> 21041 oracle    15   0 8341m 8.0g 8.0g S    0 51.3 132:04.04 oracle
> 19313 oracle    16   0 8341m 8.0g 8.0g S    0 51.3  74:14.41 oracle
> 21037 oracle    16   0 8341m 8.0g 8.0g S   10 51.3 138:08.85 oracle
>  8804 oracle    15   0 8346m 8.0g 8.0g S    0 51.3   2:10.37 oracle
>  8806 oracle    15   0 8346m 8.0g 8.0g S    0 51.3   2:04.98 oracle
>  8808 oracle    16   0 8346m 8.0g 8.0g S    0 51.3   2:24.87 oracle
>  8790 oracle    15   0 8346m 8.0g 8.0g S    0 51.3   2:05.57 oracle
>  8792 oracle    15   0 8346m 8.0g 8.0g S    0 51.3   2:09.34 oracle
>  8798 oracle    15   0 8346m 8.0g 8.0g S    0 51.3   2:11.54 oracle
>  8800 oracle    15   0 8346m 8.0g 8.0g S    0 51.3   2:11.58 oracle
>  8796 oracle    16   0 8346m 8.0g 8.0g S    0 51.3   2:10.83 oracle
>  8794 oracle    16   0 8346m 8.0g 8.0g S    0 51.3   2:10.52 oracle
>  8802 oracle    15   0 8346m 8.0g 8.0g S    0 51.3   2:11.71 oracle
>  8666 oracle    16   0 8333m 8.0g 8.0g S    0 51.3   2:36.09 oracle
> 28027 oracle    15   0 8330m 8.0g 8.0g S    0 51.3   0:00.22 oracle
>  8670 oracle    16   0 8331m 8.0g 8.0g S    0 51.3   0:20.51 oracle
>  8636 oracle   -51   0 8343m 8.0g 8.0g S    0 51.3   0:15.56 oracle
>  8640 oracle   -51   0 8343m 8.0g 8.0g S    0 51.3   0:15.23 oracle
>  8634 oracle    15   0 8343m 8.0g 8.0g S    0 51.3   0:47.48 oracle
> 20948 oracle    15   0 8332m 8.0g 8.0g S    0 51.3   0:00.81 oracle
> 16966 oracle    15   0 8334m 8.0g 8.0g S    0 51.3   0:01.01 oracle
>  8769 oracle    16   0 8330m 8.0g 8.0g S    0 51.3   0:05.17 oracle
> 20799 oracle    16   0 8330m 8.0g 8.0g S    0 51.3   0:05.75 oracle
> 10234 oracle    16   0 8330m 8.0g 8.0g S    0 51.3   0:00.54 oracle
> 21061 oracle    16   0 8333m 8.0g 8.0g S    5 51.3 131:13.11 oracle
>  9775 oracle    15   0 8333m 8.0g 8.0g S    0 51.3  75:18.91 oracle
> 
> 
> -----Mensaje original-----
> De: redhat-sysadmin-list-bounces at redhat.com 
> [mailto:redhat-sysadmin-list-bounces at redhat.com] En nombre de 
> Sweat, Ryan
> Enviado el: Miércoles, 20 de Febrero de 2008 06:30 p.m.
> Para: redhat-sysadmin-list at redhat.com
> Asunto: RE: Memory at 100% LRH Ent 4.0
> 
> It's probably not an oversized Oracle SGA if it still appears to use
> 100% when it's shut down.  Linux caches memory that isn't 
> being used, so
> it only looks like it's using 100%.  Cached memory can be reclaimed by
> processes that need it.  Can you cat /proc/meminfo and paste 
> its output
> here?  Also run top, and sort by memory usage by pushing M, and see if
> any of the top processes appear to be using an abnormal amount of
> memory. 
> 
> > -----Original Message-----
> > From: redhat-sysadmin-list-bounces at redhat.com 
> > [mailto:redhat-sysadmin-list-bounces at redhat.com] On Behalf Of 
> > Mario Henley Becerril Geldis
> > Sent: Wednesday, February 20, 2008 6:05 PM
> > To: redhat-sysadmin-list at redhat.com
> > Subject: Memory at 100% LRH Ent 4.0
> > 
> > Hi Administrators,
> > 
> >  
> > 
> >  
> > 
> > I have a Linux Red Hat Enterprise 4.0 with Oracle 10g 
> > Database on HP DL580 (16GB RAM and  8 CPU at 3.3GHz). All the 
> > time the system appear with 100% Memory consumption.
> > 
> >  
> > 
> > When Oracle 10g database is down; the system have 100% Memory 
> > consumption.
> > 
> >  
> > 
> > To solve this, the system must be reset.
> > 
> >  
> > 
> >  
> > 
> > Any ideas.
> > 
> > 
> 
> --
> redhat-sysadmin-list mailing list
> redhat-sysadmin-list at redhat.com
> https://www.redhat.com/mailman/listinfo/redhat-sysadmin-list
> 
> --
> redhat-sysadmin-list mailing list
> redhat-sysadmin-list at redhat.com
> https://www.redhat.com/mailman/listinfo/redhat-sysadmin-list
> 

--
redhat-sysadmin-list mailing list
redhat-sysadmin-list at redhat.com
https://www.redhat.com/mailman/listinfo/redhat-sysadmin-list

More information about the redhat-sysadmin-list mailing list