设置定时清理oraclelong-termINACTIVEsession脚本复制直接执行，或者编辑到文件执行####添加定时清理long-timeINACTIVEsessionif[!-d"${HOME}/cront/"];thenmkdir${HOME}/crontelseecho"Donothing"fi#${HOME}/cront/ks.sqlecho"settrimspoolonspool${HOME}/cront/kills.shreplacesetpagesize0setheadingoffsetlinesize32767SELECT'kill-9'||P.SPIDFROMV\$PROCESSPWHEREP.ADDRIN(SELECTB.PADDRFROMV\$SESSIONBWHEREB.TYPE='USER'和B.STATUS='INACTIVE'ANDB.LAST_CALL_ET>3600);exit;spooloff">${HOME}/cront/ks.sql#${HOME}/cront/debug.sqlecho"oradebugwakeup2;exit;">${HOME}/cront/debug.sql#${HOME}/cront/ks.shecho'#!/bin/bash'>${HOME}/cront/ks.shecho''>${HOME}/cront/cron_kill.logecho''>${HOME}/cront/kill.shecho''>${HOME}/cront/kills.shecho"source${HOME}/.bash_profilesqlplus/assysdba@${HOME}/cront/ks.sqlgrep\"kill\"${HOME}/cront/kills.sh>${HOME}/cront/kill.shecho-e>>${HOME}/cront/cron_kill.logecho\"#################在\`date+'%F%T%A'\`开始'kill-9'commend##################\">${HOME}/cront/cron_kill.logecho-e>>${HOME}/cront/cron_kill.log#终止会话${HOME}/cront/kill.sh>>${HOME}/cront/cron_kill.log#oradebugecho\"#oradebug,无信息返回\">>${HOME}/cront/cron_kill.logsqlplus/assysdba@${HOME}/cront/debug.sql#Infoecho-e>>${HOME}/cront/cron_kill.logecho\"警告：\`cat${HOME}/cront/kill.sh|wc-l\`进程已终止。\">>${HOME}/cront/cron_kill.logecho-e>>${HOME}/cront/cron_kill.logecho\"################停在\`date+'%F%T'\`################\">>${HOME}/cront/cron_kill.log">>${HOME}/cront/ks.sh#授予执行权限chmod+x${HOME}/cront/*#AddCrontd(crontab-l|grep-v"ks.sh")|crontab(crontab-l;echo"*/30****/bin/bash${HOME}/cront/ks.sh")|定时任务表
