LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 03-16-2017, 02:51 PM   #1
bala1989murugan
LQ Newbie
 
Registered: Sep 2016
Posts: 16

Rep: Reputation: Disabled
Oracle Database - High memory consumption


Hi Team,

We are running 2 servers for Oracle with Clustering configuration.
62GB RAM installed on both servers. 61GB occupied
Cache is 59GB occupied.
Swap memory is 1.3GB occupied.

I have checked top processes. It shows lots of processes related to Oracle. (ps -eo pmem,pcpu,vsize,pid,cmd | sort -k 1 -nr | head -5)
After that I have checked with AWR report from Oracle, It shows Oracle occupies 25% of memory.

What could be the issue?
How to reduce the memory utilization?




Same issue in my test server as well. But test server not into cluster.
 
Old 03-16-2017, 03:45 PM   #2
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 23,960

Rep: Reputation: 7032Reputation: 7032Reputation: 7032Reputation: 7032Reputation: 7032Reputation: 7032Reputation: 7032Reputation: 7032Reputation: 7032Reputation: 7032Reputation: 7032
Quote:
Originally Posted by bala1989murugan View Post
Hi Team,
We are running 2 servers for Oracle with Clustering configuration.
62GB RAM installed on both servers. 61GB occupied
Cache is 59GB occupied.
Swap memory is 1.3GB occupied.

I have checked top processes. It shows lots of processes related to Oracle. (ps -eo pmem,pcpu,vsize,pid,cmd | sort -k 1 -nr | head -5)
After that I have checked with AWR report from Oracle, It shows Oracle occupies 25% of memory.
What could be the issue?
How to reduce the memory utilization?


Same issue in my test server as well. But test server not into cluster.
Well, since you're using Oracle, which is a commercial product, what does Oracle support say???

Read the "Question Guidelines" link in my posting signature. While you've provided some details about your server, you omit the version/distro of Linux, how many users, how large the database is, any relevant log file information, or any troubleshooting you've done. All we know is you're using Oracle and you *SAY* it's using a lot of memory. Could be totally normal...how long has this server been up? Any user/lag issues with the database?? What, exactly, makes you think you're having an issue???

Again, you're using Oracle cluster...contact the Oracle support that you are PAYING FOR...RIGHT???
 
Old 03-16-2017, 04:04 PM   #3
sundialsvcs
LQ Guru
 
Registered: Feb 2004
Location: SE Tennessee, USA
Distribution: Gentoo, LFS
Posts: 9,240
Blog Entries: 4

Rep: Reputation: 3263Reputation: 3263Reputation: 3263Reputation: 3263Reputation: 3263Reputation: 3263Reputation: 3263Reputation: 3263Reputation: 3263Reputation: 3263Reputation: 3263
Also note that cache/buffer is an opportunistic use of memory: Linux is pleased to put all of your RAM to work for this purpose if it has nothing else to do with it. These are read-only assets that will be flushed whenever the need arises, e.g. to make room for some process's working set.

Linux takes the very pragmatic view that "memory is an asset that is there to be used, and we shall find some way to use all of it." If it has no other use for it right now, it'll fill memory "almost up to the rafters" with buffers and cache.

The modest use of swap also does not concern me. If a process goes completely inactive, it might get swapped out. But you ought not see a steady stream of swap-I/O activity.

Last edited by sundialsvcs; 03-16-2017 at 04:07 PM.
 
1 members found this post helpful.
Old 03-16-2017, 09:46 PM   #4
jefro
Moderator
 
Registered: Mar 2008
Posts: 21,003

Rep: Reputation: 3408Reputation: 3408Reputation: 3408Reputation: 3408Reputation: 3408Reputation: 3408Reputation: 3408Reputation: 3408Reputation: 3408Reputation: 3408Reputation: 3408
I too might ask Oracle for clues and that swap low isn't an issue yet.

I get the feeling that Oracle has a setting that tries to take up ram but there are plenty of web pages that tell how to locate it's use more than by using top. While top is a good start, it doesn't fully show the issues. Doesn't say how this as built system should work.

Programs can be written to use swap or not or anywhere between.
 
Old 03-17-2017, 04:18 AM   #5
bala1989murugan
LQ Newbie
 
Registered: Sep 2016
Posts: 16

Original Poster
Rep: Reputation: Disabled
My oracle cluster running on Redhat Enterprise Linux 5.11 64 bit
DB Size is 67 GB
 
Old 03-17-2017, 08:01 AM   #6
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 23,960

Rep: Reputation: 7032Reputation: 7032Reputation: 7032Reputation: 7032Reputation: 7032Reputation: 7032Reputation: 7032Reputation: 7032Reputation: 7032Reputation: 7032Reputation: 7032
Quote:
Originally Posted by bala1989murugan View Post
My oracle cluster running on Redhat Enterprise Linux 5.11 64 bit DB Size is 67 GB
Ok, thanks for the details. But I hope you realize that you're using RHEL 5.11, which is END OF LIFE and totally unsupported, right? Are you paying for your RHEL subscription, along with Oracle?? You have until the end of this month for RHEL assistance with 5.11...until then, you're in a supported configuration. You should use the support you're paying for from both vendors.

That said, 67GB isn't huge, but you still haven't said anything else about how long has this server been up (as in, new server or one that's been around a while?) Any user/lag issues with the database?? What, exactly, makes you think you're having an issue??? And you mention Oracle clustering...have you looked at THOSE settings??

The big thing here is "What makes you think you're having a problem?" Again, has anyone said the DB is slow? Bad performance? What/who/how-many are accessing this database concurrently??? Without details we cannot help you, and again the best people to call for help would be the Oracle support you're paying for.
 
1 members found this post helpful.
  


Reply

Tags
clustering, oracle, oracle database


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
AIX 7.1 on Power 750 is very slow with no high memory or process consumption aLuViAn AIX 11 03-05-2014 08:55 AM
High memory usage on Linux Server running with oracle DB ravindert Linux - Server 5 02-02-2013 10:29 AM
High I/O wait observed in Linux based Oracle Database Server rajaniyer123 Linux - General 3 01-16-2012 09:00 PM
Apps have high virtual memory consumption Lothar Schwab Linux - General 3 08-25-2007 08:41 PM
high memory consumption and slow speed ryancw Linux - Newbie 1 03-24-2004 09:10 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 07:30 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration