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
Ïà¹ØÎĵµ£º
Ò»¸öʵÀý¿ÉÒÔÓжà¸öºǫ́½ø³Ì,µ«ÊÇ£¬²¢²»ÊÇÿһ¸öºǫ́½ø³Ì¶¼»á³ö³ö£¬Í¨¹ýÊÓͼv$bgprocess¿ÉÒԲ鿴ºǫ́½ø³ÌÐÅÏ¢¡£
Ò»°ãÎÒÃÇÊÇͨ¹ýÒÔÏÂsql²é¿´ºǫ́±ØÐëµÄºǫ́½ø³Ì.
1.²é¿´ºǫ́½ø³Ì
select paddr,name,description
from v$bgprocess
order by paddr desc
£»
2.Õâ¸öÊÓͼÖÐpaddr<>'00'µÄÐж¼ÊÇϵͳÉÏÅäÖúÍÔËÐеĽø³ ......
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 ......
¶¨Ò壺escape¹Ø¼ü×Ö¾³£ÓÃÓÚÊ¹Ä³Ð©ÌØÊâ×Ö·û£¬ÈçͨÅä·û£º'%','_'תÒåΪËüÃÇÔ
À´µÄ×Ö·ûµÄÒâÒ壬±»¶¨ÒåµÄתÒå×Ö·ûͨ³£Ê¹ÓÃ'\',µ«ÊÇÒ²¿ÉÒÔʹÓÃÆäËûµÄ·ûºÅ¡£
ʵÀý£º
SQL> select * from t11 where name like '%_%';
NAME
----------
aa_a
aaa
SQL> select * from t11 where name like '%\_%' escape '\';
NAME
......
±¾ÉíÕâ¸ö²½ÖèºÜ¶à¸ßÊÖ¶¼ÒѾÌù¹ýÁË£¬Ö»ÊÇÎÒÔÚʹÓÃÖз¢ÏÖ´óÌåÉÏ´ó¼ÒдµÄ¶¼ÓÐЩ¸´ÔÓ£¬ÓÚÊÇ£¬ÎÒ×ܽáÁ˸ö³¬¼¶¼ò»¯°æµÄ£¬·½±ã´ó¼ÒʹÓãº
1.°²×°LOGMNR°ü£¬ÐèÒª±¾²½Öèûʲô¿É¶à˵µÄ£¬Ö»ÊÇÐèҪעÒâÔÚÁ¬½ÓÊý¾Ý¿âµÄʱºòĬÈÏ×îºÃʹÓñ¾µØÑéÖ¤·½Ê½
C:\>sqlplus /nolog
SQL> conn / as sysdba
SQL> @D:\oracle\product\10 ......
ÔÚORACLEÊý¾Ý¿âÖÐ,ÐèÒª¶ÔSQLÓï¾ä½øÐÐÓÅ»¯µÄ»°ÐèÒªÖªµÀÆäÖ´Ðмƻ®,´Ó¶øÕë¶ÔÐԵĽøÐе÷Õû.ORACLEµÄÖ´Ðмƻ®µÄ»ñµÃÓм¸ÖÖ·½·¨,ÏÂÃæ¾ÍÀ´×ܽáÏÂ
1¡¢EXPLAINµÄʹÓÃ
Oracle RDBMSÖ´ÐÐÿһÌõSQLÓï¾ä£¬¶¼±ØÐë¾¹ýOracleÓÅ»¯Æ÷µÄÆÀ¹À¡£ËùÒÔ£¬Á˽âÓÅ»¯Æ÷ÊÇÈçºÎÑ¡Ôñ(ËÑË÷)·¾¶ÒÔ¼°Ë÷ÒýÊÇÈçºÎ±»Ê¹Óõ쬶ÔÓÅ»¯SQLÓï ......