- 论坛徽章:
- 0
|
一个简单的脚本:\r\n\r\n#!/bin/ksh\r\n\r\nORACLE_HOME=/oracle/gtprod/gtproddb/9.2.0\r\nexport ORACLE_HOME\r\nPATH=$ORACLE_HOME/bin PATH\r\nexport PATH\r\nSERVER_NAME=\'uname -a | awk \'{print $2}\'`\r\ntypeset -u SERVER_NAME\r\nexport SERVER_NAME\r\n\r\nSAMPLE_TIME=300\r\n\r\nwhile true do\r\n vmstat ${SAMPLE_TIME} 2 >; /tmp/msg$$\r\n\r\n cat /tmp/msg$$ | sed 1,3d | awk \'{printf(\"%s %s %s %s %s %s\\n\",$1, $8, $9, $20, $21, $22)}\' | while read RUNQUE PAGE_IN PAGE\r\n_OUT USER_CPU SYSTEM_CPU IDLE_CPU do\r\n $ORACLE_HOME/bin/sqlplus -s perfstat/perfstat@gtprod<<!\r\n\r\n insert into perfstat.stats\\$vmstat values(sysdate, $SAMPLE_TIME, \'$SERVER_NAME\', $RUNQUE, $PAGE_IN, $PAGE_OU\r\nT, $USER_CPU, $SYSTEM_CPU, $IDLE_CPU, 0 );\r\n commit;\r\n exit;\r\n !\r\n done\r\ndone\r\nrm /tmp/msg$$\r\n\r\n在执行时总报错:./get_vmstat.ksh[7]: syntax error at line 16 : `(\' unexpected\r\n可是也没有发现哪里有问题啊?请高手指教 |
|