才开始接触Liunx,收集一些常用命令,备忘!
[@more@]ps -ef|grep ora_|grep -v grep oracle 2092 1 0 Mar09 ? 00:03:09 ora_pmon_topprod oracle 2094 1 0 Mar09 ? 00:04:29 ora_dbw0_topprod oracle 2096 1 0 Mar09 ? 00:07:37 ora_lgwr_topprod oracle 2098 1 0 Mar09 ? 00:04:47 ora_ckpt_topprod oracle 2100 1 0 Mar09 ? 00:02:43 ora_smon_topprod oracle 2102 1 0 Mar09 ? 00:00:09 ora_reco_topprod oracle 2104 1 0 Mar09 ? 00:00:43 ora_cjq0_topprod oracle 2106 1 0 Mar09 ? 00:01:42 ora_qmn0_topprod ps -ef|grep -i oracletopprod|grep -v grep|wc -l 279 who fairy pts/0 Mar 15 07:43 (192.168.1.218) huiyi pts/1 Mar 15 08:58 (192.168.1.221) who -u fairy pts/0 Mar 15 07:43 01:53 17945 (192.168.1.218) huiyi pts/1 Mar 15 08:58 . 23355 (192.168.1.221) who -uH NAME LINE TIME IDLE PID COMMENT fairy pts/0 Mar 15 07:43 01:53 17945 (192.168.1.218) huiyi pts/1 Mar 15 08:58 . 23355 (192.168.1.221) cat /proc/cpuinfo|grep processor processor : 0 processor : 1 processor : 2 processor : 3 cat /proc/cpuinfo|grep processor|wc -l 4 #!/bin/ksh ORACLE_SID=topprod export ORACLE_SID ORACLE_HOME=/u2/oracle/9i export ORACLE_HOME ORACLE_BASE=/u2/oradb export ORACLE_BASE #NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"; export NLS_LANG NLS_LANG="TRADITIONAL CHINESE_TAIWAN.ZHT16BIG5" export NLS_LANG NLS_DATE_FORMAT='RRRR/MM/DD' export NLS_DATE_FORMAT sar|grep -v Aver|sed 1,3d|awk '{ printf("%s %s %s %s %s %sn",$1,$2,$3,$4,$5,$6)}'|while read a b c d e f do $ORACLE_HOME/bin/sqlplus -s "/ as sysdba" << ! insert into huiyi.cpu_use_infor values(to_date(to_char(sysdate,'yyyymmdd')||'$a','yyyymmddhh24:mi:ss'), '$b',$c,$d,$e,$f); exit ! done /etc/sysconfig/network-scripts/ifcfg-eth0
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8799875/viewspace-905262/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/8799875/viewspace-905262/