Operating System - HP-UX
1747984 Members
4839 Online
108756 Solutions
New Discussion юеВ

Re: oracle memory utilization too high on hpux 11iv3

 
SOLVED
Go to solution
NXS
Valued Contributor

oracle memory utilization too high on hpux 11iv3

Hi,

I have a problem with a brand new install of oracle 10.2.0.4 on hpux bl860 itanium running 11iv3. When the database is started, we get after some minutes several warnings from the enterprise manager performance about memory usage : "memory utilization is too high (94%)" but the database does nothing ! It's not in production !.

Sga is about 2G, ram is 8G, swap is 12 G.
can anybody help me ?

Regards

Pol
10 REPLIES 10
UVK
Trusted Contributor

Re: oracle memory utilization too high on hpux 11iv3

The information available is minimal to advice. You must first try to isolate the problem.

1) Did you stop your DB and see what is the CPU utilization ?
2) Any other application running ?
3) Did you set all the kernal parameters recommanded by oracle ?

-uvk
-------------------------------------------
Like it or worked !! Click kudos !!
NXS
Valued Contributor

Re: oracle memory utilization too high on hpux 11iv3

Hi Uvk,

yes kernel has been tuned as in oracle documentation guide and release notes.
No other application is running on the system.
Database is not loaded now (no in production).
I thought perhaps metric van oracle was not foreseen for the way hpux manage the memory ?

Re: oracle memory utilization too high on hpux 11iv3

and what does Oracle Enterprise Manager know about memory on HP-UX to determine that 94% memory utilisation is "too high"? This sounds like an arbitrary setting in OEM to me - I'd ignore this sort of thing until you actually have a perofrmance problem... the kernel and file cache in 11iv3 are pretty greedy in terms of default memory usage, but they give it up when the system comes under memory pressure, so I wouldn't worry too much about what you are seeing.

It would be interesting to see what you have filecache_max and filecache_min set to...

kctune | grep filecache

HTH

Duncan

I am an HPE Employee
Accept or Kudo
Steven E. Protter
Exalted Contributor

Re: oracle memory utilization too high on hpux 11iv3

Shalom,

Pretty big SGA there. Do you need it that big?

http://www.hpux.ws/?p=8

That is a memory leak detector and can identify the process doing the leak.

My feeling is there is an Oracle fix for this. See http://metalink.oracle.com for more.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
NXS
Valued Contributor

Re: oracle memory utilization too high on hpux 11iv3

Hi shalom,

sga is as requested by the programmation team ...
Do you have more precise details about the fix ? I already searched for in metalink without success.

Thanks

Hi Duncan,

File_cache values should be standard, I did not modifyed them. But I'm not at the office. On thursday I will be able to send you the values.
Solution

Re: oracle memory utilization too high on hpux 11iv3

The default values for filecache_min and filecache_max are 5% and 50% repectively. The max value is proably far too high for an Oracle system... I'd tune that down to about 15% as a starter

kctune filecache_max=15%

HTH

Duncan

I am an HPE Employee
Accept or Kudo
Steven E. Protter
Exalted Contributor

Re: oracle memory utilization too high on hpux 11iv3

Shalom means hello, goodbye and peace in Hebrew. My Name is Steven.

I currently have no job and therefore no access to http://metalink.oracle.com

You need a support agreement with Oracle to enter the site and read the documentation on the Oracle fix.

Fixes are not free.

Sometimes you just have to roll the dice with Oracle fixes. I've had pretty good luck with this issue by updating Oracle in the past. It's not easy but this is typically why Oracle releases major fixes.

With regards to the programming team request, ask them to justify it. I want 2 GB of ram for my SGA too, but I might get by just fine with a single GB.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
NXS
Valued Contributor

Re: oracle memory utilization too high on hpux 11iv3

Woups Steven, sorry, I was in an hurry and typed while speaking on phone ...
Nevertheless I'm wondering if I'm not facing the same problem as on linux kernel where the message from EM are not relevant. There should be a note oracle 297627.1 but it's no more on the site of oracle.
I will check that on thursday.

Thank you
Court Campbell
Honored Contributor

Re: oracle memory utilization too high on hpux 11iv3

If this is strictly a database server then you can lower the file caching. Otherwise it doesn't hurt. 11.31 takes more of a linux memory management approach in that it uses any unused memory for caching.
"The difference between me and you? I will read the man page." and "Respect the hat." and "You could just do a search on ITRC, you don't need to start a thread on a topic that's been answered 100 times already." Oh, and "What. no points???"