27.07.2010
01.04.2010
Directory list in wiki format
ls -R | grep ":$" | sed -e 's/:$//' -e 's/[^\/]*\//-/g' -e
's/\(-\)\([a-zA-Z].*$\)/\1 \*\2\*/'
's/\(-\)\([a-zA-Z].*$\)/\1 \*\2\*/'
11.03.2010
make alias,mail,pass csv from mail list
for i in `sed 's/\(^.*\)\@\(.*$\)/\1,\1@\2/g' newKey.csv` ; do echo ${i},`head /dev/urandom | uuencode -m - | sed -n 2p | cut -c1-${1:-6}` ; done
21.01.2010
Find and destroy Oracle TX locks
select username, SYS.v_$lock.sid,lmode,request from SYS.v_$lock,SYS.v_$session
where SYS.v_$lock.type='TX'and SYS.v_$lock.sid=SYS.v_$session.sid;
select serial# from SYS.v_$session where SID = '336'
alter system kill session '336,7263'
where SYS.v_$lock.type='TX'and SYS.v_$lock.sid=SYS.v_$session.sid;
select serial# from SYS.v_$session where SID = '336'
alter system kill session '336,7263'
Подписаться на:
Сообщения (Atom)