環境:
[plain]
- [Oracle@ www.linuxidc.com ~]$ uname -a
- Linux simpleit.domain.cn 2.6.18-194.el5 #1 SMP Fri Apr 2 14:58:35 EDT 2010 i686 athlon i386 GNU/Linux
- [oracle@ www.linuxidc.com ~]$ cat /etc/RedHat-release
- CentOS release 5.5 (Final)
ipcs確定共享內存的使用情況,該命令用於輸出系統中處於active狀態的消息隊列,共享內存段以及信號量的有關消息。
[plain]
- DESCRIPTION
- The ipcs utility shall write information about active interprocess communication facili-
- ties.
-
- Without options, information shall be written in short format for message queues, shared
- memory segments, and semaphore sets that are currently active in the system. Otherwise, the
- information that is displayed is controlled by the options specified.
-
-
- -b Write information on maximum allowable size. (Maximum number of bytes in messages on
- queue for message queues, size of segments for shared memory, and number of
- semaphores in each set for semaphores.)
-
-
- [oracle@ www.linuxidc.com ~]$ ipcs -b
- ipcs: invalid option -- b
- usage : ipcs -asmq -tclup
- ipcs [-s -m -q] -i id
- ipcs -h for help.
- [oracle@ www.linuxidc.com ~]$ ipcs
-
- ------ Shared Memory Segments --------
- key shmid owner perms bytes nattch status
- 0xe9b42ad8 2228225 oracle 640 88080384 13
- 0x8cdf18fc 2359299 oracle 640 528482304 26
-
- ------ Semaphore Arrays --------
- key semid owner perms nsems
- 0xbbe791cc 98304 oracle 640 44
- 0x9d085d3c 491521 oracle 640 154
-
- ------ Message Queues --------
- key msqid owner perms used-bytes messages
- [oracle@ www.linuxidc.com ~]$ ipcs -m
-
- ------ Shared Memory Segments --------
- key shmid owner perms bytes nattch status
- 0xe9b42ad8 2228225 oracle 640 88080384 13
- 0x8cdf18fc 2359299 oracle 640 528482304 26
通常最好讓整個SGA處於一個單一的共享內存段,因為跟蹤一個以上的段將需要額外的開銷,在這些段來回切換也需要時間。可以增加/etc/sysctl.conf文件kernel.shmmax參數值,以增加一個單一的共享內存段的最大尺寸。
# Controls the maximum shared segment size, in bytes
kernel.shmmax = 4294967295
使用ipcs可以查看系統的SGA是否由多個不連續的內存塊組成,如果數據庫失敗,在釋放內存時就會出現問題。使用ipcrm命令(僅僅用於在數據庫失敗之後SGA碎片沒有被釋放的情況)可以從內存中去除SGA碎片。不要在一個正在運行的數據庫中運行ipcrm命令。
ipcrm命令
[plain]
- DESCRIPTION
- The ipcrm utility shall remove zero or more message queues, semaphore sets, or shared mem-
- ory segments. The interprocess communication facilities to be removed are specified by the
- options.
-
- Only a user with appropriate privilege shall be allowed to remove an interprocess communi-
- cation facility that was not created by or owned by the user invoking ipcrm.
-
- -q msgid --隊列id
- Remove the message queue identifier msgid from the system and destroy the message
- queue and data structure associated with it.
-
- -m shmid --共享內存id
- Remove the shared memory identifier shmid from the system. The shared memory segment
- and data structure associated with it shall be destroyed after the last detach.
-
- -s semid --信號量id
- Remove the semaphore identifier semid from the system and destroy the set of
- semaphores and data structure associated with it.
- 比如 ipcrm -m 2359299