- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Out of memory
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
тАО10-19-2005 09:21 PM
тАО10-19-2005 09:21 PM
Operating System HP-UX11i.
Physical RAM 3GB.
Database Oracle9.2.0.1.0
Two instanaces are running having SGA memory 1425MB and 290MB respectively.
Out of memory error is getting while application runs on frequently basis.
Attached screen shot is for referance.
Waiting for reply.
Rgds,
Mehul
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-19-2005 09:27 PM
тАО10-19-2005 09:27 PM
Re: Out of memory
any change of reducing the SGA with 1425MB or getting extra memory as 3GB is not exactly a lot? also, r the kernel parameter configure to accommodate 9.2.0.1?
u also sure have lots of unassigned points:
http://forums1.itrc.hp.com/service/forums/pageList.do?userId=CA1190244&listType=unassigned&forumId=1
regards.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-19-2005 09:28 PM
тАО10-19-2005 09:28 PM
Re: Out of memory
Also how is swap performing
swapinfo -mat
Also how cache has been set?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-19-2005 09:37 PM
тАО10-19-2005 09:37 PM
Re: Out of memory
It seems yuo're running out of memory.
RAM 3GB
SGA 1715MB
Then yuo need memory for your PGA (oracle processes). When you have too many of them you run out of mempory !
What is the swap area
please post
dbc_min_pct
dbc_max_pct
swapinfo -tam
You will probably have to review SGA size and other oracle parameters unless you can increase the total RAM
Regards
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-19-2005 10:15 PM
тАО10-19-2005 10:15 PM
Re: Out of memory
# swapinfo -mat
Mb Mb Mb PCT START/ Mb
TYPE AVAIL USED FREE USED LIMIT RESERVE PRI NAME
dev 6144 2467 3677 40% 0 - 1 /dev/vg00/lvol2
reserve - 3673 -3673
memory 2315 996 1319 43%
total 8459 7136 1323 84% - 0 -
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-19-2005 10:26 PM
тАО10-19-2005 10:26 PM
Re: Out of memory
you will have to decrease one of SGA or increase shmmax a bit. In any case, you shuold be adding memeory 3GB is not much of it for oracle.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-19-2005 10:37 PM
тАО10-19-2005 10:37 PM
Re: Out of memory
your are using real swap area, therefore you will get poor performance.
Too big a SGA (!) is not any help if you are swapping out
you should run perfstat report to see which arra can be resized (downward) until you get more RAM (you really need more !)
Regards
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-20-2005 12:30 AM
тАО10-20-2005 12:30 AM
Re: Out of memory
you should review your init.ora initialisation parameters. As mentioned about, the statspack report can help you in determining which instance requires more memory than the other.
hope this helps too!
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-20-2005 01:09 AM
тАО10-20-2005 01:09 AM
Re: Out of memory
Use shminfo program to show you how the shared memory map has become fragmented:
ftp://contrib:9unsupp8@hprc.external.hp.com/sysadmin/programs/shminfo/
There are several ways to fix the out-of-memory errors:
1. Reboot - the memory map will be rebuilt and everything will fit (not a good choice for a production machine).
2. Reduce the SGA sizes - Oracle will slow down as more activity is shifted from RAM to disk.
3. Upgrade Oracle and any middleware to 64bit execytables - now shared memory has a massively large map and fragmentation is longer an issue.
4. Implement memory windows - this involves creating a separate window for each instance of Oracle (and any middleware that uses Oracle SGA). This eliminates fragmentation because SGA is in a private memory space. This will not improve performance, it will just prevent the out of memory errors. You still need to double RAM for best performance.
Bill Hassell, sysadmin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-20-2005 01:55 AM
тАО10-20-2005 01:55 AM
Re: Out of memory
Oracle9i is 64bits
Regards
Jean-Luc