Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ÐòÁÐÉú³ÉÆ÷(sequence)ʹÓõÄÒ»µãСעÒâ

ÓÐÈËÓöµ½Õâôһ¸öÎÊÌ⣬·ÃÎÊÒ»¸öÐòÁÐÔõô³ö´íÁË£¬´íÎóÈçÏ£º 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 ......

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²éѯÁ·Ï°

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Ö´Ðмƻ®

ÈçºÎ¿´¶®ORACLEÖ´Ðмƻ®
Ò»¡¢Ê²Ã´ÊÇÖ´Ðмƻ®
An explain plan is a representation of the access path that is taken when a query is executed within Oracle.
¶þ¡¢ÈçºÎ·ÃÎÊÊý¾Ý
At the physical level Oracle reads blocks of data. The smallest amount of data read is a single Oracle block, the largest is con ......

OracleÖÐÖ»¸üÐÂÁ½Õűí¶ÔÓ¦Êý¾ÝµÄ·½·¨

OracleÖÐÖ»¸üÐÂÁ½Õűí¶ÔÓ¦Êý¾ÝµÄ·½·¨
ÏȽ¨Á¢Ò»¸ö½á¹¹Ò»Ä£Ò»ÑùµÄ±íemp1£¬²¢ÎªÆä²åÈ벿·ÖÊý¾Ý
create table emp1
as
select * from emp where deptno = 20;
updateµôemp1ÖеIJ¿·ÖÊý¾Ý
update emp1
set sal = sal + 100,
comm = nvl(comm,0) + 50
È»ºóÎÒÃÇÊÔ×ÅʹÓÃemp1ÖÐÊý¾ÝÀ´¸üÐÂempÖÐsal ºÍ commÕâÁ½ÁÐÊý¾Ý¡£
ÎÒÃ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ