¡¶Oracle DBAÊּǡ· 24СʱСÑùµ½ÊÖ
×÷Õߣºeygle |English Version ¡¾×ªÔØÊ±ÇëÒÔ³¬Á´½ÓÐÎʽ±êÃ÷ÎÄÕ³ö´¦ºÍ×÷ÕßÐÅÏ¢¼°±¾ÉùÃ÷¡¿
Á´½Ó£ºhttp://www.eygle.com/archives/2010/01/oracle_dba_notebook.html
½ñÌ죬ÊÕµ½Á˳ö°æÉç¿ìµÝ¶øÀ´µÄ¡¶Oracle DBAÊּǡ·Ò»ÊéµÄ24СʱСÑù£¬Õâ¸öСÑùͨ¹ýÖ®ºó£¬Êé¾Í¿ÉÒÔ³ÉÅúÓ¡Ë¢£¬Ö¸ÈÕ¿É´ýÁË¡£×î¿ìµÄ¹À¼ÆÊÇÏÂÖÜ¿ÉÒÔÉÏÊÐÁË¡£
Äõ½Õâ±¾Êéʱ£¬ÐÄÀïµÄ¸Ð¾õÊÇÒìÑù¶øÐÀϲµÄ¡£ÖÜÀÏʦ˵Ëý·ÅÏÂÐÄÀ´£¬ÎÒµÄÐÄÈ´ÊÇÌø¶¯ÆðÀ´¡£
µ±ÎÒ¶ÁÁËÑîСÇÚ£¨²©ÎÄÊÓµãÉè¼Æ×ܼ࣬±¾ÊéÃÀ±à£©µÄÉè¼ÆË¼Â·Ê±£¬Ã÷°×ÁËÕâÖÖÒìÑùµÄÀ´Ô´¡£Õâ±¾ÊéµÄÃû×ÖÀïÓÐÊÖ¼ÇÁ½¸ö×Ö£¬ËùÒÔСÇÚ½«Êé±¾µÄÉè¼Æ´´Ò⳯×Å"¼Çʱ¡"µÄ·½Ïò·¢É¢£¬ÎÒÄÃÔÚÊÖÉϵÚÒ»¸öÒìÑùµÄ¸Ð¾õ¾ÍÊÇÓɴ˶øÀ´£º·Â·ðÊÇÒ»¸ö±Ê¼Ç±¾Ò»ÑùÊìϤ£¬Ã»ÓÐÊé±¾µÄÉúÓ²¡£
ÎÒϸϸÌåζÁËСÇÚµÄÉè¼ÆË¼Â·£¬Ïë²»µ½·âÃæµÄÿһ¸öÔªËØ¶¼ÊÇ×ÔÓÐÆäº¬ÒåµÄ¾«ÐÄ֮˼£¬Õâ¾ÍÊÇÉè¼Æ£¬ÎÒ´Ó²»ÊìϤµÄÁìÓòµÃµ½ÁËÉè¼ÆµÄÖʸкʹ¥ÊÖÄÇÒ»¿ÌÉè¼Æ¸øÎҵĶîÍâÌåÑé¡£
ÐÀϲÀ´×ÔÓÚÊé¼®µÄÅŰæÓëÓ¡Ë¢£¬ÇåÎú¡¢ÇåÐãµÄ°åʽ£¬´úÂëµÄ´¦Àí£¬Í¼Æ¬µÄÅÅÁУ¬ÉõÖÁÿ¸öÕ½ڵIJ¼¾Ö£¬¶¼ÊǾ«ÐÄÉè¼ÆµÄ£¬ÕâÒ»ÇÐÔ¶Ô¶³¬³öÎÒµÄÔ¤ÆÚ£¬KamusÔÙҲûÓÐÀíÓɳ°Ð¦ÎÒµÄÊé¶¼ÊÇ´òÓ¡°æµÄWordÎĵµÁË¡£ÄÇÒ»¿ÌµÄÐÀϲÈÃÎÒ²úÉúÁËÔÙдһ±¾ÊéµÄ³å¶¯£¬Èç¹ûÒ»±¾ÊéÄÜÏñÒÕÊõÆ·Ò»°ã¾«Ö£¬ÍêÈ«»á¼¤·¢×÷ÕߵĴ´ÔìÈÈÇé¡£
Õâ¾ÍÊÇÎÒÄõ½Õâ±¾ÑùÊéµÄÁ½¸ö¸Ð¾õ£¬¸Õ¸Õ×øÔÚɳ·¢ÉÏ£¬¶ÁÁËÀÏÑîµÄһƪÎÄÕ£¬Éî¸ÐÔĶÁµÄÀÖȤ¡£
ÏÖÔÚ£¬Õâ¸ö¼ÒÀïÒѾÓÐÕâÑùÒ»ÞûÊé±¾ÁË£º
¶¨ÏèÔÚÊéÄ©¼ÇÐðÁËÕâ±¾ÊéµÄµ®Éú¹ý³Ì£¬¶ÔÕÕÎÒÔÚǰÑÔÀïµÄÃèÊö£¬´ó¼Ò¿ÉÒÔÁ˽âÕâ±¾ÊéµÄǰÊÀ½ñÉú¡£¸Ðл²©ÎÄ´ó¼Ò»ïµÄÐÁ¿àÈÏÕæ£¬²ÅÓÐÁËÕâ±¾ÁîÎҸе½ÒìÑùºÍÐÀϲµÄÊé¡£
˵ʵ»°Õâ±¾ÊéµÄ³ö°æ¹ý³ÌÔø¾ÈÃÎҸе½Èß³¤£¬¶øÇÒ×îºóÔÚDeadlineʱ°Ñ²»ÉÙѹÁ¦Áô¸øÁËÎÒ£¬µ«ÊÇÏÖÔÚ¿´ÆðÀ´Ò»ÇÐŬÁ¦¶¼ÊÇÖµµÃµÄ¡£
×öÒ»±¾¶ÔµÃÆð¶ÁÕßµÄÊ飬³ö°æÉçÒѾÍê³ÉÁËËûÃǵÄÖ°Ôð£¬Ê£ÏµľÍÊÇÊé±¾µÄÄÚÈÝÁË£¬Õ⣬Ҫ¿¿ÎÒÃÇÎå¸öÐÖµÜÈ¥½ÓÊܶÁÕߵļìÑé¡£Ok£¬We are Ready£¡
-The End-
Ïà¹ØÎĵµ£º
Ò»¸öʵÀý¿ÉÒÔÓжà¸öºǫ́½ø³Ì,µ«ÊÇ£¬²¢²»ÊÇÿһ¸öºǫ́½ø³Ì¶¼»á³ö³ö£¬Í¨¹ýÊÓͼ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
......
ÔÚORACLEÊý¾Ý¿âÖÐ,ÐèÒª¶ÔSQLÓï¾ä½øÐÐÓÅ»¯µÄ»°ÐèÒªÖªµÀÆäÖ´Ðмƻ®,´Ó¶øÕë¶ÔÐԵĽøÐе÷Õû.ORACLEµÄÖ´Ðмƻ®µÄ»ñµÃÓм¸ÖÖ·½·¨,ÏÂÃæ¾ÍÀ´×ܽáÏÂ
1¡¢EXPLAINµÄʹÓÃ
Oracle RDBMSÖ´ÐÐÿһÌõSQLÓï¾ä£¬¶¼±ØÐë¾¹ýOracleÓÅ»¯Æ÷µÄÆÀ¹À¡£ËùÒÔ£¬Á˽âÓÅ»¯Æ÷ÊÇÈçºÎÑ¡Ôñ(ËÑË÷)·¾¶ÒÔ¼°Ë÷ÒýÊÇÈçºÎ±»Ê¹Óõ쬶ÔÓÅ»¯SQLÓï ......