¡¶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)
2007Äê11ÔÂ02ÈÕ ÐÇÆÚÎå 16:03
¸ÅÒª
1¡¢Á˽âʲôÊDZ¸·Ý
2¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
3¡¢Àí½âÊý¾Ý¿âµÄÁ½ÖÖÔËÐз½Ê½
4¡¢Àí½â²»Í¬µÄ±¸·Ý·½Ê½¼°ÆäÇø±ð
5¡¢Á˽âÕýÈ·µÄ±¸·Ý²ßÂÔ¼°ÆäºÃ´¦
Ò»¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
¿ÉÒÔ˵£¬´Ó¼ÆËã»úϵͳ³öÊÀµÄÄÇÌìÆð£¬¾ÍÓÐÁ˱¸·ÝÕâ¸ö¸ÅÄ ......
Oracle Îï¼þµÄÃüÃûÏÞÖÆ
ÈκÎÎï¼þµÄÃû稱²»µÃ³¬過 30 λԪ(Bytes)
Oracle µÄ dummy query 寫·¨
SELECT SYSDATE from dual
Oracle 選È¡²¿·Ö資Áϵķ½·¨
SELECT * from table WHERE ROWNUM<10; /* È¡³öǰ 10 筆 */
實現 Oracle ÉϵķÖ頁顯ʾ [¾«華] ......
Ï൱ÓÚalias(±ðÃû),±ÈÈç°Ñuser1.table1ÔÚuser2Öн¨Ò»¸öͬÒå´Êtable1
create synonym table1 for user1.table1;
ÕâÑùµ±ÄãÔÚuser2Öвéselect * from table1ʱ¾ÍÏ൱ÓÚ²éselect * from user1.table1;
Óŵã×Ô¼º×ܽá°É¡£
ÀýÈ磺
ÔÚoracleÖжÔÓû§µÄ¹ÜÀíÊÇʹÓÃȨÏ޵ķ½Ê½À´¹ÜÀíµÄ£¬Ò²¾ÍÊÇ˵£¬Èç¹ûÎÒÃÇÏëʹÓÃÊý¾Ý¿â£¬ÎÒà ......
¹ØÓÚ°²×°£º
°²×°Oracle10gʱ£¬ËùÊäÈëµÄÈ«¾ÖµÄSIDÃû³ÆÎªtest(¼´Êý¾Ý¿âÃû£¬²»ÄÜ×÷ΪÓû§ÃûÀ´µÇ¼)£¬ÃÜÂëΪtest(¸ÃÃÜÂë¶ÔÓ¦µÄÓû§Îªsystem£¬sysµÈ)¡£
×°Íêºó£¬Èô´ÓÍøÒ³ÉϵǼoracle£¬ÔòÊäÈëurl£ºhttp://localhost:1158/em
ÈôÎÞ·¨ÏÔ ......
Author: rainnyzhong
Date:2010-1-15
1£® Ö¢×´ÃèÊö£º
FALB12´ÓEXCEL IMPORT DATAµ½DB£¬Ô¤¼ÆÊÂÎñ»áÔËÐÐ1¸ö¶àСʱ£¬ÔÚ¿ªÊ¼²Ù×÷ºó40·ÖÖÓ×óÓÒ£¬ORACLE¹ÒËÀ£¬ÈκÎÓû§¶¼²»¿ÉÒÔÔٵǽÁË¡£
2£® ·ÖÎö
£¨1£© ÏÂÃæÊǹÒËÀʱOSµÄ×ÊÔ´×´¿ö£º
09:37:54 up 73 ......