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

oracle 10g°²×°µ½85%ʱ±¨´í

¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿

ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..

ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿

ÄãÔÙÖØÐ°²×°ÊÔÊÔ ±¨µÄÊÇʲô´íÎó£¿ ÊDz»ÊÇ֮ǰװ¹ý£¿

http://topic.csdn.net/u/20090626/11/ece71a6b-fae4-4860-8e6d-4345ae9aac83.html

ÔÚ°²×°¿ªÊ¼Ê±£¬OracleÒª¶Ôϵͳ½øÐмì²âÓÐÍø¿¨µÄÑ¡Ïîûͨ¹ý¼ìÑ飬ÓÚÊÇÎÒÊÖ¹¤¶Ô¸ÃÏî´òÁË¡Ì £¬ÏÔʾÒÑÅäÖã¬ÕâÑù±ã¿ªÊ¼ÁËËùνµÄÕý³£°²×°¡£ 

»òÕß
ÉèÖá°Microsoft LoopBack Adapter ÅäÖÃΪϵͳµÄÖ÷ÍøÂçÊÊÅäÆ÷¡±£¬ÓÚÊÇÎÒ¾ÍÊÖ¹¤¼ÓÁËÒ»¸ö£¬¾ßÌå·½·¨Ï£º 
   
  ´ò¿ª¡°¿ØÖÆÃæ°å¡±£¬Ë«»÷¡°Ìí¼ÓÓ²¼þ¡±Í¼±ê£¬ÔÚ¡°Ìí¼ÓÓ²¼þÏòµ¼¡±Öе¥»÷¡°ÏÂÒ»²½¡±°´Å¥£¬¸ÃÏòµ¼»áËÑË÷×î½üÁ¬½Óµ½¼ÆËã»úµ«ÉÐδ°²×°µÄÐÂÓ²¼þ¡£ÓÉÓÚÎÒÃDz¢Ã»ÓÐÕæÕýΪ¼ÆËã»úÁ¬½ÓеÄÓ²¼þ£¬ËùÒÔϵͳµ±È»ÎÞ·¨ÕÒµ½ÐÂÓ²¼þ£¬Òò´Ë»áµ¯³öÒ»¸öѯÎÊÓ²¼þÊÇ·ñÒѰ²×°µÄ¶Ô»°¿ò£¬ÔڸöԻ°¿òÖÐÑ¡Ôñ¡°ÊÇ£¬ÎÒÒѾ­Á¬½ÓÁË´ËÓ²¼þ¡±£¬µ¥»÷ ¡°ÏÂÒ»²½¡±°´Å¥¡£ 

1¡¢ÔÚ³öÏֵġ°ÒѰ²×°µÄÓ²¼þ¡±ÁбíÖУ¬Ñ¡Ôñ×îºóÒ»Ïî¡°Ìí¼ÓеÄÓ²¼þÉ豸¡±£¬µ¥»÷¡°ÏÂÒ»²½¡±°´Å¥¼ÌÐø¡£ 

2¡¢ÔÚ½ÓÏÂÀ´µ¯³öµÄ¶Ô»°¿òÖУ¬Ñ¡Ôñ¡°°²×°ÎÒÊÖ¶¯´ÓÁбíÖÐÑ¡ÔñµÄÓ²¼þ¡±£¬µ¥»÷¡°ÏÂÒ»²½¡±°´Å¥£¬ÔÚ³öÏÖµÄÓ²¼þÁбíÖÐÑ¡Ôñ¡°ÍøÂçÊÊÅäÆ÷¡±£¬µ¥»÷¡°ÏÂÒ»²½¡±°´Å¥¡£ 

3¡¢ÔÚÑ¡ÔñÍø¿¨¶Ô»°¿òÖУ¬¡°³§ÉÌ¡±Ñ¡Ôñ¡°Microsoft¡±£¬¡°Íø¿¨¡±Ñ¡Ôñ¡°Microsoft Loopback Adapter¡±£¬µ¥»÷¡°ÏÂÒ»²½¡±°´Å¥¼´¿É¿ªÊ¼°²×°£¬×îºóµ¥»÷¡°Íê³É¡±°´Å¥¡£ 


Ïà¹ØÎÊ´ð£º

ÊÇoracleµÄbugô£¿É¢·ÖÁË£¡ - Oracle / »ù´¡ºÍ¹ÜÀí

±¾À´ÒªÐ´¸öupdateÓï¾ä
update table_a A
  set A.flag=1
  where A.id in (select B.id from table_b B)
½á¹ûÎóд³É
update table_a A
  set A.flag=1
  where ......

OracleÊý¾Ý¿âÔ½À´Ô½Âý¸ÃÈçºÎ´¦Àí£¿

Êý¾Ý¿â£ºOracle10g(10.2)
Ó¦ÓãºÒ»¸öC#µÄ³ÌÐòдÊý¾Ý¿â£¬Ò»¸öJSP³ÌÐò¶ÁÊý¾Ý¿â
¸ºÔØ£ºÄ¿Ç°´¦ÓÚ¿ª·¢½×¶Î£¬»ù±¾ÉÏÖ»ÓÐ3-4¸öÓû§·ÃÎÊJSPÍøÕ¾¡£
ÏÖÏó£ºÖØÐÂÆô¶¯ºóµÄÊý¾Ý¿â²éѯ·Ç³£¿ì£¬µ«ÊÇÓÃ×ÅÓÃ×ÅÔ½À´Ô½Âý£¬ËùÓÐJSPÍøÒ ......

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

Ë­ÄÜÍÆ¼ö¼¸±¾oracleµÄÊé»òÊÓÆµ - Oracle / ·Ç¼¼ÊõÇø

лл
ÎÒÒ²ÊÇÏëÖªµÀ

me too

ÎÒ Ò² Ïë Öª µÀ Æä Ëû µÄ£¬ÎÒ ÏÖ ÔÚ ¾Í ÔÚ Ñ§ orcale Êý ¾Ý ¿â£¬ÎÒ 
Óà µÄ ÊÇ ÕÔ Ôª ½Ü ±à µÄ.......

¸öÈ˾õµÃÔ­ÀíÐԵĶ«Î÷¿´Ò»Ð©¹Ù·½Îĵµ¿ÉÄÜ»áºÃһЩ Èç¹ûûÓÐÀÏʦ½Ì ......

oracleÊý¾Ý¿âµÄÃû×ÖÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒÔÚ´´½¨Êý¾Ý¿âµÄʱºòÓõÄÃû×ÖΪoracle10£¬µ«ÊÇ´´½¨ºÃºó£¬ÔÚĬÈϵÄĿ¼ÏÂÏÔʾµÄÃû³ÆÈ´ÊÇoracle10g£¬ÕâÊÇΪʲô£¿
Äã¿´µÄ 10gÊǰ²×°Ä¿Â¼°É 

SQL> select name from v$database;
NAME
---------
ORCL ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ