أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.
I think you can create script for searching and killing blocked sessions in oracle, set this script to crontab, as example at Linux systems:
* * * * * /home/oracle/scripts/kill_blocked.sh, which will run every minutes.
Script like this:
# -- bash script --
ORACLE_SID=$1; export ORACLE_SID
sqlplus -s -l / as sysdba <<!
set linesize150
set heading off
set feedback off
spool /tmp/kill_blocked.log
select p.spid from v$session s, v$process p where s.paddr = p.addr and s.blocking_session is not null;
spool off
exit;
!
log=/tmp/kill_blocked.log
if [ `cat $log|wc -l` -gt0 ]; then
while read line; do
kill -9 $line
done < $log
Thanks for your answer but i am not using crontab for this purpose
Can you give me some example of Schedule Job execution
هل تحتاج لمساعدة في كتابة سيرة ذاتية تحتوي على الكلمات الدلالية التي يبحث عنها أصحاب العمل؟