[20210209]修改CPU_COUNT引數.txt
[20210209]修改CPU_COUNT引數.txt
--//昨天的測試:
http://blog.itpub.net/267265/viewspace-2756963/=>[20210208][20200426]檢視shared latch gets的變化.txt
表4-3
-------------------------------------------------------------------------
需要的栓鎖訪問 使用方法
-------------------------------------------------------------------------
以共享模式獲取其他程式以共享模式持有的共享栓鎖 休眠前僅自旋cou_count+2次.
--------------------------------------------------------------------------
--//我想是否可以透過減少CPU_COUNT引數,使得測試容易實現.另外我發現我使用前面的指令碼測試,要看到進入sleep非常困難.
--//我必須限制CPU資源的使用.看了APress Oracle Core Essential Internals for DBAs and Developers.pdf
--//P105:
■ Note If you want to see how memory allocations change with the number of CPUs, you can adjust parameter
cpu_count and restart the instance; however, in 11.2 you also need to set parameter _disable_cpu_check to
false.
--//測試看看:
1.環境:
SCOTT@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
create pfile='/tmp/@.ora' from spfile ;
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
--//預設就是false.
--//修改/tmp/book.ora檔案,加入:
*.cpu_count=4
#*._disable_cpu_check=true
2.測試:
$ seq 10 | xargs -IQ -P 10 bash -c "sqlplus -s -l / as sysdba <<< 'select count(*) from dba_objects ,dba_objects;'"
$ vmstat -w 1 10
procs -------------------memory------------------ ---swap-- -----io---- --system-- -----cpu-------
r b swpd free buff cache si so bi bo in cs us sy id wa st
10 0 0 80726608 1078864 45983936 0 0 0 0 0 0 1 0 98 0 0
10 0 0 80726480 1078864 45983936 0 0 0 160 11914 2135 32 0 68 0 0
10 0 0 80726672 1078864 45983936 0 0 0 0 11848 2078 57 0 43 0 0
10 0 0 80716112 1078864 45983936 0 0 0 0 11692 2175 40 0 60 0 0
10 0 0 80716016 1078864 45983936 0 0 0 0 11114 2082 50 0 50 0 0
11 0 0 80716880 1078864 45983944 0 0 0 4 11106 2131 30 0 70 0 0
10 0 0 80717008 1078864 45983944 0 0 0 68 11123 2108 53 0 47 0 0
11 0 0 80717504 1078864 45983944 0 0 0 0 11111 2074 52 0 47 0 0
10 0 0 80718000 1078864 45983944 0 0 0 0 11070 2083 43 0 57 0 0
12 0 0 80718424 1078864 45983944 0 0 0 4 11137 2153 29 0 71 0 0
--//可以發現無用,我的本意限制使用4個cpu.而實際上按照前面的介紹how memory allocations change with the number of CPUs.
--//如何實現呢?
3.想起連結http://blog.itpub.net/267265/viewspace-2664551/ => [20191118]確定linux伺服器cpu數量.txt
# seq 4 23 | xargs -IQ bash -c "echo 0 >| /sys/devices/system/cpu/cpuQ/online "
SYS@book> startup
ORACLE instance started.
Total System Global Area 643084288 bytes
Fixed Size 2255872 bytes
Variable Size 205521920 bytes
Database Buffers 427819008 bytes
Redo Buffers 7487488 bytes
Database mounted.
Database opened.
--//注我並沒有使用pfile引數檔案啟動資料庫.
SYS@book> show parameter cpu_count
NAME TYPE VALUE
--------- -------- -----
cpu_count integer 4
$ seq 10 | xargs -IQ -P 10 bash -c "sqlplus -s -l / as sysdba <<< 'select count(*) from dba_objects ,dba_objects;'"
$ ps -ef | grep -E "LOCAL=YE[S]|^UID"
UID PID PPID C STIME TTY TIME CMD
oracle 39185 34030 0 09:01 ? 00:00:00 oraclebook (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 39234 39230 37 09:02 ? 00:00:43 oraclebook (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 39235 39224 36 09:02 ? 00:00:43 oraclebook (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 39236 39232 39 09:02 ? 00:00:46 oraclebook (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 39237 39233 37 09:02 ? 00:00:44 oraclebook (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 39238 39228 41 09:02 ? 00:00:49 oraclebook (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 39239 39227 49 09:02 ? 00:00:58 oraclebook (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 39240 39226 37 09:02 ? 00:00:43 oraclebook (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 39241 39225 45 09:02 ? 00:00:54 oraclebook (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 39242 39229 37 09:02 ? 00:00:43 oraclebook (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 39243 39231 36 09:02 ? 00:00:43 oraclebook (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
--//注意C列,每個cpu使用率沒有100%.說明僅僅4個CPU在工作.
# seq 4 23 | xargs -IQ bash -c "echo 1 >| /sys/devices/system/cpu/cpuQ/online "
$ seq 10 | xargs -IQ -P 10 bash -c "sqlplus -s -l / as sysdba <<< 'select count(*) from dba_objects ,dba_objects;'"
$ ps -ef | grep -E "LOCAL=YE[S]|^UID"
UID PID PPID C STIME TTY TIME CMD
oracle 39185 34030 0 09:01 ? 00:00:00 oraclebook (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 41135 41133 99 09:06 ? 00:00:30 oraclebook (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 41136 41132 99 09:06 ? 00:00:30 oraclebook (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 41137 41128 99 09:06 ? 00:00:30 oraclebook (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 41138 41125 99 09:06 ? 00:00:30 oraclebook (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 41139 41126 99 09:06 ? 00:00:30 oraclebook (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 41140 41134 99 09:06 ? 00:00:30 oraclebook (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 41141 41130 99 09:06 ? 00:00:30 oraclebook (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 41142 41127 99 09:06 ? 00:00:30 oraclebook (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 41143 41131 99 09:06 ? 00:00:30 oraclebook (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 41144 41129 99 09:06 ? 00:00:30 oraclebook (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
--//可以發現一旦開啟還是不行.另外我還測試了在執行sql過程中關閉的情況,也是不行.
# seq 4 23 | xargs -IQ bash -c "echo 0 >| /sys/devices/system/cpu/cpuQ/online "
$ ps -ef | grep -E "LOCAL=YE[S]|^UID"
UID PID PPID C STIME TTY TIME CMD
oracle 39185 34030 0 09:01 ? 00:00:00 oraclebook (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 41135 41133 91 09:06 ? 00:01:58 oraclebook (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 41136 41132 91 09:06 ? 00:01:58 oraclebook (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 41137 41128 92 09:06 ? 00:01:58 oraclebook (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 41138 41125 93 09:06 ? 00:02:00 oraclebook (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 41139 41126 92 09:06 ? 00:01:59 oraclebook (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 41140 41134 91 09:06 ? 00:01:58 oraclebook (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 41141 41130 91 09:06 ? 00:01:58 oraclebook (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 41142 41127 93 09:06 ? 00:02:00 oraclebook (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 41143 41131 91 09:06 ? 00:01:58 oraclebook (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 41144 41129 91 09:06 ? 00:01:58 oraclebook (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
--//這個時候CPU資源不能都重新分配.
4.還有什麼好方法限制CPU資源的使用呢?也許oracle內部的資源管理可以選擇,不過我不想這麼做.
--//可以透過taskset限制cpu的使用.
# ps -ef | grep tn[s]ls
oracle 58334 1 0 Jan28 ? 00:00:26 /u01/app/oracle/product/11.2.0.4/dbhome_1/bin/tnslsnr LISTENER -inherit
# taskset -pc 0,1,2,3 58334
pid 58334's current affinity list: 0-23
pid 58334's new affinity list: 0-3
# taskset -p 58334
pid 58334's current affinity mask: f
--//這樣做的確定就是必須透過網路連線限制CPU的使用,因為連線的程式是透過監聽程式派生出來的,繼承監聽程式的屬性.
$ seq 10 | xargs -IQ -P 10 bash -c "sqlplus -s -l sys/oracle@book as sysdba <<< 'select count(*) from dba_objects ,dba_objects;'"
--//連線串必須指定sys/oracle@book.
$ ps -ef | grep -E "LOCAL=N[O]|^UID"
UID PID PPID C STIME TTY TIME CMD
oracle 44608 1 33 09:23 ? 00:00:05 oraclebook (LOCAL=NO)
oracle 44610 1 49 09:23 ? 00:00:08 oraclebook (LOCAL=NO)
oracle 44612 1 49 09:23 ? 00:00:08 oraclebook (LOCAL=NO)
oracle 44614 1 49 09:23 ? 00:00:08 oraclebook (LOCAL=NO)
oracle 44616 1 49 09:23 ? 00:00:08 oraclebook (LOCAL=NO)
oracle 44618 1 33 09:23 ? 00:00:05 oraclebook (LOCAL=NO)
oracle 44620 1 33 09:23 ? 00:00:05 oraclebook (LOCAL=NO)
oracle 44622 1 32 09:23 ? 00:00:05 oraclebook (LOCAL=NO)
oracle 44624 1 33 09:23 ? 00:00:05 oraclebook (LOCAL=NO)
oracle 44626 1 33 09:23 ? 00:00:05 oraclebook (LOCAL=NO)
--//OK,這樣可以限制CPU的使用.
top - 09:26:08 up 413 days, 17:09, 2 users, load average: 9.63, 6.97, 4.62
Tasks: 264 total, 11 running, 253 sleeping, 0 stopped, 0 zombie
Cpu0 :100.0%us, 0.0%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu1 :100.0%us, 0.0%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu2 :100.0%us, 0.0%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu3 :100.0%us, 0.0%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu4 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
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 : 0.0%us, 0.0%sy, 0.0%ni,100.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,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu10 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu11 : 0.0%us, 0.0%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu12 : 0.0%us, 0.0%sy, 0.0%ni,100.0%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 : 0.0%us, 0.0%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu20 : 0.3%us, 0.3%sy, 0.0%ni, 99.3%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu21 : 0.0%us, 0.0%sy, 0.0%ni,100.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, 51518228k used, 80742968k free, 1078892k buffers
Swap: 31455264k total, 0k used, 31455264k free, 45984748k cached
--//CPU看到僅僅前4個CPU很忙.
--//這樣可以滿足我測試的目的.缺點就是透過網路連線.
--//收尾檢查與還原:
--//# seq 4 23 | xargs -IQ bash -c "echo 1 >| /sys/devices/system/cpu/cpuQ/online "
# seq 0 23 | xargs -I {} bash -c "echo -n cpu{}: ;cat /sys/devices/system/cpu/cpu{}/online"
--//輸出略.
# taskset -p 0xffffff 58334
pid 58334's current affinity mask: f
pid 58334's new affinity mask: ffffff
# taskset -p 58334
pid 58334's current affinity mask: ffffff
--//很奇怪的是執行如下不行!!
$ seq 10 | xargs -IQ -P 10 bash -c "taskset -c 0,1,2,3 sqlplus -s -l / as sysdba <<< 'select count(*) from dba_objects ,dba_objects;'"
$ seq 10 | xargs -IQ -P 10 bash -c "taskset -p 0x00000F sqlplus -s -l / as sysdba <<< 'select count(*) from dba_objects ,dba_objects;'"
--//看man文件也沒有找到如何執行.嘗試如下命令:
$ taskset -p 0x000001 sleep 1000
taskset (util-linux 2.13-pre7)
usage: taskset [options] [mask | cpu-list] [pid | cmd [args...]]
set or get the affinity of a process
-p, --pid operate on existing given pid
-c, --cpu-list display and specify cpus in list format
-h, --help display this help
-v, --version output version information
The default behavior is to run a new command:
taskset 03 sshd -b 1024
You can retrieve the mask of an existing task:
taskset -p 700
Or set it:
taskset -p 03 700
List format uses a comma-separated list instead of a mask:
taskset -pc 0,3,7-11 700
Ranges in list format can take a stride argument:
e.g. 0-31:2 is equivalent to mask 0x55555555
--//應該不用輸入0x.以及-p引數要跟上程式號.
$ seq 10 | xargs -IQ -P 10 bash -c "taskset 00000F sqlplus -s -l / as sysdba <<< 'select count(*) from dba_objects ,dba_objects;'"
$ ps -ef | grep -E "LOCAL=YE[S]|^UID"
UID PID PPID C STIME TTY TIME CMD
oracle 45810 45806 33 10:04 ? 00:00:06 oraclebook (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 45811 45801 50 10:04 ? 00:00:09 oraclebook (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 45812 45808 50 10:04 ? 00:00:09 oraclebook (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 45813 45800 33 10:04 ? 00:00:06 oraclebook (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 45814 45804 33 10:04 ? 00:00:06 oraclebook (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 45815 45805 50 10:04 ? 00:00:09 oraclebook (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 45816 45802 33 10:04 ? 00:00:06 oraclebook (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 45817 45803 33 10:04 ? 00:00:06 oraclebook (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 45818 45807 50 10:04 ? 00:00:09 oraclebook (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 45819 45809 33 10:04 ? 00:00:06 oraclebook (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
--// 這樣就簡單多了,不需要透過網路連線控制CPU資源的使用.
# top -u oracle
--//按1,展開cpu資源顯示.
top - 10:05:13 up 413 days, 17:49, 2 users, load average: 6.94, 5.01, 4.56
Tasks: 267 total, 11 running, 256 sleeping, 0 stopped, 0 zombie
top - 10:05:31 up 413 days, 17:49, 2 users, load average: 7.62, 5.26, 4.65
Tasks: 267 total, 11 running, 256 sleeping, 0 stopped, 0 zombie
Cpu0 :100.0%us, 0.0%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu1 :100.0%us, 0.0%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu2 :100.0%us, 0.0%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu3 :100.0%us, 0.0%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu4 : 0.0%us, 0.0%sy, 0.0%ni, 99.7%id, 0.3%wa, 0.0%hi, 0.0%si, 0.0%st
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 : 0.0%us, 0.0%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu8 : 0.3%us, 0.0%sy, 0.0%ni, 99.7%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,100.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.0%us, 0.0%sy, 0.0%ni,100.0%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,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.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu21 : 0.0%us, 0.3%sy, 0.0%ni, 99.7%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, 51541128k used, 80720068k free, 1078892k buffers
Swap: 31455264k total, 0k used, 31455264k free, 45985552k cached
5.總結:
--//OK,萬事具備只欠東方,但願下午的測試一切ok.這樣明天就可以安心回家放假了.
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/267265/viewspace-2756967/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- [20210209]修改CPU_COUNT引數2.txt
- [20190523]修改引數後一些細節注意.txt
- [20190523]修改引數後一些細節注意2.txt
- [20180413]bash 位置引數.txt
- [20200420]V$SES_OPTIMIZER_ENV 查不到剛修改的隱含引數.txt
- linux修改系統引數Linux
- [20200620]expdp impdp exclude引數.txt
- Charles 修改請求(Request)引數
- RAC 修改引數DB_FILES
- 使用js修改url地址引數JS
- Windows 下修改Tomcat jvm引數WindowsTomcatJVM
- [20210826]核心引數kernel.sem.txt
- [20190917]oracle引數deferred屬性.txtOracle
- [20200620]IMPDP TRANSFORM引數再探究.txtORM
- [20200220]windows設定keepalive引數.txtWindows
- 不重啟mysql情況修改引數變數MySql變數
- Oracle RAC修改引數檔案位置Oracle
- [20220913]hugepage相關引數含義.txt
- [20191204]hugepage相關引數含義.txt
- [20190417]隱含引數_SPIN_COUNT.txt
- [20210310]db_lost_write_protect引數.txt
- [20190409]latch get 引數where and why.txt
- [20180308]測試ARG_MAX引數.txt
- charles 打斷點修改請求引數斷點
- 在Linux中，linux核心引數如何修改?Linux
- postgresql11修改引數永久生效方法SQL
- DM7修改資料庫引數資料庫
- [20231109]bbed p命令dba引數問題.txt
- [20211027]引數plscope_settings分析PLSQL.txtSQL
- [20190409]latch get 引數where and why測試.txt
- [20190401]隱含引數_mutex_spin_count.txtMutex
- [20180529]模擬會話引數變化.txt會話
- Docker(十七)-修改Docker容器啟動配置引數Docker
- Laravel 修改器能加Request引數嗎?Laravel
- C# 09修改介面引數_簡單粗暴C#
- [20191211]11g streams_pool_size引數.txt
- [20220228]測試Max_idle_blocker_time 引數.txtBloC
- [20181109]12c sqlplus rowprefetch引數5.txtSQL