Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

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

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

¹ØÓÚoracle 10gµÄsqlplus

ÏÖÔÚÎÒ±¾µØûÓа²×°oracle, µ«plsqldevÐèÒªsqlplus.exeµÈ£¬ÇëÎÊoracle10gÔÚwindowsÐèÒª
ÄÄЩexeÎļþ£¬ÄÄλ´ó¸çÄÜ˳±ãÌṩһÏÂQQ£º190565390

×°oracleµÄʱºò¿ÉÒÔÑ¡ÔñÖ»×°¿Í»§¶ËµÄ

×îÆðÂëҪװoracle£¬ÄãÖ»Ðè×°¿ ......

´óÁ¬ÄļÒoracleÅàѵºÃ

Ï뿼¸öocpÈÏÖ¤£¬µ±È»£¬Ò²ÏëºÃºÃѧµã¶«Î÷¡£
¿ÉÒÔ×ÔѧµÄ£¡

¸öÈ˾õµÃÖ»ÒªÕÆÎÕÁËÊý¾Ý¿âµÄ»ù±¾ÀíÂÛ£¬Âò²Î¿¼Êé×Ôѧ±È½Ïʵ¼Êµã£¬
ÌرðÊÇÅàѵ̫¹ó²¢ÇÒ²»¿ÉÄÜѧµ½ºÜ¶à¶«Î÷£¡


Êý¾Ý¿âÊǸö³¤ÆÚµÄѧϰ¹ý³Ì£¬Â¥Ö÷¿ÉÒÔÂý ......

oracleÄÚ´æÕ¼Óò»¶ÏÔö³¤ÎÊÌâ

Çë½Ì£ºoracleÊý¾Ý¿â½ø³ÌÕ¼ÓÃÒ»Ö±²»¶ÏÉÏÕÇ£¬´óÔ¼20¶àÌìºó£¬¾Í»áµ¼ÖÂϵͳÐéÄâÄÚ´æ²»×㣬Á¬½Ó¶Ïµô£¬ÇëÎÊÔõô»áÊ£¿
Ö»ÓÐÖØÆô·þÎñÆ÷²Å¿ÉÒÔÔÙÕý³£ÔËÐУ¬ÖÜÆÚÐÔ³öÏÖÐéÄâÄÚ´æ²»×ãÏÖÏó£¡
¼±£¡£¡£¡£¡ÏȸÐл´Í½Ì£¡
which os ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ