发布时间:2015-05-28 11:38:04
/*查找被锁表*/select b.owner,b.object_name,a.session_id,a.locked_mode from v$locked_object a,dba_objects b where b.object_id = a.object_id;/*查找被锁表的session*/select b.username,b.sid,b.serial#,logon_time from v$locked_object a,v$session b where a.session_id = b.sid order by b.logon_time;/*解.........【阅读全文】
发布时间:2015-05-15 11:19:10
#!/bin/sh(sh test.sh)& #被监控的进程放在后台运行while true #死循环不断监控后台运行的进程do pid=`ps -ef |grep "sh test.sh" | grep -v "grep" | awk '{print $2}'` #取后台运行程序的进程号 if [ -z $pid ] .........【阅读全文】
发布时间:2015-05-12 11:22:51
while truedo#画界面author:孙奇峰 cleari=3echo -ne "\033[2;26H__________________________________________________________________________"echo -ne "\033[5;25H___________________________________________________________________________"echo -ne "\033[22;25H _____________________________________.........【阅读全文】