- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: oracle memory utilization too high on hpux 11i...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-20-2009 07:49 AM
тАО04-20-2009 07:49 AM
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-20-2009 08:07 AM
тАО04-20-2009 08:07 AM
Re: oracle memory utilization too high on hpux 11iv3
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 !!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-20-2009 08:11 AM
тАО04-20-2009 08:11 AM
Re: oracle memory utilization too high on hpux 11iv3
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 ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-20-2009 08:43 AM
тАО04-20-2009 08:43 AM
Re: oracle memory utilization too high on hpux 11iv3
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-20-2009 09:41 AM
тАО04-20-2009 09:41 AM
Re: oracle memory utilization too high on hpux 11iv3
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
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-21-2009 06:34 AM
тАО04-21-2009 06:34 AM
Re: oracle memory utilization too high on hpux 11iv3
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-21-2009 06:45 AM
тАО04-21-2009 06:45 AM
Solutionkctune filecache_max=15%
HTH
Duncan
I am an HPE Employee
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-21-2009 06:47 AM
тАО04-21-2009 06:47 AM
Re: oracle memory utilization too high on hpux 11iv3
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
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-21-2009 07:54 AM
тАО04-21-2009 07:54 AM
Re: oracle memory utilization too high on hpux 11iv3
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-21-2009 09:40 AM
тАО04-21-2009 09:40 AM