Re: When we need to remove Oracle share memory ID?

On Aug 17, 8:35 am, "newbie" <n..._at_new.com> wrote:
> Hi ,
>
> It's Oracle 9.2.0.8 on Solaris 9.
>
> 1. When do we need to remove those Oracle share memory ID to release more
> memory?

The easiest way is to shut down the instance. If there are any left, it is likely they should be removed. But like hpuxrac suggested, look on metalink for docs explaining it, especially look for the ones about figuring out the key value, even if some are way old. Note:123322.1, Note:1020329.6 and Note:153961.1 are a good start.

>
> 2. Do following outputs look like normal or abnormal?

See http://marist89.blogspot.com/ for one person's journey on that question. Remember, there are things that apply to all unix/linux, some things that are very platform/hardware specific, and some things vary with kernel settings.

jg

--
@home.com is bogus.
http://forums.oracle.com/forums/thread.jspa?messageID=2332619&tstart=0