Skip to content
October 22, 2015 / doganay

CLEAN ORPHAN ORACLE MEMORY AREAS

Mustafa DOGANAY's Blog

$ ipcs -mb
IPC status from <running system> as of ..
T ID KEY MODE OWNER GROUP SEGSZ
Shared Memory:
m 385876016 0xf93bd858 --rw-r----- oracle dba 8192
m 385876015 0x0 --rw-r----- oracle dba 2600468480
m 369098798 0x0 --rw-r----- oracle dba 33554432

$ ## or use sysresv command:
$ sysresv
IPC Resources for ORACLE_SID "MYDB" :
Shared Memory:
ID KEY
385876016 0xf93bd858
385876015 0x00000000
369098798 0x99176dc0
Semaphores:
ID KEY
....
Oracle Instance alive for sid "MYDB"
$ ipcrm -m 385876015
$ ipcrm -m 385876016
$ ipcrm -m 369098798

View original post

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: