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

¡¶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-


Ïà¹ØÎĵµ£º

ORACLE±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)

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

oracleµÄÄÚ´æ½á¹¹

Êý¾Ý¿âµÄÄÚ´æ½á¹¹£º
    Memory structures are allocated to the Oracle instance when the instance is started.
The two major memory structures are known as the System Global Area(Also called the shared
Global Area)and the Program Global Area(also called the Private Global Area or the ......

Èç¹û»ñÈ¡ÄãÃÎÏëµÄ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 ......

ORACLE EXPLAIN PLANµÄ×ܽá

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