ORACLEÈçºÎÍ£Ö¹Ò»¸öJOB
ORACLEÈçºÎÍ£Ö¹Ò»¸öJOB
1 Ïà¹Ø±í¡¢ÊÓͼ
2 ÎÊÌâÃèÊö
Ϊͬʽâ¾öÒ»¸öÒòÎªÍøÂçÁ¬½ÓÇé¿ö²»¼Ñʱ£¬Ö´ÐÐÒ»¸ö³¬³¤Ê±¼äµÄSQL²åÈë²Ù×÷¡£
¼ÈÈ»ÍøÂç×´¿ö²»ºÃ£¬¾ÍÑ¡ÔñÁËʹÓÃÒ»´ÎÐÔʹÓÃJOBÀ´Íê³É¸Ã²åÈë²Ù×÷¡£ÔÚJOBÖ´ÐÐÒ»¶Îʱ¼äºó£¬ÎÒ·¢ÏÖ±»²åÈë±íÓÐЩÎÊÌ⣨²ÑÀ¢£¬µ±Ê±Ò²Ã»ÓÐÏȼì²é¼ì²é¾Í×öÁË£©¡£×¼±¸Í£Ö¹JOB£¬ÒòΪÔÚJOBÔËÐÐÇé¿öÏ£¬ÎÒµÄËùÓÐÐ޸ͼ»á±¨ÏµÍ³×ÊԴæµÄ´íÎó¡£
Ç¿ÐÐKILL SESSIONÊÇÐв»Í¨µÄ£¬ÒòΪ¹ý»á¶ù£¬JOB»¹»áÖØÐÂÆô¶¯£¬Èç¹ûÖ´ÐеÄSQLÒ²±»KILLÁËͨ¹ýÖØÐÂÆô¶¯µÄJOB»¹ÊǻᱻÔÙ´ÎÐÂÖ´Ðеġ£
3 ½â¾ö°ì·¨
±È½ÏºÃµÄ·½·¨Ó¦¸ÃÊÇ;
1). Ê×ÏÈÈ·¶¨ÒªÍ£Ö¹µÄJOBºÅ
ÔÚ10gÖпÉͨ¹ýDba_Jobs_Running½øÐÐÈ·ÈÏ¡£
²éÕÒÕýÔÚÔËÐеÄJOB:
select sid from dba_jobs_running;
²éÕÒµ½ÕýÔÚÔËÐеÄJOBµÄspid:
select a.spid from v$process a ,v$session b where a.addr=b.paddr and b.sid in (select sid from dba_jobs_running);
2). BrokenÄãÈ·ÈϵÄJOB
×¢ÒâʹÓÃDBMS_JOB°üÀ´±êʶÄãµÄJOBΪBROKEN¡£
SQL> EXEC DBMS_JOB.BROKEN(job#,TRUE);
×¢Ò⣺µ±Ö´ÐÐÍê¸ÃÃüÁîÄãÑ¡ÔñµÄÕâ¸öJOB»¹ÊÇÔÚÔËÐÐ×ŵġ£
3). Kill ¶ÔÓ¦µÄOracle Session
ӦΪBROKENºó¸ÃJOB»¹ÔÚÔËÐУ¬Èç¹ûÒªÇó¸ÃJOBÁ¢¿ÌÍ£Ö¹£¬¾ÍÐèÒªÕÒµ½¸ÃjobµÄ¶ÔÓ¦SESSION(SID,SERIAL#)£¬È»ºóÖ´ÐÐÒÔÏÂÃüÁ
ALTER SYSTEM KILL SESSION 'sid,serial#';
»òÕßÖ±½ÓKILL¶ÔÓ¦µÄ²Ù×÷ϵͳµÄSESSION£¬Èç¹ûʹÓÃALTER SYSTEM KILL SESSIONÖ´Ðкܳ¤Ê±¼ä£¬Æäʵ¿ÉÒÔʹÓÃOSµÄÃüÁîÀ´¿ìËÙKILLµôSESSION.
For Windows, at the DOS Prompt: orakill sid spid
For UNIX at the command line> kill –9 spid
4). ¼ì²éÄãµÄJOBÊÇ·ñ»¹ÔÚÔËÐÐ
¼ì²éÄãҪֹͣµÄJOBÊÇ·ñ»¹ÔÚÔËÐУ¬Æäʵ¶àÊýÇé¿öÏ£¬Ó¦¸Ã¶¼ÒѾֹͣÁË¡£ÓÈÆäÖ´ÐеĵÚÈý²½µÄ“ɱÊÖ”ÃüÁî¡£Èç¹ûÕæµÄ»¹ÊÇûÓÐÍ£Ö¹£¬Ö»ºÃ´ÓµÚÒ»µÀµÚÈý²½ÖØÐÂ×öÒ»ÏÂÁË¡£
5). ½«Job Queue ProcessesµÄÊýÄ¿ÐÞ¸ÄΪ0
Ê×ÏÈÈ·Èϵ±Ç°µÄJob Queue ProcessesµÄÊýÄ¿
SQL> col value for a10
SQL> sel
Ïà¹ØÎĵµ£º
ÓÐÈËÓöµ½Õâôһ¸öÎÊÌ⣬·ÃÎÊÒ»¸öÐòÁÐÔõô³ö´íÁË£¬´íÎóÈçÏ£º ORA-08002: ÐòÁÐ SEQ_GX.CURRVAL ÉÐδÔڴ˻ỰÖж¨Òå ÕâÊÇÒòΪÔÚÒ»¸öеĻỰÖУ¬ÐòÁÐÐèÒª³õʼ»¯£¬Ò²¾ÍÊÇͨ¹ý.NEXTVALÀ´Íê³ÉÐòÁеijõʼ»¯¡£ ²âÊÔÈçÏ£º Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 Connected as crmii SQL> SQ ......
empÔ±¹¤±í
(empnoÔ±¹¤ºÅ/enameÔ±¹¤ÐÕÃû/job¹¤×÷/mgrÉϼ¶±àºÅ/hiredateÊܹÍÈÕÆÚ/salн½ð/commÓ¶½ð/deptno²¿ÃűàºÅ)
------1.Ñ¡Ôñ²¿ÃÅ30ÖеÄËùÓÐÔ±¹¤.
select ename
from emp
where deptno = 30;
------2.ÁгöËùÓаìÊÂÔ±(CLERK)µÄÐÕÃû£¬±àºÅºÍ²¿ÃűàºÅ.
select ename,empno,deptno
from emp
where job='CLERK';
--- ......
Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Microsoft Windows (32-bit)
http://download.oracle.com/otn/nt/oracle10g/10201/10201_database_win32.zip
http://download.oracle.com/otn/nt/oracle10g/10201/10201_client_win32.zip
http://download.oracle.com/otn/nt/oracle10g/10 ......
RAC£¬ Data Gurad£¬ Stream ÊÇOracle ¸ß¿ÉÓÃÐÔÌåϵÖеÄÈýÖÖ¹¤¾ß£¬Ã¿¸ö¹¤¾ß¼´¿ÉÒÔ¶ÀÁ¢Ó¦Óã¬Ò²¿ÉÒÔÏ໥ÅäºÏ¡£ ËûÃǸ÷×ԵIJàÖØµã²»Í¬£¬ÊÊÓó¡¾°Ò²²»Í¬¡£
RAC ËüµÄÇ¿ÏîÔÚÓÚ½â¾öµ¥µã¹ÊÕϺ͸ºÔؾùºâ£¬Òò´ËRAC ·½°¸³£ÓÃÓÚ7*24 µÄºËÐÄϵͳ£¬µ«RAC ·½°¸ÖеÄÊý¾ÝÖ»ÓÐÒ»·Ý£¬¾¡¹ ......
×ÛºÏÁ·Ï°
ѧÉúÔ˶¯»á±ÈÈüÐÅÏ¢Êý¾Ý¿â
1£¬Ô˶¯Ô±sporter£¨Ô˶¯Ô±±àºÅsporterid£¬Ô˶¯Ô±ÐÕÃûname£¬Ô˶¯Ô±ÐÔ±ðsex£¬ËùÊôϵºÅdepartment£©
2£¬ÏîÄ¿item£¨ÏîÄ¿±àºÅitemid£¬ÏîÄ¿Ãû³Æitemname£¬ÏîÄ¿±ÈÈüµØµãlocation£©
3£¬³É¼¨grade£¨Ô˶¯Ô±±àºÅsporterid£¬ÏîÄ¿±àºÅitemid£¬»ý·Ömark£©
½¨±í
1£¬¶¨Òå¸÷¸ö±íµÄÖ÷ÂëÍâÂëÔ¼Êø
2£¬ ......