[20210218]shared latch spin count 6.txt --//测试遇到的情况,颠覆我对一些问题的理解: --//链接:[20210218]shared latch spin count 5.txt ->http://blog.itpub.net/267265/viewspace-2757533/ 1.环境: SYS@book> @ ver1 PORT_STRING VERSION BANNER ------------------------------ -------------- -------------------------------------------------------------------------------- x86_64/Linux 2.4.xx 11.2.0.4.0 Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production SYS@book> show parameter cpu_count NAME TYPE VALUE --------- ------- ------ cpu_count integer 3 SYS@book> @ hide _disable_cpu_check NAME DESCRIPTION DEFAULT_VALUE SESSION_VALUE SYSTEM_VALUE ISSES ISSYS_MOD ------------------ ----------------------- ---------------------- ---------------------- ---------------------- ----- --------- _disable_cpu_check disable cpu_count check TRUE FALSE FALSE FALSE FALSE --//虽然定义cpu_count=3,而实际上可以使用全部CPU资源. _disable_cpu_check=false $ cat peek.sh #! /bib/bash # 参数如下:latch_name Monitoring_duration or laddr sqlplus -s -l / as sysdba <<EOF col laddr new_value laddr SELECT sysdate,addr laddr FROM v\$latch_parent WHERE NAME='$1'; oradebug setmypid $(seq $2|xargs -I{} echo -e 'oradebug peek 0x&laddr 60\nhost sleep 1' ) EOF $ cat i6.sh #! /bin/bash zdate=$(date '+%H%M%S') echo $zdate source peek.sh 'gcs partitioned table hash' 1500 | timestamp.pl >| /tmp/peeks_${zdate}.txt & #seq 10 | xargs -I{} echo -e 'sqlplus -s -l / as sysdba <<< @latch_free\nsleep 1' | bash >| /tmp/latch_free_${zdate}.txt & sleep 1 # 参数如下: @ latch.txt latch_name willing why where mode sleep_num #seq 1500 | xargs -I {} -P 100 taskset 000001 sqlplus -s -l / as sysdba @ shared_latch.txt 'gcs partitioned table hash' 1 4 {} s 0.01 > /dev/null #seq 1500 | xargs -I {} -P 150 taskset 00000e sqlplus -s -l / as sysdba @ 10000.txt > /dev/null #seq 1500 | xargs -I {} -P 150 taskset 00000f sqlplus -s -l / as sysdba @ 10000.txt > /dev/null seq 1500 | xargs -I {} -P 150 sqlplus -s -l / as sysdba @ 10000.txt > /dev/null #seq 1500 | xargs -I {} -P 150 taskset 000010 sqlplus -s -l / as sysdba @ 10000.txt > /dev/null #seq 1500 | xargs -I {} -P 150 taskset 000ff0 sqlplus -s -l / as sysdba @ 10000.txt > /dev/null wait $ uniq -c 10000.txt 1 set feedback off 1 set term off 1 oradebug setmypid 10000 @ shared_latch_new.txt 1 set term on 1 set feedback on 2.测试: --//当前执行的是 seq 1500 | xargs -I {} -P 150 sqlplus -s -l / as sysdba @ 10000.txt > /dev/null $ vmstat 1 100 -w | ts.awk [2021-02-18 16:29:46] procs -------------------memory------------------ ---swap-- -----io---- --system-- -----cpu------- [2021-02-18 16:29:46] r b swpd free buff cache si so bi bo in cs us sy id wa st [2021-02-18 16:29:46] 10 1 0 117996440 444484 9817376 0 0 0 6 1 1 0 0 100 0 0 [2021-02-18 16:29:47] 7 0 0 117987720 444488 9821364 0 0 0 0 47339 71753 29 14 57 0 0 [2021-02-18 16:29:48] 15 0 0 117984864 444500 9824152 0 0 0 7352 48265 67567 30 14 56 0 0 [2021-02-18 16:29:49] 13 0 0 117981272 445008 9827464 0 0 0 128 51145 81676 29 13 57 0 0 [2021-02-18 16:29:50] 19 0 0 117977808 445008 9830736 0 0 0 0 49596 74999 30 14 56 0 0 [2021-02-18 16:29:51] 10 0 0 117974144 445008 9834216 0 0 0 4 49030 76347 30 14 56 0 0 [2021-02-18 16:29:52] 6 0 0 117970928 445008 9837668 0 0 0 15800 49340 74265 29 14 57 0 0 [2021-02-18 16:29:53] 2 0 0 117967840 445012 9840528 0 0 0 5300 50850 73700 30 15 54 0 0 [2021-02-18 16:29:54] 12 0 0 117963536 445012 9843716 0 0 0 60 48143 70862 30 15 55 0 0 [2021-02-18 16:29:55] 6 0 0 117961568 445012 9846800 0 0 0 0 49128 74693 30 13 57 0 0 ^C --//同时可以运行的进程很少. 3.测试: --//当前执行的是 seq 1500 | xargs -I {} -P 150 taskset 000010 sqlplus -s -l / as sysdba @ 10000.txt > /dev/null --//相当于仅仅使用1个cpu. $ vmstat 1 100 -w | ts.awk [2021-02-18 16:32:04] procs -------------------memory------------------ ---swap-- -----io---- --system-- -----cpu------- [2021-02-18 16:32:04] r b swpd free buff cache si so bi bo in cs us sy id wa st [2021-02-18 16:32:04] 1 0 0 118909432 445092 9984592 0 0 0 6 1 1 0 0 100 0 0 [2021-02-18 16:32:05] 0 0 0 118907400 445092 9984592 0 0 0 0 1244 2123 0 0 100 0 0 [2021-02-18 16:32:06] 1 0 0 118904792 445092 9984592 0 0 0 0 6132 8665 1 2 97 0 0 [2021-02-18 16:32:07] 152 87 0 118555368 445096 9984652 0 0 0 4 7929 10653 2 4 93 1 0 [2021-02-18 16:32:08] 72 0 0 118288712 445096 9984652 0 0 0 0 3129 2703 4 3 94 0 0 [2021-02-18 16:32:09] 140 0 0 118114048 445096 9984660 0 0 0 0 2645 2854 2 1 97 0 0 [2021-02-18 16:32:10] 154 0 0 118034048 445096 9984660 0 0 0 0 2726 2587 5 1 95 0 0 [2021-02-18 16:32:11] 150 0 0 117923296 445096 9984676 0 0 0 0 2877 3547 5 1 94 0 0 [2021-02-18 16:32:12] 151 0 0 117839456 445128 9985820 0 0 0 116 6463 13200 3 1 96 0 0 [2021-02-18 16:32:13] 150 0 0 117827832 445136 9986712 0 0 0 2240 9788 22660 3 1 96 0 0 [2021-02-18 16:32:14] 151 0 0 117825520 445136 9987592 0 0 0 8 10425 23113 4 2 94 0 0 [2021-02-18 16:32:15] 150 0 0 117824512 445136 9988248 0 0 0 0 10397 23200 5 2 92 0 0 [2021-02-18 16:32:16] 150 0 0 117824488 445136 9989064 0 0 0 4 10604 23294 3 1 95 0 0 [2021-02-18 16:32:17] 150 0 0 117823272 445136 9989960 0 0 0 108 10420 23307 3 1 96 0 0 [2021-02-18 16:32:18] 150 0 0 117822552 445140 9990660 0 0 0 5824 10887 23355 4 2 94 0 0 [2021-02-18 16:32:19] 151 0 0 117821792 445140 9991432 0 0 0 1448 10591 23299 4 2 94 0 0 [2021-02-18 16:32:20] 152 0 0 117821312 445304 9992276 0 0 0 44 10283 23321 4 2 94 0 0 ^C --//可以发现可以并行150个进程. top - 16:33:44 up 7 days, 23:09, 2 users, load average: 59.97, 23.93, 16.48 Tasks: 537 total, 150 running, 386 sleeping, 0 stopped, 0 zombie Cpu0 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu1 : 0.0%us, 0.3%sy, 0.0%ni, 99.7%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu2 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu3 : 0.0%us, 0.0%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu4 : 74.3%us, 25.7%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~仅仅1个cpu很忙. Cpu5 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu6 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu7 : 5.6%us, 7.3%sy, 0.0%ni, 87.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu8 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu9 : 0.0%us, 0.0%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu10 : 0.0%us, 0.0%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu11 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu12 : 0.7%us, 0.0%sy, 0.0%ni, 99.3%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu13 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu14 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu15 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu16 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu17 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu18 : 0.0%us, 0.0%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu19 : 4.7%us, 10.0%sy, 0.0%ni, 85.4%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu20 : 0.0%us, 0.3%sy, 0.0%ni, 99.7%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu21 : 0.3%us, 0.7%sy, 0.0%ni, 99.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu22 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu23 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Mem: 132261196k total, 14467816k used, 117793380k free, 445944k buffers Swap: 31455264k total, 0k used, 31455264k free, 10019668k cached 3.测试: --//当前执行的是 seq 1500 | xargs -I {} -P 150 taskset 000ff0 sqlplus -s -l / as sysdba @ 10000.txt > /dev/null $ vmstat 1 100 -w | ts.awk [2021-02-18 16:39:40] procs -------------------memory------------------ ---swap-- -----io---- --system-- -----cpu------- [2021-02-18 16:39:40] r b swpd free buff cache si so bi bo in cs us sy id wa st [2021-02-18 16:39:40] 50 0 0 117100384 450244 10661900 0 0 0 1092 65601 132577 26 14 60 0 0 [2021-02-18 16:39:41] 25 0 0 117085856 450244 10667672 0 0 0 3088 65087 131536 22 12 67 0 0 [2021-02-18 16:39:42] 80 0 0 117093952 450244 10673436 0 0 0 6300 63522 129667 20 11 70 0 0 [2021-02-18 16:39:43] 70 0 0 117066304 450244 10679244 0 0 0 6620 64842 130079 24 13 63 0 0 [2021-02-18 16:39:44] 33 0 0 117054176 450252 10685552 0 0 0 15120 66144 130615 23 12 65 0 0 [2021-02-18 16:39:45] 28 0 0 117086032 450252 10690556 0 0 0 672 64026 128290 23 12 65 0 0 [2021-02-18 16:39:46] 23 0 0 117047936 450252 10697524 0 0 0 2748 67426 135191 23 13 64 0 0 [2021-02-18 16:39:47] 16 0 0 117047800 450252 10703340 0 0 0 4364 65730 131386 23 13 64 0 0 [2021-02-18 16:39:48] 18 0 0 117058352 450252 10708476 0 0 0 7776 63156 127241 27 14 60 0 0 [2021-02-18 16:39:49] 64 0 0 117040384 450252 10714688 0 0 0 16492 66459 130785 22 12 66 0 0 [2021-02-18 16:39:50] 25 0 0 117031312 450252 10720520 0 0 0 796 63195 130624 21 11 67 0 0 [2021-02-18 16:39:51] 55 0 0 117016536 450252 10726868 0 0 0 1632 64217 129030 26 14 60 0 0 [2021-02-18 16:39:52] 46 0 0 117033040 450252 10730824 0 0 0 3764 64339 128065 25 13 62 0 0 top - 16:40:43 up 7 days, 23:16, 2 users, load average: 101.01, 55.58, 32.68 Tasks: 537 total, 155 running, 381 sleeping, 0 stopped, 0 zombie Cpu0 : 0.0%us, 0.3%sy, 0.0%ni, 99.7%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu1 : 24.3%us, 69.4%sy, 0.0%ni, 6.3%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu2 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu3 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu4 : 69.2%us, 30.8%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu5 : 68.5%us, 31.5%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu6 : 69.2%us, 30.8%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu7 : 70.4%us, 29.6%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu8 : 68.9%us, 31.1%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu9 : 71.9%us, 28.1%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu10 : 69.5%us, 30.5%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu11 : 69.4%us, 30.6%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu12 : 0.3%us, 0.3%sy, 0.0%ni, 97.7%id, 1.7%wa, 0.0%hi, 0.0%si, 0.0%st Cpu13 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu14 : 0.3%us, 0.3%sy, 0.0%ni, 99.3%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu15 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu16 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu17 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu18 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu19 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu20 : 0.0%us, 0.3%sy, 0.0%ni, 99.7%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu21 : 38.4%us, 15.8%sy, 0.0%ni, 45.8%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu22 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu23 : 0.0%us, 0.3%sy, 0.0%ni, 99.7%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Mem: 132261196k total, 15700152k used, 116561044k free, 452408k buffers Swap: 31455264k total, 0k used, 31455264k free, 11230608k cached --//仅仅cpu4-cpu11 很忙. --//也就是cpu越少,反而不容易出现阻塞. 4.我写一个脚本验证这个测试: $ uniq -c 10000.txt 1 set feedback off 1 set term off 1 oradebug setmypid 1000 @ shared_latch_new.txt 1 set term on 1 set feedback on --//每次调用1000次. $ cat i7.sh #! /bin/bash for i in $(echo f ff fff ffff fffff ffffff) do echo $(date +"%Y/%m/%d %T") $i echo $(date +"%Y/%m/%d %T") $i start >> /tmp/vmstat.txt seq 150 | xargs -I {} -P 150 taskset $i sqlplus -s -l / as sysdba @ 10000.txt > /dev/null & wait echo $(date +"%Y/%m/%d %T") $i end >> /tmp/vmstat.txt done $ . i7.sh 2021/02/18 17:18:11 f [1]+ Done seq 150 | xargs -I {} -P 150 taskset $i sqlplus -s -l / as sysdba @ 10000.txt > /dev/null 2021/02/18 17:18:26 ff [1]+ Done seq 150 | xargs -I {} -P 150 taskset $i sqlplus -s -l / as sysdba @ 10000.txt > /dev/null 2021/02/18 17:18:38 fff [1]+ Done seq 150 | xargs -I {} -P 150 taskset $i sqlplus -s -l / as sysdba @ 10000.txt > /dev/null 2021/02/18 17:18:49 ffff [1]+ Done seq 150 | xargs -I {} -P 150 taskset $i sqlplus -s -l / as sysdba @ 10000.txt > /dev/null 2021/02/18 17:19:00 fffff [1]+ Done seq 150 | xargs -I {} -P 150 taskset $i sqlplus -s -l / as sysdba @ 10000.txt > /dev/null 2021/02/18 17:19:09 ffffff [1]+ Done seq 150 | xargs -I {} -P 150 taskset $i sqlplus -s -l / as sysdba @ 10000.txt > /dev/null $ cat /tmp/vmstat.txt 2021/02/18 17:18:11 f start 2021/02/18 17:18:26 f end 2021/02/18 17:18:26 ff start 2021/02/18 17:18:38 ff end 2021/02/18 17:18:38 fff start 2021/02/18 17:18:49 fff end 2021/02/18 17:18:49 ffff start 2021/02/18 17:19:00 ffff end 2021/02/18 17:19:00 fffff start 2021/02/18 17:19:09 fffff end 2021/02/18 17:19:09 ffffff start 2021/02/18 17:19:31 ffffff end --//对比时间的使用 15 12 11 11 9 22. $ vmstat 1 -w | ts.awk [2021-02-18 17:18:16] procs -------------------memory------------------ ---swap-- -----io---- --system-- -----cpu------- [2021-02-18 17:18:16] r b swpd free buff cache si so bi bo in cs us sy id wa st [2021-02-18 17:18:16] 152 0 0 115160432 476064 12777052 0 0 0 6 2 0 0 0 100 0 0 [2021-02-18 17:18:17] 153 16 0 115154608 476064 12780736 0 0 0 19512 29285 71906 19 9 72 0 0 [2021-02-18 17:18:18] 152 0 0 115156432 476064 12784956 0 0 0 1924 27152 82862 10 5 84 1 0 [2021-02-18 17:18:19] 150 0 0 115158176 476064 12789884 0 0 0 8964 29669 93027 19 11 70 0 0 [2021-02-18 17:18:20] 151 0 0 115159872 476064 12795252 0 0 0 0 29477 94425 17 10 73 0 0 [2021-02-18 17:18:21] 151 0 0 115154704 476068 12800516 0 0 4 4 29590 94940 16 9 76 0 0 [2021-02-18 17:18:22] 150 1 0 115156840 476072 12805768 0 0 0 19508 32860 94421 8 5 87 0 0 [2021-02-18 17:18:23] 151 1 0 115151632 476072 12811012 0 0 0 1140 29925 94838 20 12 68 0 0 [2021-02-18 17:18:24] 149 0 0 115145928 476072 12816272 0 0 0 492 29438 94682 18 11 71 0 0 [2021-02-18 17:18:25] 116 0 0 115366384 476072 12821548 0 0 0 14660 30577 94128 13 8 78 0 0 [2021-02-18 17:18:26] 106 0 0 115444792 476072 12826740 0 0 0 0 30212 94753 9 5 86 0 0 --//2021/02/18 17:18:26 ff [2021-02-18 17:18:27] 111 0 0 115371016 476076 12829356 0 0 0 12328 24384 59374 15 9 76 0 0 [2021-02-18 17:18:28] 153 0 0 115092080 476264 12836416 0 0 0 0 31334 97332 36 16 48 0 0 [2021-02-18 17:18:29] 52 0 0 115054896 476616 12845284 0 0 0 0 41397 132358 32 18 49 0 0 [2021-02-18 17:18:30] 55 0 0 115046176 476676 12849828 0 0 0 0 71779 147299 15 8 77 0 0 [2021-02-18 17:18:31] 40 0 0 115030408 476676 12855864 0 0 0 0 67145 138426 31 16 53 0 0 [2021-02-18 17:18:32] 13 0 0 115048480 476676 12861952 0 0 0 35204 75531 137604 28 15 57 0 0 [2021-02-18 17:18:33] 80 0 0 115017784 476676 12869224 0 0 0 5140 68900 140421 27 15 57 0 0 [2021-02-18 17:18:34] 156 0 0 115024320 476676 12874652 0 0 0 4040 68950 139530 14 7 79 0 0 [2021-02-18 17:18:35] 53 0 0 115019440 476676 12880112 0 0 0 0 67368 137458 27 15 58 0 0 [2021-02-18 17:18:36] 20 0 0 115106832 476676 12884960 0 0 0 0 64894 132769 29 15 56 0 0 [2021-02-18 17:18:37] procs -------------------memory------------------ ---swap-- -----io---- --system-- -----cpu------- [2021-02-18 17:18:37] r b swpd free buff cache si so bi bo in cs us sy id wa st [2021-02-18 17:18:37] 31 0 0 115263216 476676 12893028 0 0 0 25608 69197 133270 19 10 71 0 0 [2021-02-18 17:18:38] 6 0 0 115784624 476676 12896056 0 0 0 1268 46086 125169 16 9 75 0 0 --//2021/02/18 17:18:38 fff [2021-02-18 17:18:39] 160 0 0 115017584 476724 12900152 0 0 0 2812 31212 74067 27 16 57 0 0 [2021-02-18 17:18:40] 12 0 0 114965616 477264 12906568 0 0 0 2856 65399 150903 31 16 52 0 0 [2021-02-18 17:18:41] 22 0 0 114980016 477276 12912904 0 0 0 0 74304 138162 35 17 48 0 0 [2021-02-18 17:18:42] 21 0 0 114966080 477276 12918892 0 0 0 25064 80923 138320 25 13 62 0 0 [2021-02-18 17:18:43] 33 0 0 114963472 477276 12925320 0 0 0 1716 72813 134170 32 16 52 0 0 [2021-02-18 17:18:44] 50 0 0 114943512 477280 12931284 0 0 4 16 66971 129147 32 16 52 0 0 [2021-02-18 17:18:45] 45 0 0 114931312 477280 12937308 0 0 0 17872 75098 141312 32 17 52 0 0 [2021-02-18 17:18:46] 21 0 0 114910944 477280 12944172 0 0 0 0 78162 146946 25 12 63 0 0 [2021-02-18 17:18:47] 15 0 0 114917960 477284 12950012 0 0 0 16420 78880 140456 35 18 47 0 0 [2021-02-18 17:18:48] 19 0 0 114966976 477284 12955932 0 0 0 0 78006 146161 30 15 54 0 0 [2021-02-18 17:18:49] 17 0 0 115098928 477284 12962196 0 0 0 4 77372 144729 36 18 46 0 0 --//2021/02/18 17:18:49 ffff [2021-02-18 17:18:50] 69 0 0 115115968 477284 12968652 0 0 0 7400 52667 93854 23 15 61 0 0 [2021-02-18 17:18:51] 18 0 0 114899512 477572 12975096 0 0 0 10860 68980 152766 45 20 35 0 0 [2021-02-18 17:18:52] 61 0 0 114898640 477884 12981544 0 0 0 17592 88366 147340 35 19 46 0 0 [2021-02-18 17:18:53] 36 0 0 114863456 477884 12988184 0 0 0 1732 88713 159689 42 21 37 0 0 [2021-02-18 17:18:54] 21 0 0 114863216 477884 12994880 0 0 0 0 87517 152858 35 18 47 0 0 [2021-02-18 17:18:55] 20 0 0 114867912 477884 13001308 0 0 0 0 81894 139759 34 17 49 0 0 [2021-02-18 17:18:56] 18 0 0 114853328 477884 13006956 0 0 0 23968 95996 167008 40 20 41 0 0 [2021-02-18 17:18:57] 31 0 0 114840144 477892 13013812 0 0 0 11872 98914 171766 37 19 44 0 0 [2021-02-18 17:18:58] procs -------------------memory------------------ ---swap-- -----io---- --system-- -----cpu------- [2021-02-18 17:18:58] r b swpd free buff cache si so bi bo in cs us sy id wa st [2021-02-18 17:18:58] 32 0 0 114865760 477892 13020796 0 0 0 0 93650 162668 35 18 48 0 0 [2021-02-18 17:18:59] 15 0 0 114992608 477892 13027764 0 0 0 0 97630 170433 38 19 42 0 0 [2021-02-18 17:19:00] 42 0 0 115439312 477892 13034776 0 0 0 0 99683 175878 34 19 47 0 0 --//2021/02/18 17:19:00 fffff [2021-02-18 17:19:01] 12 0 0 114826512 478020 13040960 0 0 0 11228 50480 106596 50 28 22 0 0 [2021-02-18 17:19:02] 10 0 0 114861728 478432 13047484 0 0 0 26184 60626 110361 34 17 49 0 0 [2021-02-18 17:19:03] 17 0 0 114812496 478500 13055640 0 0 4 1756 94322 181834 46 24 30 0 0 [2021-02-18 17:19:04] 20 0 0 114789056 478500 13063376 0 0 0 0 96273 170292 45 23 31 0 0 [2021-02-18 17:19:05] 31 0 0 114796064 478500 13070484 0 0 0 24 87625 166862 45 24 31 0 0 [2021-02-18 17:19:06] 43 0 0 114799648 478500 13080960 0 0 0 9532 124094 228081 48 25 27 0 0 [2021-02-18 17:19:07] 2 0 0 114792088 478504 13089356 0 0 0 37012 102798 190146 43 23 33 0 0 [2021-02-18 17:19:08] 10 0 0 114832432 478504 13095184 0 0 0 0 44813 70821 29 14 57 0 0 [2021-02-18 17:19:09] 3 0 0 115041600 478504 13101888 0 0 0 0 88648 170832 45 25 30 0 0 --//2021/02/18 17:19:09 ffffff [2021-02-18 17:19:10] 53 0 0 114894992 478576 13108736 0 0 0 4 66620 112797 44 27 28 0 0 [2021-02-18 17:19:11] 22 0 0 114801360 478580 13112924 0 0 0 3740 45510 69099 33 14 53 0 0 [2021-02-18 17:19:12] 10 0 0 114798752 478600 13115836 0 0 0 23576 47963 66569 29 15 56 0 0 [2021-02-18 17:19:13] 15 0 0 114795040 479108 13119128 0 0 0 1684 51925 87050 28 13 58 0 0 [2021-02-18 17:19:14] 16 0 0 114792096 479108 13122148 0 0 0 0 44772 65294 28 14 58 0 0 [2021-02-18 17:19:15] 12 0 0 114777744 479108 13125444 0 0 0 4 52961 79502 33 16 50 0 0 [2021-02-18 17:19:16] 13 0 0 114774016 479108 13129460 0 0 0 14348 52749 80442 30 14 56 0 0 [2021-02-18 17:19:17] 16 0 0 114771872 479112 13132848 0 0 0 6264 49452 76519 28 13 58 0 0 [2021-02-18 17:19:18] 17 0 0 114768544 479112 13135908 0 0 0 0 51183 74748 33 16 51 0 0 [2021-02-18 17:19:19] procs -------------------memory------------------ ---swap-- -----io---- --system-- -----cpu------- [2021-02-18 17:19:19] r b swpd free buff cache si so bi bo in cs us sy id wa st [2021-02-18 17:19:19] 15 0 0 114765576 479112 13139256 0 0 0 0 46801 67442 30 15 55 0 0 [2021-02-18 17:19:20] 12 0 0 114762696 479112 13142224 0 0 0 0 46440 74744 31 14 55 0 0 [2021-02-18 17:19:21] 11 0 0 114758520 479112 13145652 0 0 0 7980 51548 75048 31 15 54 0 0 [2021-02-18 17:19:22] 6 0 0 114755560 479116 13148900 0 0 0 11784 47678 70701 29 14 57 0 0 [2021-02-18 17:19:23] 19 0 0 114751968 479116 13151928 0 0 0 8 51040 74021 32 16 52 0 0 [2021-02-18 17:19:24] 14 0 0 114748616 479116 13155764 0 0 0 0 50111 79146 36 17 48 0 0 [2021-02-18 17:19:25] 23 0 0 114733912 479116 13158980 0 0 0 0 49413 77867 26 13 61 0 0 [2021-02-18 17:19:26] 10 0 0 114730480 479116 13162200 0 0 0 7604 47791 72064 30 14 56 0 0 [2021-02-18 17:19:27] 12 0 0 114728128 479116 13165300 0 0 0 12344 46983 73314 27 13 60 0 0 [2021-02-18 17:19:28] 4 0 0 114759136 479116 13168832 0 0 0 604 46051 67062 30 15 55 0 0 [2021-02-18 17:19:29] 14 0 0 114841648 479116 13171728 0 0 0 0 49168 70778 31 16 53 0 0 [2021-02-18 17:19:30] 15 0 0 114862848 479116 13175000 0 0 0 0 48840 75523 29 13 58 0 0 [2021-02-18 17:19:31] 15 0 0 115156352 479116 13177888 0 0 0 4804 46598 66393 30 15 55 0 0 [2021-02-18 17:19:32] 0 0 0 115779648 479116 13178760 0 0 0 6276 9809 13794 12 9 79 0 0 [2021-02-18 17:19:33] 0 0 0 115782888 479120 13179764 0 0 0 5432 1633 2060 0 0 100 0 0 5.总结: --//实际上仔细看文档,就可以理解: Procs r: The number of processes waiting for run time. b: The number of processes in uninterruptible sleep. Procs r:等待运行时间的进程数。 b:不间断睡眠中的进程数。
[20210218]shared latch spin count 6.txt
来源:这里教程网
时间:2026-03-03 16:27:20
作者:
编辑推荐:
下一篇:
相关推荐
-
雷神推出 MIX PRO II 迷你主机:基于 Ultra 200H,玻璃上盖 + ARGB 灯效
2 月 9 日消息,雷神 (THUNDEROBOT) 现已宣布推出基于英
-
制造商 Musnap 推出彩色墨水屏电纸书 Ocean C:支持手写笔、第三方安卓应用
2 月 10 日消息,制造商 Musnap 现已在海外推出一款 Oce
热文推荐
- Oracle执行语句跟踪 使用sql trace实现语句追踪
Oracle执行语句跟踪 使用sql trace实现语句追踪
26-03-03 - 主库删除PDB后,对应PDB服务还在备库上
主库删除PDB后,对应PDB服务还在备库上
26-03-03 - IM列存储参数、视图与相关操作
IM列存储参数、视图与相关操作
26-03-03 - Oracle 19c数据库体系结构-1
Oracle 19c数据库体系结构-1
26-03-03 - Oracle 账号 EXPIRED(GRACE) 意义-拾亿
Oracle 账号 EXPIRED(GRACE) 意义-拾亿
26-03-03 - 主备数据库状态手工比对(一)
主备数据库状态手工比对(一)
26-03-03 - 多表连接的三种方式详解 hash join、merge join、 nested loop
- Oracle 12c SCN推进方法汇总(四)之修改控制文件
Oracle 12c SCN推进方法汇总(四)之修改控制文件
26-03-03 - 从Oracle数据库故障到AIX内存管理
从Oracle数据库故障到AIX内存管理
26-03-03 - 苏宁有货:为“轻创业”而来
苏宁有货:为“轻创业”而来
26-03-03
