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

Windows7»·¾³ÏÂÈçºÎ³É¹¦°²×°OracleÊý¾Ý¿â

    Ëæ×Å΢ÈíÐÂÒ»´ú²Ù×÷ϵͳ Windows7 µÄÕýʽ·¢ÐУ¬Ê¹Óà Windows7  µÄÅóÓÑÒ²Ô½À´Ô½¶à£¬ºÜ¶àÈËÔÚ Windows7 »·¾³Ï°²×° Oracle »ò¶à»òÉÙÓöµ½ÁËһЩÎÊÌ⣬ÓеÄÉõÖÁ·¢³ö“Windows7ÎÞ·¨°²×°Oracle”µÄ¸Ð¿®¡£½ñÌì±ÊÕß½áºÏͼÎĺʹó¼Ò·ÖÏíÒ»ÏÂÔÚWindows7»·¾³ÏÂÈçºÎ³É¹¦°²×°OracleÊý¾Ý¿â¡£
    ±ÊÕßÑо¿·¢ÏÖ£ºÔÚWindows7ϲ»Äܳɹ¦°²×°Oracle£¬¾¿ÆäÔ­ÒòÎÞ·ÇÊÇÒòΪͨ¹ý²»ÁËOracle°²×°³ÌÐòµÄÏȾöÐÔ¼ì²é£¬»òÊÇ“¿Í»§¶Ë²»Ö§³Ö°æ±¾ºÅΪ6.1µÄWindows 7²Ù×÷ϵͳ”£¬»òÊǓûÓн« Microsoft LoopBack Adapter ÅäÖÃΪϵͳµÄÖ÷ÍøÂçÊÊÅäÆ÷”£¬Õë¶ÔÕâÁ½ÖÖÇé¿ö£¬±ÊÕßÒ»Ò»ÓèÒÔ½â´ð¡£
    ÏêÇéÇë²éÔıÊÕßµÄͼÎĽ̳̣º¡¶Windows7»·¾³ÏÂÈçºÎ³É¹¦°²×°OracleÊý¾Ý¿â¡·


Ïà¹ØÎĵµ£º

Oracle Hang Analysis

Author: rainnyzhong
Date:2010-1-15
 
1£®  Ö¢×´ÃèÊö£º
FALB12´ÓEXCEL IMPORT DATAµ½DB£¬Ô¤¼ÆÊÂÎñ»áÔËÐÐ1¸ö¶àСʱ£¬ÔÚ¿ªÊ¼²Ù×÷ºó40·ÖÖÓ×óÓÒ£¬ORACLE¹ÒËÀ£¬ÈκÎÓû§¶¼²»¿ÉÒÔÔٵǽÁË¡£
2£®  ·ÖÎö
£¨1£©        ÏÂÃæÊǹÒËÀʱOSµÄ×ÊÔ´×´¿ö£º
09:37:54  up 73 ......

Oracle ·ÖÎöº¯Êý·Ö×éÀÛ¼Ó£¡

Óû§ºÅÂë µÇ½ʱ¼ä
1300000000 2010-01-01
1300000001 2010-01-01
1300000002 2010-01-02
1300000001 2010-01-02
1300000003 2010-01-03
1300000002 2010-01-03
1300000004 2010-01-04
1300000003 2010-01-04
1300000004 2010-01-02
1300000006 2011-01-04
1300000001 2011-01-04
 ÌÞ³ýÖØ¸´µ ......

ORACLE LOGMINERʹÓüòµ¥²½Öè

±¾ÉíÕâ¸ö²½ÖèºÜ¶à¸ßÊÖ¶¼ÒѾ­Ìù¹ýÁË£¬Ö»ÊÇÎÒÔÚʹÓÃÖз¢ÏÖ´óÌåÉÏ´ó¼ÒдµÄ¶¼ÓÐЩ¸´ÔÓ£¬ÓÚÊÇ£¬ÎÒ×ܽáÁ˸ö³¬¼¶¼ò»¯°æµÄ£¬·½±ã´ó¼ÒʹÓãº
1.°²×°LOGMNR°ü£¬ÐèÒª±¾²½Öèûʲô¿É¶à˵µÄ£¬Ö»ÊÇÐèҪעÒâÔÚÁ¬½ÓÊý¾Ý¿âµÄʱºòĬÈÏ×îºÃʹÓñ¾µØÑéÖ¤·½Ê½
C:\>sqlplus /nolog
SQL> conn / as sysdba
SQL> @D:\oracle\product\10 ......

ORACLE dblink С¼Ç

½¨DBLINK:
ʹÓÃpl/sql developer½¨£ºÕÒµ½Database Links,ÓÒ¼üн¨
                          Ãû³Æ£ºdblinkÃû  Á¬½Óµ½Óû§Ãû£ºÄ¿±êÊý¾Ý¿âµÇ¼Ãû ÃÜÂ룺Ŀ±êÊý¾Ý¿âÃÜÂë
   ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ