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

oracleÈçºÎ²éѯºÍÍ£Ö¹ÕýÔÚÔËÐеÄjob

Ô­ÎĵØÖ·£º
http://blog.sina.com.cn/s/blog_60e4205e0100esaf.html
ÕÒ³öÕýÔÚÖ´ÐеÄJOB±àºÅ¼°Æä»á»°±àºÅ   
SELECT   SID,JOB   from
  DBA_JOBS_RUNNING;  
Í£Ö¹¸ÃJOBµÄÖ´ÐР  
SELECT   SID,SERIAL#   from
  V$SESSION   WHERE   SID='&SID';   
ALTER
  SYSTEM   KILL   SESSION  
'&SID,&SERIAL';   
EXEC  
DBMS_JOB.BROKEN(&JOB,TRUE);
ʵÀý·ÖÎö£º
1£¬²éѯÕýÔÚÔËÐеÄJob£¬Í¨¹ý²éѯÓÐÁ½¸ö£¬ºÍ½ø³ÌÕ¼Óý϶àµÄÊÇÁ½¸öORACLE½ø³Ì·ûºÏ¡£
SQL> SELECT   SID,JOB   from  
DBA_JOBS_RUNNING;
      
SID        JOB
----------
----------
       
12       
116
       
16        117
2£¬²éѯÕýÔÚÔËÐеÄjobµÄÐÅÏ¢
SQL>  SELECT   SID,SERIAL#   from  
V$SESSION   WHERE   SID='12';
       SID   
SERIAL#
---------- ----------
       
12          4
SQL> SELECT   SID,SERIAL#   from  
V$SESSION   WHERE   SID='16';
       SID   
SERIAL#
---------- ----------
       
16          1
3£¬ÀûÓòéѯ³öÀ´µÄjobÐÅÏ¢½«job½áÊøµô
SQL> ALTER   SYSTEM   KILL   SESSION
'12,4';
System altered.
SQL> ALTER   SYSTEM   KILL   SESSION
'16,1';
System altered.
4£¬Èç¹û²»Ï£ÍûÔËÐÐÉÏÊöjobµÄ»°£¬¿ÉÒÔ½«jobÉèÖÃΪbroken.
EXEC   DBMS_JOB.BROKEN(116,TRUE);
EXEC   DBMS_JOB.BROKEN(117,TRUE


Ïà¹ØÎĵµ£º

oracle ºǫ́½ø³Ì

Ò»¸öʵÀý¿ÉÒÔÓжà¸öºǫ́½ø³Ì,µ«ÊÇ£¬²¢²»ÊÇÿһ¸öºǫ́½ø³Ì¶¼»á³ö³ö£¬Í¨¹ýÊÓͼv$bgprocess¿ÉÒԲ鿴ºǫ́½ø³ÌÐÅÏ¢¡£
Ò»°ãÎÒÃÇÊÇͨ¹ýÒÔÏÂsql²é¿´ºǫ́±ØÐëµÄºǫ́½ø³Ì.
1.²é¿´ºǫ́½ø³Ì
select paddr,name,description
from v$bgprocess
order by paddr desc
£»
2.Õâ¸öÊÓͼÖÐpaddr<>'00'µÄÐж¼ÊÇϵͳÉÏÅäÖúÍÔËÐеĽø³ ......

Èç¹û»ñÈ¡ÄãÃÎÏëµÄOracle DBAְλ


How to land your dream Oracle DBA job
By Don Burleson, Contributor
14 Jan 2010
If you look at the Help Wanted ads, some Oracle DBA jobs look very appealing, with salaries that rival those of engineers and other professionals. Some have starting salaries as high as $85,000, with senior Orac ......

oracleµÄescapeתÒå×Ö·û

¶¨Ò壺escape¹Ø¼ü×Ö¾­³£ÓÃÓÚÊ¹Ä³Ð©ÌØÊâ×Ö·û£¬ÈçͨÅä·û£º'%','_'תÒåΪËüÃÇÔ­
À´µÄ×Ö·ûµÄÒâÒ壬±»¶¨ÒåµÄתÒå×Ö·ûͨ³£Ê¹ÓÃ'\',µ«ÊÇÒ²¿ÉÒÔʹÓÃÆäËûµÄ·ûºÅ¡£
ʵÀý£º
SQL> select * from t11 where name like '%_%';
NAME
----------
aa_a
aaa
SQL> select * from t11 where name like '%\_%' escape '\';
NAME
......

ORACLE LOGMINERʹÓüòµ¥²½Öè

±¾ÉíÕâ¸ö²½ÖèºÜ¶à¸ßÊÖ¶¼ÒѾ­Ìù¹ýÁË£¬Ö»ÊÇÎÒÔÚʹÓÃÖз¢ÏÖ´óÌåÉÏ´ó¼ÒдµÄ¶¼ÓÐЩ¸´ÔÓ£¬ÓÚÊÇ£¬ÎÒ×ܽáÁ˸ö³¬¼¶¼ò»¯°æµÄ£¬·½±ã´ó¼ÒʹÓãº
1.°²×°LOGMNR°ü£¬ÐèÒª±¾²½Öèûʲô¿É¶à˵µÄ£¬Ö»ÊÇÐèҪעÒâÔÚÁ¬½ÓÊý¾Ý¿âµÄʱºòĬÈÏ×îºÃʹÓñ¾µØÑéÖ¤·½Ê½
C:\>sqlplus /nolog
SQL> conn / as sysdba
SQL> @D:\oracle\product\10 ......

ORACLE EXPLAIN PLANµÄ×ܽá

ÔÚORACLEÊý¾Ý¿âÖÐ,ÐèÒª¶ÔSQLÓï¾ä½øÐÐÓÅ»¯µÄ»°ÐèÒªÖªµÀÆäÖ´Ðмƻ®,´Ó¶øÕë¶ÔÐԵĽøÐе÷Õû.ORACLEµÄÖ´Ðмƻ®µÄ»ñµÃÓм¸ÖÖ·½·¨,ÏÂÃæ¾ÍÀ´×ܽáÏÂ
1¡¢EXPLAINµÄʹÓÃ
    Oracle RDBMSÖ´ÐÐÿһÌõSQLÓï¾ä£¬¶¼±ØÐë¾­¹ýOracleÓÅ»¯Æ÷µÄÆÀ¹À¡£ËùÒÔ£¬Á˽âÓÅ»¯Æ÷ÊÇÈçºÎÑ¡Ôñ(ËÑË÷)·¾¶ÒÔ¼°Ë÷ÒýÊÇÈçºÎ±»Ê¹Óõ쬶ÔÓÅ»¯SQLÓï ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ