Oracle job ʹÓÃ
²½Ö裺
(1) ´´½¨×÷Òµ
(2) ´´½¨job
dbms_job.submit();
submit ( jobno¡¡OUT binary_ineger,
¡¡¡¡¡¡¡¡¡¡¡¡¡¡What¡¡¡¡¡¡IN¡¡varchar2,
¡¡¡¡¡¡¡¡¡¡¡¡¡¡next_date IN¡¡date,
¡¡¡¡¡¡¡¡¡¡¡¡¡¡interval¡¡IN¡¡varchar2,
¡¡¡¡¡¡¡¡¡¡¡¡ no_parse¡¡IN¡¡booean:=FALSE)
¡¡¡¡
¡¡¡¡jobno²ÎÊýÊÇÓÉSubmit()¹ý³Ì·µ»ØµÄbinary_ineger¡£Õâ¸öÖµÓÃÀ´Î¨Ò»±êʶһ¸ö¹¤×÷¡£
¡¡¡¡what²ÎÊýÊǽ«±»Ö´ÐеÄPL/SQL´úÂë¿é Ò²¾ÍÊÇtask¡£
¡¡¡¡next_date²ÎÊýָʶºÎʱ½«ÔËÐÐÕâ¸ö¹¤×÷¡£
¡¡¡¡interval²ÎÊýºÎʱÕâ¸ö¹¤×÷½«±»ÖØÖ´ÐС£
¡¡¡¡no_parse²ÎÊýָʾ´Ë¹¤×÷ÔÚÌύʱ»òÖ´ÐÐʱÊÇ·ñÓ¦½øÐÐÓï·¨·ÖÎö——TRUEָʾ´ËPL/SQL´úÂëÔÚËüµÚÒ»´ÎÖ´ÐÐʱӦ½øÐÐÓï·¨·ÖÎö£¬¶ø FALSEָʾ±¾PL/SQL´úÂëÓ¦Á¢¼´½øÐÐÓï·¨·ÖÎö¡£
(3) ÔËÐÐ
dbms_job.run(jobno);
(4) ɾ³ý
dbms_job.remove(jobno)
--ÔÝÍ£Ò»¸öjob
exec dbms_job.broken(jobno,true)
commit //±ØÐëÌá½»·ñÔòÎÞЧ
Æô¶¯Ò»¸öjob
exec dbms_job.broken(jobno,false)
/*********************************************************************************/
eg: ͨ¹ýjob ÿ¹ýÒ»·ÖÖÓÏòÒ»ÕűíÀïÃæ²åÈëÒ»ÌõÊý¾Ý
create or replace package body test is
--´´½¨±í
procedure createTable is
num number;
begin
--²é¿´ÏµÍ³±íÀïÊÇ·ñÒѾ´æÔÚ£¬Ã»Óд´½¨
select count(*) into num from user_tables where table_name= 'TEMP_JOB';
if (num>0) then
--ɾ³ý±í
execute immediate 'drop table temp_job';
commit;
end if;
--´´½¨±í
execute immediate 'create table temp_job(
address varchar2(200),
&
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
28.4.2 ¿ª»ú×Ô¶¯Æô¶¯OracleÊý¾Ý¿â·þÎñ
OracleÌṩÁË3¸öÎļþ£¬ÓÃÓÚÅäÖÃOracleÊý¾Ý¿â·þÎñµÄ×Ô¶¯Æô¶¯£¬ËüÃÇ·Ö±ðÊÇ/etc/oratab¡¢$ORACLE_HOME/bin/dbstartÒÔ¼°$ORACLE_HOME/bin/dbshut¡£¹ØÓÚÕâ3¸öÎļþµÄ˵Ã÷ÈçÏÂËùʾ¡£
q /etc/oratab£ºÔÚ¸ÃÎļþÖÐÖ¸¶¨ÐèÒª×Ô¶¯Æô¶¯ºÍ¹Ø±ÕµÄÊý¾Ý¿â¡£
q&nb ......
¹Ø¼ü´Ê:
°ó¶¨±äÁ¿(binding variable),¹²Ïí³Ø(shared buffer pool), SGA(system global area);
ÔÚ¿ª·¢Ò»¸öÊý¾Ý¿âϵͳǰ,ÓÐ˶ÔOracle ϵͳÁ˽âºÜ¶à,ÓÈÆäÊÇËüµÄÌØÐÔ,ºÃÏóºÜÉÙ°É;¶Ô³õѧÕßÀ´½²,Õâ¸üÊDz»¿ÉÄܵÄÊÂÇé;½ö½ö¼òµ¥ÕÆÎÕÁËSQLµÄд·¨,¾Í¿ªÊ¼ÁËÊý¾Ý¿âµÄ¿ª·¢,Æä½á¹ûÖ»ÄÜÊÇ¿ª·¢Ò»¸öûÓÐЧÂÊ,ҲûÓпÉÀ©Õ¹µÄϵͳ;
Òò´Ë,ÎÒ ......
QTPÁ¬½Óoracle²¢²Ù×÷Êý¾Ý¿âµÄ·½·¨ÕâÀïÒÔoracle 9iΪÀý×Ó£¬ÆäËûµÄÊý¾Ý¿âÁ¬½Ó·½·¨ÊÇÏàͨµÄ¡£
a.Ê×ÏÈÒªÔÚ±¾»ú½¨ÒéODBCÊý¾ÝÔ´£¬Õâ¸öÊôÓÚ»ù±¾²Ù×÷£¬ÕâÀï²»½²£¬Ìø¹ý£»
b.»ñÈ¡oracleµÄÁ¬½Ó´®µÄ·½·¨£¬ÔÚ±¾µØн¨Ò»¸ö.txtÎļþ£¬ÐÞ¸ÄÀ©Õ¹ÃûÃû*.udl£¬Ë«»÷*.udlÎļþ£¬´ò¿ªÊý¾Ý¿âÁ´½ÓÊôÐÔ£¬¶¨Î»µ½“Ìṩ³ÌÐò”Ñ¡ÏÔ¿¨£¬ ......