Liunx基本命令汇总

  才开始接触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/

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值