Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)

ORACLE±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)
2007Äê11ÔÂ02ÈÕ ÐÇÆÚÎå 16:03
¸ÅÒª
1¡¢Á˽âʲôÊDZ¸·Ý
2¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
3¡¢Àí½âÊý¾Ý¿âµÄÁ½ÖÖÔËÐз½Ê½
4¡¢Àí½â²»Í¬µÄ±¸·Ý·½Ê½¼°ÆäÇø±ð
5¡¢Á˽âÕýÈ·µÄ±¸·Ý²ßÂÔ¼°ÆäºÃ´¦
  
Ò»¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
¿ÉÒÔ˵£¬´Ó¼ÆËã»úϵͳ³öÊÀµÄÄÇÌìÆð£¬¾ÍÓÐÁ˱¸·ÝÕâ¸ö¸ÅÄ ......

Oracle ListenerµÄTNS 12502´íÎó

ÿ¸ô¼¸ÃëÖÓlistenerÈÕÖ¾ÖоͳöÏÖÒ»´Î¸Ã´íÎóµÄ¼Ç¼£¬¼´Ê¹ÊÇÔÚûÓÐÈËʹÓõÄÇé¿öÏÂÒ²ÊÇÈç´Ë£¬²»¹ý²¢Ã»Óз¢ÏÖ¿Í»§¶Ë»úÆ÷²»ÄÜÕý³£Á¬½ÓÊý¾Ý¿âµÄÇé¿ö¡£
   Oracle¹ØÓÚTNS-12502´íÎóµÄ½âÊÍ:
Error: ORA-12502 / TNS-12502
Text: TNS:listener received no CONNECT_DATA from client
Cause: No CONNECT_DATA was ......

oracle exists and not exist


ÏÈ¿´ÏÂÃæµÄÀý×Ó:oracleÖÐÁ½¸öϵͳ±í.emp,dept.
example:
1:not exists(not in)
not exists:
   ÕâÌõÓï¾ä·µ»Øselect * from scott.dept d where e.deptno=d.deptno and d.deptno=10Ìõ¼þÂú×ãµÄ½á¹û¼¯.Ò²¾ÍÊÇ˵,
·µ»ØµÄ½á¹û¼¯Öв»´æÔÚd.deptno=10½á¹û¼¯µÄ¼Ç¼,¼´emp±íÖÐûÓÐdept±íÖÐd.deptno=10µÄ¼Ç¼.
SQL& ......

Èç¹û»ñÈ¡ÄãÃÎÏëµÄ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 LOGMINERʹÓüòµ¥²½Öè

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