D
durgaprasad m
Guest
Present situation of the database 04/11/18 Status: Shared Memory Segments 09:25:07 Seg Id Size Used Free 1 22 134217728 134217724 4 2 23 134217728 134217724 4 3 24 134217728 134217716 12 4 25 134217728 134217716 12 5 26 134217728 120258516 13959212 6 27 25251840 396 25251444 Total Paging Space Percent Used 4608MB 1% IPCS comand output : p-10004*:/progdata/prd/slcdb1: ipcs -am IPC status from /dev/mem as of Wed Apr 11 09:29:21 EDT 2018 T ID KEY MODE OWNER GROUP CREATOR CGROUP NATTCH SEGSZ CPID LPID ATIME DTIME CTIME Shared Memory: m 131072 0x78000033 --rw-rw-rw- root system root system 1 33554432 41288 434112 6:55:29 9:21:16 2:05:50 m 131073 0x7800002e --rw-rw-rw- root system root system 1 33554432 41288 434112 6:55:29 9:21:16 2:05:50 m 131074 0x0d05332f --rw-rw---- root system root system 173 1440 16552 432508 9:29:16 9:29:21 2:05:02 m 3 0xffffffff --rw-r--r-- pgresdba progress pgresdba progress 1 2830336 40370 40370 2:07:16 no-entry 2:07:16 m 4 0xffffffff --rw-r--r-- pgresdba progress pgresdba progress 1 2830336 53958 294206 7:00:03 7:00:03 2:07:16 m 5 0xffffffff --rw-r--r-- pgresdba progress pgresdba progress 1 2830336 40006 198430 7:00:02 7:00:02 2:07:16 m 6 0xffffffff --rw-r--r-- pgresdba progress pgresdba progress 1 3678208 54462 54462 2:07:16 no-entry 2:07:16 m 7 0xffffffff --rw-r--r-- pgresdba progress pgresdba progress 52 6307840 40778 365608 8:26:08 8:26:08 2:07:16 m 8 0xffffffff --rw-r--r-- pgresdba progress pgresdba progress 1 2830336 44140 44140 2:07:16 no-entry 2:07:16 m 9 0xffffffff --rw-r--r-- pgresdba progress pgresdba progress 52 6426624 41602 357358 8:25:27 8:25:27 2:07:16 m 10 0xffffffff --rw-r--r-- pgresdba progress pgresdba progress 4 128491520 56762 130058 6:43:55 6:44:09 2:07:16 m 11 0xffffffff --rw-r--r-- pgresdba progress pgresdba progress 52 6246400 57020 365092 8:26:07 8:26:07 2:07:16 m 12 0xffffffff --rw-r--r-- pgresdba progress pgresdba progress 14 134217728 57794 148452 7:00:01 7:00:01 2:07:16 m 13 0xffffffff --rw-r--r-- pgresdba progress pgresdba progress 14 134217728 57794 148452 7:00:01 7:00:01 2:07:16 m 14 0xffffffff --rw-r--r-- pgresdba progress pgresdba progress 14 134217728 57794 148452 7:00:01 7:00:01 2:07:16 m 15 0xffffffff --rw-r--r-- pgresdba progress pgresdba progress 14 134217728 57794 148452 7:00:01 7:00:01 2:07:16 m 16 0xffffffff --rw-r--r-- pgresdba progress pgresdba progress 14 126713856 57794 148452 7:00:01 7:00:01 2:07:16 m 17 0xffffffff --rw-r--r-- pgresdba progress pgresdba progress 9 134217728 58310 155544 7:00:02 7:00:02 2:07:16 m 18 0xffffffff --rw-r--r-- pgresdba progress pgresdba progress 9 134217728 58310 155544 7:00:02 7:00:02 2:07:16 m 19 0xffffffff --rw-r--r-- pgresdba progress pgresdba progress 9 134217728 58310 155544 7:00:02 7:00:02 2:07:16 m 20 0xffffffff --rw-r--r-- pgresdba progress pgresdba progress 9 134217728 58310 155544 7:00:02 7:00:02 2:07:16 m 21 0xffffffff --rw-r--r-- pgresdba progress pgresdba progress 9 37187584 58310 155544 7:00:02 7:00:02 2:07:16 m 22 0xffffffff --rw-r--r-- pgresdba progress pgresdba progress 36 134217728 45974 485942 9:25:00 9:25:37 2:07:16 m 23 0xffffffff --rw-r--r-- pgresdba progress pgresdba progress 36 134217728 45974 485942 9:25:00 9:25:37 2:07:16 m 24 0xffffffff --rw-r--r-- pgresdba progress pgresdba progress 36 134217728 45974 485942 9:25:00 9:25:37 2:07:16 m 25 0xffffffff --rw-r--r-- pgresdba progress pgresdba progress 36 134217728 45974 485942 9:25:00 9:25:37 2:07:16 m 26 0xffffffff --rw-r--r-- pgresdba progress pgresdba progress 36 134217728 45974 485942 9:25:00 9:25:37 2:07:16 m 27 0xffffffff --rw-r--r-- pgresdba progress pgresdba progress 36 25251840 45974 485942 9:25:00 9:25:37 2:07:16 m 28 0xffffffff --rw-r--r-- pgresdba progress pgresdba progress 27 134217728 56506 310142 9:29:15 9:29:15 2:07:16 m 29 0xffffffff --rw-r--r-- pgresdba progress pgresdba progress 27 134217728 56506 310142 9:29:15 9:29:15 2:07:16 m 30 0xffffffff --rw-r--r-- pgresdba progress pgresdba progress 27 134217728 56506 310142 9:29:15 9:29:15 2:07:16 m 31 0xffffffff --rw-r--r-- pgresdba progress pgresdba progress 27 134217728 56506 310142 9:29:15 9:29:15 2:07:16 m 32 0xffffffff --rw-r--r-- pgresdba progress pgresdba progress 27 37175296 56506 310142 9:29:15 9:29:15 2:07:16 m 33 0xffffffff --rw-r--r-- pgresdba progress pgresdba progress 47 134217728 23630 472222 9:15:00 9:15:05 2:07:16 m 34 0xffffffff --rw-r--r-- pgresdba progress pgresdba progress 47 134217728 23630 472222 9:15:00 9:15:05 2:07:16 m 35 0xffffffff --rw-r--r-- pgresdba progress pgresdba progress 47 134217728 23630 472222 9:15:00 9:15:05 2:07:16 m 36 0xffffffff --rw-r--r-- pgresdba progress pgresdba progress 47 26300416 23630 472222 9:15:00 9:15:05 2:07:16 m 37 0xffffffff --rw-r--r-- pgresdba progress pgresdba progress 52 7151616 58570 476054 9:23:42 9:23:42 2:07:16 m 38 0xffffffff --rw-r--r-- pgresdba progress pgresdba progress 5 6672384 59860 160942 4:38:02 4:38:43 2:07:16 m 39 0xffffffff --rw-r--r-- pgresdba progress pgresdba progress 30 134217728 42856 450010 9:20:01 9:20:01 2:07:16 m 40 0xffffffff --rw-r--r-- pgresdba progress pgresdba progress 30 134217728 42856 450010 9:20:01 9:20:01 2:07:16 m 41 0xffffffff --rw-r--r-- pgresdba progress pgresdba progress 30 134217728 42856 450010 9:20:01 9:20:01 2:07:16 m 42 0xffffffff --rw-r--r-- pgresdba progress pgresdba progress 30 134217728 42856 450010 9:20:01 9:20:01 2:07:16 m 43 0xffffffff --rw-r--r-- pgresdba progress pgresdba progress 30 126652416 42856 450010 9:20:01 9:20:01 2:07:16 m 44 0xffffffff --rw-r--r-- pgresdba progress pgresdba progress 5 43663360 60890 263182 4:37:28 4:37:49 2:07:16 m 45 0xffffffff --rw-r--r-- pgresdba progress pgresdba progress 22 134217728 59090 478866 9:20:07 9:20:07 2:07:16 m 46 0xffffffff --rw-r--r-- pgresdba progress pgresdba progress 22 134217728 59090 478866 9:20:07 9:20:07 2:07:16 m 47 0xffffffff --rw-r--r-- pgresdba progress pgresdba progress 22 134217728 59090 478866 9:20:07 9:20:07 2:07:16 m 48 0xffffffff --rw-r--r-- pgresdba progress pgresdba progress 22 134217728 59090 478866 9:20:07 9:20:07 2:07:16 m 49 0xffffffff --rw-r--r-- pgresdba progress pgresdba progress 22 38039552 59090 478866 9:20:07 9:20:07 2:07:16 m 50 0xffffffff --rw-r--r-- pgresdba progress pgresdba progress 5 41148416 61408 465230 9:05:00 9:05:06 2:07:16 m 51 0xffffffff --rw-r--r-- pgresdba progress pgresdba progress 4 2891776 61924 320412 7:00:02 7:00:02 2:07:16 System configuration: lcpu=6 mem=22528MB ent=2.90 kthr memory page faults cpu ----- ----------- ------------------------ ------------ ----------------------- r b avm fre re pi po fr sr cy in sy cs us sy id wa pc ec 1 0 1821474 70132 0 0 0 0 0 0 425 127514 9687 26 13 60 1 1.43 49.2 0 0 1821324 70097 0 0 0 0 0 0 611 19809 6391 6 7 84 3 0.47 16.2 1 0 1820366 71023 0 0 0 0 0 0 544 76921 4776 10 11 74 5 0.72 24.8 0 0 1819724 71637 0 0 0 0 0 0 305 15837 4518 3 5 91 1 0.30 10.3 1 0 1819998 70824 0 0 0 0 0 0 1070 227439 5869 12 11 77 1 0.81 27.8 PROGRESS Version 9.1E as of Tue Oct 12 17:19:22 EDT 2004 PROGRESS SHARED MEMORY STATUS ID ShMemVer Seg# InUse Database 131072 - - - (not PROGRESS) 131073 - - - (not PROGRESS) *svmon -Pt15 | perl -e 'while(<>){print if($.==2||$&&&!$s++);$.=0 if(/^-+$/)}' Pid Command Inuse Pin Pgsp Virtual 64-bit Mthrd 16MB 196652 _sqlsrv2 2858997 34581 0 218297 N Y N 188694 _sqlsrv2 2858248 34577 0 217548 N Y N 105538 _progres 2858101 34569 0 216373 N N N 92372 _progres 2858101 34569 0 216373 N N N 125142 _progres 2858101 34569 0 216373 N N N 106838 _progres 2858101 34569 0 216373 N N N 189660 _sqlsrv2 2858034 34576 0 217334 N Y N 259304 _mprosrv 2856955 34569 0 215892 N N N 58062 _mprosrv 2856940 34569 0 215877 N N N 137794 _mprosrv 2856936 34569 0 215873 N N N 170554 _mprosrv 2856936 34569 0 215873 N N N 386766 _mprosrv 2856935 34569 0 215872 N N N 94514 _mprosrv 2856935 34569 0 215872 N N N 354772 _mprosrv 2856933 34569 0 215870 N N N 412070 _mprosrv 2856933 34569 0 215870 N N N
Continue reading...
Continue reading...
