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)
2007Äê11ÔÂ02ÈÕ ÐÇÆÚÎå 16:03
¸ÅÒª
1¡¢Á˽âʲôÊDZ¸·Ý
2¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
3¡¢Àí½âÊý¾Ý¿âµÄÁ½ÖÖÔËÐз½Ê½
4¡¢Àí½â²»Í¬µÄ±¸·Ý·½Ê½¼°ÆäÇø±ð
5¡¢Á˽âÕýÈ·µÄ±¸·Ý²ßÂÔ¼°ÆäºÃ´¦
Ò»¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
¿ÉÒÔ˵£¬´Ó¼ÆËã»úϵͳ³öÊÀµÄÄÇÌìÆð£¬¾ÍÓÐÁ˱¸·ÝÕâ¸ö¸ÅÄ ......
ÿ¸ô¼¸ÃëÖÓlistenerÈÕÖ¾ÖоͳöÏÖÒ»´Î¸Ã´íÎóµÄ¼Ç¼£¬¼´Ê¹ÊÇÔÚûÓÐÈËʹÓõÄÇé¿öÏÂÒ²ÊÇÈç´Ë£¬²»¹ý²¢Ã»Óз¢ÏÖ¿Í»§¶Ë»úÆ÷²»ÄÜÕý³£Á¬½ÓÊý¾Ý¿âµÄÇé¿ö¡£
Oracle¹ØÓÚTNS-12502´íÎóµÄ½âÊÍ:
Error: ORA-12502 / TNS-12502
Text: TNS:listener received no CONNECT_DATA from client
Cause: No CONNECT_DATA was ......
ÏÈ¿´ÏÂÃæµÄÀý×Ó: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& ......
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 ......
±¾ÉíÕâ¸ö²½ÖèºÜ¶à¸ßÊÖ¶¼ÒѾÌù¹ýÁË£¬Ö»ÊÇÎÒÔÚʹÓÃÖз¢ÏÖ´óÌåÉÏ´ó¼ÒдµÄ¶¼ÓÐЩ¸´ÔÓ£¬ÓÚÊÇ£¬ÎÒ×ܽáÁ˸ö³¬¼¶¼ò»¯°æµÄ£¬·½±ã´ó¼ÒʹÓãº
1.°²×°LOGMNR°ü£¬ÐèÒª±¾²½Öèûʲô¿É¶à˵µÄ£¬Ö»ÊÇÐèҪעÒâÔÚÁ¬½ÓÊý¾Ý¿âµÄʱºòĬÈÏ×îºÃʹÓñ¾µØÑéÖ¤·½Ê½
C:\>sqlplus /nolog
SQL> conn / as sysdba
SQL> @D:\oracle\product\10 ......