Oracle job ¹ÜÀí
SVRMGR> select * from dba_jobs;
³õʼ»¯Ïà¹Ø²ÎÊýjob_queue_processes
alter system set job_queue_processes=39 scope=spfile;//×î´óÖµ²»Äܳ¬¹ý1000 ;job_queue_interval = 10 //µ÷¶È×÷ҵˢÐÂƵÂÊÃëΪµ¥Î»
DBA_JOBS describes all jobs in the database.
USER_JOBS describes all jobs owned by the current user
1 select job,what,to_char(last_date,'yyyy-mm-dd HH24:mi:ss'),to_char(next_date,'yyyy-mm-dd HH24:m),interval from dba_jobs where job in (325,295)
2 select job,what,last_date,next_date,interval from dba_jobs where job in (1,3);
²éѯjobµÄÇé¿ö¡£
show paramter background_dump_dest.
¿´alter.log ºÍtrace
SVRMGR> select * from dba_jobs;
³õʼ»¯Ïà¹Ø²ÎÊýjob_queue_processes
alter system set job_queue_processes=39 scope=spfile;//×î´óÖµ²»Äܳ¬¹ý1000
job_queue_interval = 10 //µ÷¶È×÷ҵˢÐÂƵÂÊÃëΪµ¥Î»
DBA_JOBS describes all jobs in the database.
USER_JOBS describes all jobs owned by the current user
1 select job,what,to_char(last_date,'yyyy-mm-dd HH24:mi:ss'),to_char(next_date,'yyyy-mm-dd HH24:m),interval from dba_jobs where job in (325,295)
2 select job,what,last_date,next_date,interval from dba_jobs where job in (1,3);
²éѯjobµÄÇé¿ö¡£
show paramter background_dump_dest.
¿´alter.log ºÍtrace
ÇëÎÊÎÒÈçºÎÍ£Ö¹Ò»¸öJOB
SQL> exec dbms_job.broken(1,true)
PL/SQL ¹ý³ÌÒѳɹ¦Íê³É¡£
SQL>commit //±ØÐëÌá½»·ñÔòÎÞЧ
Æô¶¯×÷Òµ
SQL> exec dbms_job.broken(1,false)
PL/SQL ¹ý³ÌÒѳɹ¦Íê³É¡£
Í£ÆäËûÓû§µÄjob
SQL>exec sys.dbms_ijob.broken(98,true);
SQL>commit;
============================
exec dbms_job.broken(:job) ֹͣ
exec dbms_job.broken(186,true) //±ê¼Çλbroken
exec dbms_job.broken(186,false)//±ê¼ÇΪ·Çbroken
exec dbms_job.broken(186,false,next_day(sysdate,'monday')) //±ê¼ÇΪ·Çbroken,Ö¸¶¨Ö´ÐÐʱ¼ä
exec dbms_job.remove(:job)£»É¾³ý
exec dbms_job.remove(186);
commit£»
°ÑÒ»¸öbroken jobÖØÐÂÔËÐÐ
Èý¡¢²é¿´Ïà¹ØjobÐÅÏ¢
1¡¢Ïà¹ØÊÓͼ
dba_jobs
all_jobs
user_jobs
dba_jobs_running °üº¬ÕýÔÚÔËÐÐjobÏà¹ØÐÅÏ¢
´´½¨JOB
variable j
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
OracleÖв»ÏñÆäËûÈçmysqlµÈÊý¾Ý¿âµÄÓÐ×ÔÔö×ֶΣ¬Èç¹ûÐèÒªÔòÐèÒª½èÖúÐòÁкʹ¥·¢Æ÷
Ê×ÏȽ¨±í
½¨Á¢ÐòÁÐ
½¨´¥·¢Æ÷
For example£º
create table SYS_MESSAGE
(
ID NUMBER not null PRIMARY KEY,
M_TYPE VARCHAR2(10) not null,
TITLE VARCHAR2(200),
CONTENT LONG,
M_TIME VARCHAR2(50),
A ......
½ñÌìÔÚÏîÄ¿¿ª·¢ÖУ¬·¢ÏÖÊý¾Ý¿âÁ¬½ÓÊý¹ý¶à£¬oracleÖдæÔںܶ೬ʱÁ¬½Ó¡£µ¼ÖÂÐÂÔö¿Í»§¶ËÎÞ·¨Á¬½Óµ½Êý¾Ý¿â¡£ËùÒÔÉèÖÃÁËÇ¿ÖÆÊÍ·ÅoracleÁ¬½ÓÊôÐÔ¡£
ÔÚÍøÉϲéѯÁËÉèÖÃ˵Ã÷ÈçÏ£º
sqlplus /nolog
´ò¿ªsqlplus
connect system/bianqiwei@orcltns as sysdba
ʹÓþßÓÐdbaȨÏÞµÃÓû§µÇ½oracle
show p ......
ʹÓÃCodeSmithÉú³ÉoracleÊý¾Ý¿â±íµÄʵÌå²ã(Model)
http://blog.csdn.net/dacong/archive/2009/01/27/3853663.aspx
×Ô¼ºÐ´µÄ£¬CodeSimthÖеÄÀý×Ó¶¼ÊÇmsSQL serverµÄ£¬ËùÒÔ×Ô¼ºÐ´Á˸öÖ§³ÖOracleÊý¾Ý¿â±íµÄ£¬²»Ò»¶¨ºÜÍêÉÆ£¬ÊÊÓþͺã¬Êý¾ÝÀàÐÍûÓÐÖÜÈ«¿¼ÂÇ£¬Ö»¿¼ÂÇÁ˳£ÓõÄһЩÀàÐÍ£¬Ôö¼ÓÁ˸ö±íÃû×ÖÊôÐÔ£¬²ÉÓõÄ.net2.0ÎÒ½á ......
Ò»¡¢ÔÚORACLE´´½¨Ò»¸öеÄʵÀý¹ý³Ì£º
1¡¢°²×°ºÃORACLE·þÎñ¶Ë¡£
2¡¢´´½¨Êý¾Ý¿âʵÀý£¬Ê¹ÓÃORAHOMEĿ¼ÏµÄ"Configuration and Migration Tools"ϵÄ"Database Configuration Assistant"¹¤¾ß¡£
&nbs ......