[20210218]shared latch spin count 6.txt
[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:不間斷睡眠中的程式數。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/267265/viewspace-2757587/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- [20210218]shared latch spin count 5.txt
- [20190419]shared latch spin count.txt
- [20190419]shared latch spin count 2.txt
- [20190418]exclusive latch spin count.txt
- Latch的spin及sleep(zt)
- [20190417]隱含引數_SPIN_COUNT.txt
- [20210512]shared pool latch與library cache latch的簡單探究.txt
- [20190319]shared pool latch與library cache latch的簡單探究.txt
- [20190401]隱含引數_mutex_spin_count.txtMutex
- [20210708]使用那個shared pool latch.txt
- [20190415]關於shared latch(共享栓鎖).txt
- [20210803]使用那個shared pool latch(補充).txt
- [20190416]檢視shared latch gets的變化.txt
- [20210208][20200426]檢視shared latch gets的變化.txt
- [20190416]完善shared latch測試指令碼2.txt指令碼
- [20201117]使用DBMS_SHARED_POOL.MARKHOT與sql語句6.txtSQL
- [20220406]使用那個shared pool latch的疑問1.txt
- [20220412]shared pool latch與使用sga heap的疑問2.txt
- [20220413]shared pool latch與使用sga heap的疑問3.txt
- 透過案例學調優之--和 SHARED POOL 相關的主要 Latch
- [20210520]11g shared pool latch與library cache mutex的簡單探究.txtMutex
- [20210521]11g shared pool latch與library cache mutex的簡單探究4.txtMutex
- [20210520]11g shared pool latch與library cache mutex的簡單探究3.txtMutex
- MySQL的COUNT語句--count(*)、 count(常量)、 count(列名)MySql
- 【轉】spin lock 和mutexMutex
- count(*)、count(1)和count(列名)的區別
- count (*) 和 count (1) 和 count (列名) 區別
- count(*) 和 count(1)和count(列名)區別
- №20210218賽事~中獎名單
- mutex,latch,lock,enqueue hash chains latch基礎概念MutexENQAI
- [20210218]xargs 與here doc測試.txt
- [20210218]bash echo 建立順序號.txt
- 圖解MySQL:count(*) 、count(1) 、count(主鍵欄位)、count(欄位)哪個效能最好?圖解MySql
- MFC NumericUpDown Spin控制元件 CSpinButtonCtrl控制元件
- [20210915]探究mutex的值 6.txtMutex
- [20200408]優化的困惑6.txt優化
- [20180727]再論count(*)和count(1).txt
- hiccup和Latch off