Re: memory usage
Date: Thu, 1 Mar 2012 09:36:28 -0800 (PST)
Message-ID: <5ece422d-08ff-4e0b-a423-4af3aa37e38d_at_d7g2000pbl.googlegroups.com>
On Mar 1, 9:07 am, rvaede <rvaede..._at_gmail.com> wrote:
> On Mar 1, 9:09 am, mhoys <matthias.h..._at_gmail.com> wrote:
>
>
>
>
>
>
>
>
>
> > On Mar 1, 2:56 pm, rvaede <rvaede..._at_gmail.com> wrote:
>
> > > I have a server Redhat 4 and running Oracle 11 thats slow and
> > > consumming a lot of memory and its constant.
> > > Server has 16 GB of RAM.
> > > I am a linux administrator so I am not familiar with the Oracle config
> > > files.
> > > I also noticed that the cached is consumming about 9 GB.
> > > Would you have any advise on how to tackle this.
>
> > > top - 08:48:27 up 33 days, 22:45, 1 user, load average: 0.22, 0.31,
> > > 0.43
> > > Tasks: 109 total, 1 running, 108 sleeping, 0 stopped, 0 zombie
> > > Cpu(s): 0.2%us, 0.2%sy, 1.9%ni, 97.7%id, 0.0%wa, 0.0%hi,
> > > 0.1%si, 0.0%st
> > > Mem: 16435720k total, 15975740k used, 459980k free, 171268k
> > > buffers
> > > Swap: 8193140k total, 116k used, 8193024k free, 9881732k
> > > cached
>
> > > PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+
> > > COMMAND
> > > 12893 oracle 18 0 2804m 984m 5448 S 4.7 6.1 171:21.72
> > > java
> > > 32023 oracle 18 0 3594m 1.5g 5504 S 3.0 9.7
> > > 100:39.68 java
> > > 1181 oracle 18 0 755m 301m 12m S 0.3 1.9
> > > 4:31.23 java
> > > 1557 root 10 -5 0 0 0 S
> > > 0.3 0.0 3:26.96 kjournald
> > > 11364 oracle 15 0 1569m 175m 3820 S 0.3 1.1
> > > 32:50.70 java
> > > 32579 oracle 21 0 3358m 1.2g 5264 S 0.3 7.9
> > > 57:14.52 java
>
> > And... what is the problem? I don't see anything wrong?
>
> > Matthias
>
> Response is slow.
> The server has 16GB of RAM and its using over 15.5 GB of RAM. Cache
> is high.
top is misleading about how much memory oracle uses, as it doesn't account properly for shared memory, you can see that with ipcs. If you have access to MOS (oracle support), there are docs that explain how to figure out how much memory oracle uses on unix. There are also web pages floating about explaining how to mine proc, as well as hugepages issues.
But even without all that, an admin ought to understand linux is going to use up all the memory it can, whether for file access buffers or to keep executables around because they might be used again or whatever.
Slow database performance is not fixed by magic parameters, it is fixed by finding out what the holdup is and fixing that. Entire books have been written on the subject, including in the official doc set.
You can start by looking at dbconsole, though that is by no means a magic gui.
Welcome to the group, and see http://dbaoracle.net/readme-cdos.htm#subj12
jg
-- _at_home.com is bogus. http://news.techworld.com/sme/3341396/oracle-says-cloud-computing-threatens-role-of-cios/Received on Thu Mar 01 2012 - 11:36:28 CST