[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.这样明天就可以安心回家放假了.
[20210209]修改CPU_COUNT参数.txt
来源:这里教程网
时间:2026-03-03 16:26:05
作者:
编辑推荐:
- [20210209]修改CPU_COUNT参数.txt03-03
- [20210209]修改CPU_COUNT参数2.txt03-03
- 从Oracle数据库故障到AIX内存管理03-03
- [20210203]max优化的困惑.txt03-03
- Oracle 12c SCN推进方法汇总(三)之BBED03-03
- 苏宁有货:为“轻创业”而来03-03
- Oracle 10g 增删节点03-03
- [20210203]19c登录连接改变一些参数.txt03-03
下一篇:
相关推荐
-
雷神推出 MIX PRO II 迷你主机:基于 Ultra 200H,玻璃上盖 + ARGB 灯效
2 月 9 日消息,雷神 (THUNDEROBOT) 现已宣布推出基于英
-
制造商 Musnap 推出彩色墨水屏电纸书 Ocean C:支持手写笔、第三方安卓应用
2 月 10 日消息,制造商 Musnap 现已在海外推出一款 Oce
热文推荐
- 从Oracle数据库故障到AIX内存管理
从Oracle数据库故障到AIX内存管理
26-03-03 - 苏宁有货:为“轻创业”而来
苏宁有货:为“轻创业”而来
26-03-03 - Oracle 10g 增删节点
Oracle 10g 增删节点
26-03-03 - 【BUILD_ORACLE】Oracle 19c RAC搭建(六)创建RAC数据库
- 【BUILD_ORACLE】Oracle 19c RAC搭建(五)DB软件安装
- update误操作后 通过undo记录的scn找回原纪录
update误操作后 通过undo记录的scn找回原纪录
26-03-03 - 安装oracle 19c rac报错:2节点执行root.sh asm实例启动失败
- Comprar camisetas de futbol baratas
Comprar camisetas de futbol baratas
26-03-03 - 延迟密码验证特性引起的数据库HANG死及宕机
延迟密码验证特性引起的数据库HANG死及宕机
26-03-03 - 空格导致的impdp时的ORA-07445错误
空格导致的impdp时的ORA-07445错误
26-03-03
