When we need to remove Oracle share memory ID?

From: newbie <new_at_new.com>
Date: Sun, 17 Aug 2008 23:35:55 +0800
Message-ID: <g89ggo$fa6$1@news.cn99.com>

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?
2. Do following outputs look like normal or abnormal?

Thanks,
Alan

$ ipcs -am

IPC status from <running system> as of Sun Aug 17 23:18:53 CST 2008

T         ID      KEY        MODE        OWNER    GROUP  CREATOR   CGROUP 
NATTCH      SEGSZ  CPID  LPID   ATIME    DTIME    CTIME
Shared Memory:
m        100   0          --rw-r-----   oracle      dba   oracle      dba 
27    4194304   555  9106 23:18:30 23:18:39 17:06:18
m          1   0          --rw-r-----   oracle      dba   oracle      dba 
27 3053453312   555  9106 23:18:30 23:18:39 17:06:18
m          2   0          --rw-r-----   oracle      dba   oracle      dba 
27 2281701376   555  9106 23:18:30 23:18:39 17:06:18
m          3   0          --rw-r-----   oracle      dba   oracle      dba 
27 3422552064   555  9106 23:18:30 23:18:39 17:06:18
m          4   0x9751468  --rw-r-----   oracle      dba   oracle      dba 

27 3426746368 555 9106 23:18:30 23:18:39 17:06:18

$ ipcs -am

IPC status from <running system> as of Sun Aug 17 23:19:05 CST 2008

T         ID      KEY        MODE        OWNER    GROUP  CREATOR   CGROUP 
NATTCH      SEGSZ  CPID  LPID   ATIME    DTIME    CTIME
Shared Memory:
m        100   0          --rw-r-----   oracle      dba   oracle      dba 
28    4194304   555  9118 23:19:01 23:18:39 17:06:18
m          1   0          --rw-r-----   oracle      dba   oracle      dba 
28 3053453312   555  9118 23:19:01 23:18:39 17:06:18
m          2   0          --rw-r-----   oracle      dba   oracle      dba 
28 2281701376   555  9118 23:19:01 23:18:39 17:06:18
m          3   0          --rw-r-----   oracle      dba   oracle      dba 
28 3422552064   555  9118 23:19:01 23:18:39 17:06:18
m          4   0x9751468  --rw-r-----   oracle      dba   oracle      dba 

28 3426746368 555 9118 23:19:01 23:19:01 17:06:18

$ ipcs -am

IPC status from <running system> as of Sun Aug 17 23:28:50 CST 2008

T         ID      KEY        MODE        OWNER    GROUP  CREATOR   CGROUP 
NATTCH      SEGSZ  CPID  LPID   ATIME    DTIME    CTIME
Shared Memory:
m        100   0          --rw-r-----   oracle      dba   oracle      dba 
24    4194304   555  9329 23:28:33 23:28:33 17:06:18
m          1   0          --rw-r-----   oracle      dba   oracle      dba 
24 3053453312   555  9329 23:28:33 23:28:33 17:06:18
m          2   0          --rw-r-----   oracle      dba   oracle      dba 
24 2281701376   555  9329 23:28:33 23:28:33 17:06:18
m          3   0          --rw-r-----   oracle      dba   oracle      dba 
24 3422552064   555  9329 23:28:33 23:28:33 17:06:18
m          4   0x9751468  --rw-r-----   oracle      dba   oracle      dba 

24 3426746368 555 9329 23:28:33 23:28:33 17:06:18
$
Received on Sun Aug 17 2008 - 10:35:55 CDT