dbms_scheduler 相關資料

ysjxjf發表於2012-08-14

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部落格 ” ，連結：http://blog.itpub.net/66634/viewspace-1059174/，如需轉載，請註明出處，否則將追究法律責任。

相關文章