-- 查看Oracle后台进程

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



-- 查看Oracle连接数

ps -ef|grep -i oracletopprod|grep -v grep|wc -l
    279



-- 当前登陆会话的信息
-- -u:显示空闲时间(IDLE),以及进程ID(PID)
-- -H:打印标题

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)




-- 顯示CPU的信息
-- CPU信息存放在/proc/cpuinfo文件下

cat /proc/cpuinfo|grep processor
processor       : 0
processor       : 1
processor       : 2
processor       : 3
cat /proc/cpuinfo|grep processor|wc -l
      4



-- 取CPU信息存至数据库中
-- sar 取CPU信息
-- sed 截取内容
-- awk 抽取内容至变量

#!/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



-- 修改IP

/etc/sysconfig/network-scripts/ifcfg-eth0