建设工程质量监理协会网站,wordpress 网址站,网站推广南京公司,海南高端建设网站[20190104]ipcs查看共享内存段.txt--//数据库启动异常,有时候会留下一些共享内存段没有清理,需要使用ipcrm清理.--//由于服务器上跑2个实例,必须选择正确的共享内存段,否则会导致别的数据库crash.--//在我工作中,这是遇到的第2次,做一些复习与整理:--//在linux下有一个命令sysr…[20190104]ipcs查看共享内存段.txt--//数据库启动异常,有时候会留下一些共享内存段没有清理,需要使用ipcrm清理.--//由于服务器上跑2个实例,必须选择正确的共享内存段,否则会导致别的数据库crash.--//在我工作中,这是遇到的第2次,做一些复习与整理:--//在linux下有一个命令sysresv可以查看某实例使用的共享内存段.$ ipcs------ Shared Memory Segments --------key shmid owner perms bytes nattch status0x00000000 287440897 oracle 600 12288 2 dest0x00000000 287473666 oracle 600 196608 2 dest0x00000000 287506435 oracle 600 12288 2 dest0x00000000 287211524 oracle 600 393216 2 dest0x00000000 287244293 oracle 600 393216 2 dest0x00000000 287277062 oracle 600 393216 2 dest0x00000000 287309831 oracle 600 196608 2 dest0x00000000 287342600 oracle 600 393216 2 dest0x00000000 287375369 oracle 600 196608 2 dest0x00000000 287408138 oracle 600 393216 2 dest0x00000000 301334539 oracle 640 12582912 25~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~0x00000000 301367308 oracle 640 633339904 25~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~0xe8a8ec10 301400077 oracle 640 2097152 25~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~0x790209cd 294617102 oracle 666 808 00x79020002 294649871 oracle 666 808 0------ Semaphore Arrays --------key semid owner perms nsems0x6aa88594 275578880 oracle 640 184~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~0x790209cd 269713409 oracle 666 10x79020002 269746178 oracle 666 1------ Message Queues --------key msqid owner perms used-bytes messages$ export ORACLE_SIDbook$ sysresvIPC Resources for ORACLE_SID book :Shared Memory:ID KEY301334539 0x00000000301367308 0x00000000301400077 0xe8a8ec10Semaphores:ID KEY275578880 0x6aa88594Oracle Instance alive for sid book--//下划线内容可以对上.--//注意执行前最好指定确认ORACLE_SID环境变量.man ipcrm-m shmid removes the shared memory segment identified by shmid after the last detach is performed.--//ipcrm 参数-m 对应 shmid.--//另外ipcs有一个参数-t参看time.$ ipcs -t------ Shared Memory Attach/Detach/Change Times --------shmid owner attached detached changed287440897 oracle Dec 12 17:37:06 Dec 12 17:37:07 Dec 5 17:32:14287473666 oracle Dec 12 17:37:06 Dec 12 17:37:07 Dec 5 17:32:14287506435 oracle Dec 12 17:37:06 Dec 12 17:37:07 Dec 5 17:32:14287211524 oracle Dec 12 17:37:06 Dec 12 17:37:07 Dec 5 15:42:08287244293 oracle Dec 12 17:37:06 Dec 12 17:37:07 Dec 5 15:42:08287277062 oracle Dec 12 17:37:06 Dec 12 17:37:07 Dec 5 15:42:08287309831 oracle Dec 12 17:37:06 Dec 12 17:37:07 Dec 5 15:42:08287342600 oracle Dec 12 17:37:06 Dec 12 17:37:07 Dec 5 15:42:09287375369 oracle Dec 12 17:37:06 Dec 12 17:37:07 Dec 5 15:42:17287408138 oracle Dec 12 17:37:06 Dec 12 17:37:07 Dec 5 15:42:17301334539 oracle Jan 4 10:13:32 Jan 4 10:14:02 Jan 4 09:53:20301367308 oracle Jan 4 10:13:32 Jan 4 10:14:02 Jan 4 09:53:20301400077 oracle Jan 4 10:13:32 Jan 4 10:14:02 Jan 4 09:53:20294617102 oracle Dec 24 09:22:37 Dec 24 09:22:37 Dec 24 09:22:37294649871 oracle Dec 24 10:03:22 Dec 24 10:08:55 Dec 24 09:23:01------ Semaphore Operation/Change Times --------semid owner last-op last-changed275578880 oracle Fri Jan 4 10:14:43 2019 Fri Jan 4 10:14:43 2019269713409 oracle Mon Dec 24 09:22:37 2018 Mon Dec 24 09:22:37 2018269746178 oracle Mon Dec 24 10:08:55 2018 Mon Dec 24 09:23:01 2018------ Message Queues Send/Recv/Change Times --------msqid owner send recv change--//我仔细看了一下.如果有用户连上attached会变化,退出后detached时间也会变化.说明有用户使用.--//最后一列changed视乎都不变,不知道是否对应oracle实例的启动时间.SYSbook select startup_time from v$instance ;STARTUP_TIME-------------------2019-01-04 09:53:21--//视乎可以对上.--//另外使用oradebug ipc命令也可以查看.SYSbook oradebug setmypidStatement processed.SYSbook oradebug ipcIPC information written to the trace fileSYSbook oradebug tracefile_name/u01/app/oracle/diag/rdbms/book/book/trace/book_ora_7252.trc*** 2019-01-04 10:25:15.026Processing Oradebug command ipcDump of unix-generic skgm contextareaflags 000000f7realmflags 0000001fmapsize 00000800protectsize 00001000lcmsize 00001000seglen 00200000largestsize 0000000480000000smallestsize 0000000000400000stacklimit 0x7fffc0268300stackdir -1mode 640magic acc01adeHandle: 0x7f0b488e40b0 /u01/app/oracle/product/11.2.0.4/dbhome_1book--//注意这是句柄,还记得环境变量ORACLE_HOME后面带斜线的设置导致无法连上数据库的问题吗?11.2.0.4已经没有这个问题了.$ echo $ORACLE_HOME/u01/app/oracle/product/11.2.0.4/dbhome_1--//参看链接:http://blog.itpub.net/267265/viewspace-2055052/[20160310]神奇的斜线.txtDump of unix-generic realm handle /u01/app/oracle/product/11.2.0.4/dbhome_1book, flags 00000000Area #0 Fixed Size containing Subareas 0-0Total size 0000000000226c00 Minimum Subarea size 00000000Area Subarea Shmid Stable Addr Actual Addr0 0 301334539 0x00000060000000 0x00000060000000Subarea size Segment size0000000000227000 0000000000c00000Area #1 Variable Size containing Subareas 4-4Total size 0000000025c00000 Minimum Subarea size 00400000Area Subarea Shmid Stable Addr Actual Addr1 4 301367308 0x00000060c00000 0x00000060c00000Subarea size Segment size0000000025c00000 0000000025c00000Area #2 Redo Buffers containing Subareas 1-1Total size 0000000000724000 Minimum Subarea size 00000000Area Subarea Shmid Stable Addr Actual Addr2 1 301334539 0x00000060227000 0x00000060227000Subarea size Segment size0000000000724000 0000000000c00000Area #3 Base Allocator Control containing Subareas 3-3Total size 0000000000002000 Minimum Subarea size 00000000Area Subarea Shmid Stable Addr Actual Addr3 3 301334539 0x00000060bfe000 0x00000060bfe000Subarea size Segment size0000000000002000 0000000000c00000Area #4 Slab Allocator Control containing Subareas 2-2Total size 00000000002b3000 Minimum Subarea size 00000000Area Subarea Shmid Stable Addr Actual Addr4 2 301334539 0x0000006094b000 0x0000006094b000Subarea size Segment size00000000002b3000 0000000000c00000Area #5 skgm overhead containing Subareas 5-5Total size 0000000000002000 Minimum Subarea size 00000000Area Subarea Shmid Stable Addr Actual Addr5 5 301400077 0x00000086800000 0x00000086800000Subarea size Segment size0000000000002000 0000000000200000Dump of Linux-specific skgm context-------------- system semaphore information ------------------- Shared Memory Segments --------key shmid owner perms bytes nattch status0x00000000 287440897 oracle 600 12288 2 dest0x00000000 287473666 oracle 600 196608 2 dest0x00000000 287506435 oracle 600 12288 2 dest0x00000000 287211524 oracle 600 393216 2 dest0x00000000 287244293 oracle 600 393216 2 dest0x00000000 287277062 oracle 600 393216 2 dest0x00000000 287309831 oracle 600 196608 2 dest0x00000000 287342600 oracle 600 393216 2 dest0x00000000 287375369 oracle 600 196608 2 dest0x00000000 287408138 oracle 600 393216 2 dest0x00000000 301334539 oracle 640 12582912 260x00000000 301367308 oracle 640 633339904 260xe8a8ec10 301400077 oracle 640 2097152 260x790209cd 294617102 oracle 666 808 00x79020002 294649871 oracle 666 808 0------ Semaphore Arrays --------key semid owner perms nsems0x6aa88594 275578880 oracle 640 1840x790209cd 269713409 oracle 666 10x79020002 269746178 oracle 666 1------ Message Queues --------key msqid owner perms used-bytes messages--//仅仅前面部分的显示该实例使用共享内存段.
