1、#kill -9 $(ps -ef|grep 进程名关键字|gawk ‘$0 !~/grep/ {print $2}’ |tr -s ‘\n’ ‘ ‘)这个是利用管道和替换将 进程名对应的进程号提出来作为kill的参数。
很显然上面的方法能完成但是过于复杂,下面这种就显得简单的多了
2、#kill -9 $(pidof 进程名关键字)
分类: 未分类
oracle tips
函数 过程 表名 trigger保持大写,否则默认大小写敏感找不到对象
sqlplus username/pass@//172.31.xxx.xxx:1521/ORCL
sql server收缩数据库和日志
解决npm报错Error: EACCES: permission denied
sudo npm install -g xxxxx –unsafe-perm=true –allow-root
转:查询oracle比较慢的session和sql
–查询最慢的sql
select * from ( select parsing_user_id,executions,sorts command_type,disk_reads,sql_text from v$sqlarea order by disk_reads desc )where rownum<10
Elasticsearch Mapping – Rename existing field
gomobile
初始化:
gomobile init -ndk /Users/usualwyy/Library/Android/sdk/ndk-bundle/
android:
gomobile bind -target=android/arm
ios:
gomobile bind -target=ios/arm
aws rds mysqld存储过程创建tips
CREATE DEFINER=`root`@`localhost` `xxxxxxx`()
替换成
CREATE DEFINER=CURRENT_USER PROCEDURE `xxxxxxx`()
否则报权限错误
oracle sql日志
select b.SQL_TEXT,b.LAST_ACTIVE_TIME,b.SQL_FULLTEXT
from v$sqlarea b
where module=’xxxxx.exe’
order by b.LAST_ACTIVE_TIME desc
Windows 2008 端口转发
首先安装IPV6(xp下IPV6必须安装,否则端口转发不可用!)
netsh interface ipv6 install
添加一个IPV4到IPV4的端口映射
netsh interface portproxy add v4tov4 listenaddress=192.168.193.1 listenport=22 connectaddress=xxx.xxx.xxx.xxx connectport=22
指定监听ip和端口可以删除
netsh interface portproxy delete v4tov4 listenaddress=192.168.193.1 listenport=22
可以查看存在的转发
netsh interface portproxy show all