Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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


Ïà¹ØÎĵµ£º

oracle 10g ´´½¨ DATA GUARD

Æäʵ´´½¨dgÍøÂçÉϵÄÎĵµºÜ¶à£¬ÎÒÊÇ¿´Ð¡²¼ÀÏʦÊÇÊÓÆµÑ§Ï°µÄ
ÓÃÐéÄâ»ú×ö²âÊÔ£¬ÅªÁ˺ü¸Ì죬ÏÂÃæ¼Ç¼һÏÂÔø¾­×ö¹ýÓ¡Ïó±È½ÏÉîµÄµØ·½
 
1.½«Primary·þÎñÆ÷´¦Óڹ鵵ģʽºÍForce Loggingģʽ
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP MOUNT;
SQL> ALTER DATABASE ARCHIVELOG;
SQL> ALTER DATABASE OPEN;
S ......

Oracle Data Gurad ÀíÂÛ֪ʶ


RAC£¬ Data Gurad£¬ Stream ÊÇOracle ¸ß¿ÉÓÃÐÔÌåϵÖеÄÈýÖÖ¹¤¾ß£¬Ã¿¸ö¹¤¾ß¼´¿ÉÒÔ¶ÀÁ¢Ó¦Óã¬Ò²¿ÉÒÔÏ໥ÅäºÏ¡£ ËûÃǸ÷×ԵIJàÖØµã²»Í¬£¬ÊÊÓó¡¾°Ò²²»Í¬¡£
RAC ËüµÄÇ¿ÏîÔÚÓÚ½â¾öµ¥µã¹ÊÕϺ͸ºÔؾùºâ£¬Òò´ËRAC ·½°¸³£ÓÃÓÚ7*24 µÄºËÐÄϵͳ£¬µ«RAC ·½°¸ÖеÄÊý¾ÝÖ»ÓÐÒ»·Ý£¬¾¡¹ ......

ʹÓÃoracleµÄһЩ¼¼ÇÉ·½·¨

½«²éѯµÄ½á¹ûÉú³Éµ½ÎļþÖУº
set echo on --ÊÇ·ñÏÔʾִÐеÄÃüÁîÄÚÈÝ
set feedback off --ÊÇ·ñÏÔʾ * rows selected
set heading off --ÊÇ·ñÏÔʾ×ֶεÄÃû³Æ
set verify off --ÊÇ·ñÏÔÊ¾Ìæ´ú±äÁ¿±»Ìæ´úǰºóµÄÓï¾ä¡£fil
set trimspool off --È¥×ֶοոñ
set pagesize 1000 ......

oracle ¹ÙÍøÎÞ·¨·ÃÎʵÄÎÊÌâ

×î½üÓöµ½ÔÚwindows 2008ÏÂIEÆäËüµÄÍøÒ³¶¼¿ÉÒÔ·ÃÎÊ,ΨÓÐoracle.com²»ÄÜ·ÃÎÊ,ÕæÓôÃÆÁË,ºóÀ´ÕÒÒ»´úÀí,·ÃÎÊËÙ¶È»¹¿ÉÒÔ,ÅäÖÃÈçÏÂ:
Õâ¸ö´úÀíµÚÒ»´Î·ÃÎʵϰ£¬ÐèÒªÌøµ½ËûµÄÖ÷Ò³£¬¹ý¸öÊ®¼¸ÃëÖоͿÉÒÔÌø×ªµ½OracleµÄ¹Ù·½ÍøÕ¾ÁË¡£
—————————————&md ......

oracleÁ·Ï°£¨mldnÊÓÆµ¿Î³Ì£©Èý

×ÛºÏÁ·Ï°
ѧÉúÔ˶¯»á±ÈÈüÐÅÏ¢Êý¾Ý¿â
1£¬Ô˶¯Ô±sporter£¨Ô˶¯Ô±±àºÅsporterid£¬Ô˶¯Ô±ÐÕÃûname£¬Ô˶¯Ô±ÐÔ±ðsex£¬ËùÊôϵºÅdepartment£©
2£¬ÏîÄ¿item£¨ÏîÄ¿±àºÅitemid£¬ÏîÄ¿Ãû³Æitemname£¬ÏîÄ¿±ÈÈüµØµãlocation£©
3£¬³É¼¨grade£¨Ô˶¯Ô±±àºÅsporterid£¬ÏîÄ¿±àºÅitemid£¬»ý·Ömark£©
½¨±í
1£¬¶¨Òå¸÷¸ö±íµÄÖ÷ÂëÍâÂëÔ¼Êø
2£¬ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ