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? |
What have you set SGA to ?
|
@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 |
So if you're giving the db 1GB how much is left for the OS ?
|
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 |
All times are GMT -5. The time now is 11:21 PM. |