Solved

Defragment Memory on HP N-Class running HP-UX 11 / Oracle 9

Posted on 2004-04-02
6
1,607 Views
Last Modified: 2013-12-06
Does anyone know how I can defragment physical memory on an N-class running HP-UX 11.0 ?
When I start oracle, I get an error about not enough contiguous memory, and I believe that other processes are coredumping without deallocating memory.
I need to clear up the "memory leaks" and defrag what is in use.
Any ideas?
0
Comment
Question by:simpsop
6 Comments
 
LVL 40

Expert Comment

by:jlevie
Comment Utility
Does this happen right after a reboot? If it does it might indicate that there's insufficient physical memory in the machine.
0
 
LVL 20

Expert Comment

by:tfewster
Comment Utility
If a process dies & coredumps, HP-UX will clean up after it.  To be honest, I've never heard of "contiguous" memory and I can't see the advantage as all in-memory I/O operations are virtually instantaneous.

Expanding on jlevies post:
Check physical memory with `dmesg |grep Physical`; The system may have disabled a bank of memory if it has persistant faults. Remember that a pecentage of Physical memory is reserved for the operating system, plus a percentage for disk caching - But the dmesg output should show you the "usable" amount.
Check the allocated swap with `swapinfo`. Though you don't really want the system to be paging/swapping oracle processes as performance will nose-dive...
Check the Oracle SGA (shared memory config) which grabs a chunk of memory as the DB starts up. If it is trying to grab more memory than is available, HP-UX would allow it but  Oracle may well complain...
0
 
LVL 61

Accepted Solution

by:
gheist earned 500 total points
Comment Utility
Maybe some app does not release shared memory segment(when crashing), check out ipcs -m, and remove unreferenced segments with ipcrm -m ID

Oracle allocates SGA residing in RAM, which may be more than your system has or permits in user specific limit config
(check out ulimit -a or limit)
0
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 14

Expert Comment

by:chris_calabrese
Comment Utility
Modern systems do not have the concept of 'contiguous' physical memory, since each process sees only its virtual memory space as mapped to physical memory through the MMU. More likely, jlevie is correct that there isn't enough physical memory on the system to support the Oracle install.
0
 
LVL 20

Expert Comment

by:tfewster
Comment Utility
I did a bit of searching after I sobered up, and Oracle still requires contiguous memory within the Shared memory area - See http://www.databasejournal.com/features/oracle/article.php/2195001  - Which tends to back up gheists tip on tidying up Shared memory & the others comments about physical memory
0
 
LVL 61

Expert Comment

by:gheist
Comment Utility
and make sure SGA size in ora.ini is smaller than locked size, data size or system memory
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Microsoft Windows Services for UNIX 3.5 - Sed 4 47
AIX  NFS  question 1 98
ftpcommand 2 50
unix in java example 9 38
Installing FreeBSD… FreeBSD is a darling of an operating system. The stability and usability make it a clear choice for servers and desktops (for the cunning). Savvy?  The Ports collection makes available every popular FOSS application and packag…
Why Shell Scripting? Shell scripting is a powerful method of accessing UNIX systems and it is very flexible. Shell scripts are required when we want to execute a sequence of commands in Unix flavored operating systems. “Shell” is the command line i…
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now