Oracle实际被分配的CPU个数

stenny

Oracle实际被分配的CPU个数\r\n\r\n可能是因为服务器是共享环境所以老板才有这个问题吧\r\n\r\n用prsinfo看出来是4个双核CPU\r\n\r\nThe UltraSPARC-IV physical processor has 2 virtual processors (0, 16)\r\nThe UltraSPARC-IV physical processor has 2 virtual processors (1, 17)\r\nThe UltraSPARC-IV physical processor has 2 virtual processors (2, 1\r\nThe UltraSPARC-IV physical processor has 2 virtual processors (3, 19)\r\n\r\n用prstat看当前情况Oracle貌似8个CPU都有用过\r\nPID USERNAME SIZE RSS STATE PRI NICE TIME CPU PROCESS/NLWP\r\n153379 oracle 1122M 1082M cpu16 1 0 22:25:18 12% oracle/1\r\n194995 oracle 1704M 1669M cpu2 4 0 2:50:46 12% oracle/68\r\n201693 oracle 1700M 1661M cpu0 4 0 0:07:48 12% oracle/1\r\n194810 oracle 1344K 1056K cpu1 32 2 2:32:20 12% gzip/1\r\n191677 oracle 1344K 1056K cpu17 30 2 4:32:58 11% gzip/1\r\n153377 oracle 1122M 1081M cpu3 33 0 22:16:02 10% oracle/1\r\n191679 oracle 851M 802M sleep 37 2 1:14:22 4.7% oracle/11\r\n201652 oracle 1703M 1671M sleep 60 0 0:06:45 3.7% oracle/1\r\n194812 oracle 1142M 1094M sleep 26 2 0:56:40 2.6% oracle/11\r\n191678 oracle 17M 11M sleep 55 2 0:18:06 1.2% exp/1\r\n194811 oracle 18M 12M sleep 52 2 0:16:15 0.6% exp/1\r\n38655 oracle 1712M 1661M sleep 51 0 3:38:53 0.1% oracle/20\r\n38653 oracle 1713M 1666M sleep 42 0 4:08:27 0.1% oracle/258\r\n513 root 8472K 7848K sleep 29 0 40:04:00 0.1% picld/11\r\n199282 oracle 1772M 1728M sleep 52 0 0:00:19 0.1% oracle/11\r\n200276 oracle 1367M 1329M cpu19 55 0 0:00:00 0.1% oracle/1\r\nTotal: 421 processes, 2978 lwps, load averages: 7.64, 7.32, 6.83\r\n\r\n虽然CPU_COUNT参数是8,但是还是比较怀疑在操作系统可以配置实际分配CPU(virtual)的个数,望达人指点一二,谢谢!\r\n另外在/etc/system里面也没有找到对process的limits......而且也未必局限于Oracle,假如说是对其他的一个service,如何看出究竟在操作系统层分配了几个CPU?

FreeWare

操作系统并不作这样的分配，它只在你需要计算的时候把一个空闲的CPU时间片分给某个线程。也就是说有多少CPU用多少。

stenny

如果在这个server上有多个instance，是否可以看到具体哪一个instance对CPU的利用情况？