topic Re: Memory issue when I start Oracle 10g in Operating System - Linux

Memory issue when I start Oracle 10g

Matthew Ghofrani — Thu, 02 Nov 2006 08:48:55 GMT

After starting my Oracle 10g, I get the following in the "ipcs -mba" command.
T ID KEY MODE OWNER GROUP SEGSZ
m 17416 0x00000000 D-rw------- ora10g oinstall 1474564

The man page says "The associated shared memory segment has been removed. It will disappear when the last process attached to the segment detaches it."

Any ideas as why ? Should I worry about this "D”?

Re: Memory issue when I start Oracle 10g

Steven E. Protter — Thu, 02 Nov 2006 09:23:08 GMT

Shalom,

Probably an Oracle application bug.

Oracle is famous for memory leaks and not releasing memory.

If you have an application written to use oracle code it could also be due to poor programming practices.

If it does not impact the users I would not be overly concerned.

SEP

Re: Memory issue when I start Oracle 10g

Matthew Ghofrani — Thu, 02 Nov 2006 10:18:49 GMT

Well, are you suggesting that I should ignore this "D" because it is Oracle related or ignore this "D" no matter what?

Re: Memory issue when I start Oracle 10g

Mike Stroyan — Thu, 02 Nov 2006 11:48:12 GMT

The "D" status is actually associated with a very common practice. The way that system V shared memory works makes it easy to loose track of resources. By default a shared memory segment will continue to exist if the process that created it dies. Its lifespan is kind of like that of a file. (But it goes away on reboot.) That behavior can easily lead to unwanted shared memory segments that linger.

The common practice is to create a shared memory segment and then map it and "remove" it with shmctl(IPC_RMID). The segment continues to exist for processes that have it mapped and for forked child processes. But it will go away as soon as all processes that have it mapped go away. That is the way to ensure that the segment won't linger too long. (It is very like unlinking a tmp file so that it will go away when a process exits.)