dbms_scheduler

ps -ef|grep ora_j|kill -9 `awk {'print $2'}`

[@more@]

SQL> exec dbms_scheduler.disable(name=>'INSERT_TEST_JOB',force=>true);

PL/SQL procedure successfully completed.

SQL>

SQL> select job_name ,state from user_scheduler_jobs
2 ;

JOB_NAME STATE
------------------------------ ---------------
INSERT_TEST_JOB DISABLED

SQL>

SQL> exec dbms_system.set_sql_trace_in_session(32,1633,true);

PL/SQL procedure successfully completed.

SQL>

select * from v$lock where id1=76777;

ITPub博客

dbms_scheduler 相关资料