LinuxQuestions.org
Go Job Hunting at the LQ Job Marketplace
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices

Reply
 
Search this Thread
Old 05-13-2011, 12:59 PM   #1
soulman_yu
LQ Newbie
 
Registered: Jan 2009
Posts: 8

Rep: Reputation: 0
OEL 5.5 and Oracle 10.2.0.5 low decrease of memory


Hi

I have an issue with few servers.

All have OEL 5.5 and various versions of oracle (mainly 10g something).

I've noticed on one machine that amount of free memory is slowly decreasing. When it comes to less then 30M, application has problems.

Ive tried adding mem on this machine (virtual), and it behaves the same.

The same is on physical machines I have simmilar, if not the same config. Variations are with physical memory installed, and it does not matter if servers have 2G, or 8G, free -m gives around 30 free

It does not swap, and does not make some big issues on other machines, but on this one, application that uses this DB timeouts the user.

Is there some chance to check what is creating this issue?

P.S. I've tried with DB admin to check something related to oracle itself, bit when we shutdown instance, Oracle frees 1.5G allocated to him, but nothing else.

Will try testimg a bit more, but any thought on this is usefull.
This is production server, so no big issues can be done. Will try to copy it to other hardware and do some testing, but then no App server available to attack it.

Any thoughts?
 
Old 05-15-2011, 03:11 AM   #2
kbp
Senior Member
 
Registered: Aug 2009
Posts: 3,758

Rep: Reputation: 643Reputation: 643Reputation: 643Reputation: 643Reputation: 643Reputation: 643
What have you set SGA to ?
 
0 members found this post helpful.
Old 05-16-2011, 05:55 AM   #3
soulman_yu
LQ Newbie
 
Registered: Jan 2009
Posts: 8

Original Poster
Rep: Reputation: 0
@kbp

SQL> show sga

Total System Global Area 1107296256 bytes
Fixed Size 2095672 bytes
Variable Size 704644552 bytes
Database Buffers 385875968 bytes
Redo Buffers 14680064 bytes

SQL> show parameter sga

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 1056M
sga_target big integer 1056M


SQL> show parameter pga

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
pga_aggregate_target big integer 349M
 
Old 05-16-2011, 07:30 PM   #4
kbp
Senior Member
 
Registered: Aug 2009
Posts: 3,758

Rep: Reputation: 643Reputation: 643Reputation: 643Reputation: 643Reputation: 643Reputation: 643
So if you're giving the db 1GB how much is left for the OS ?
 
0 members found this post helpful.
Old 06-09-2011, 06:14 AM   #5
soulman_yu
LQ Newbie
 
Registered: Jan 2009
Posts: 8

Original Poster
Rep: Reputation: 0
Solved

Few issues were found that did the trick in some way.

First, Oracle version was 10g, but initial default configuration files (limits.conf or something) is preconfigured for Oracle 11g. That needed to be changed in this case.

Other main thing, and I cant believe I was so blind, was that command free -m gives you free memory, but OEL grabs the rest for I/O cache, so what should be looked at was buffer line in the output of this command (free -m)

So, no memory leak existed, and all we should have done is to change preconfiured Oracle files.

Thanks
 
  


Reply

Tags
free, linux, memory, oracle10g


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
looking for free database that has low memory usage and innodb and memory like engin golden_boy615 Linux - Software 8 05-08-2011 07:05 AM
Memory corruption detected in low memory chris1274 Linux - General 2 08-23-2010 10:27 PM
LXer: Linux is now Oracle's low-end offering LXer Syndicated Linux News 0 02-21-2010 06:50 PM
LXer: Oracle puts low-price on information LXer Syndicated Linux News 0 02-26-2007 04:46 PM
increase free physical memory, decrease disk cache efm Linux - Hardware 4 03-30-2006 09:53 AM


All times are GMT -5. The time now is 06:59 AM.

Main Menu
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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration