100·ÖÇó½âoracleÓйصÄ5¸öÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ
ÈçÌâ:
1.ÈçºÎ²é¿´ºÍµ÷ÕûÊý¾Ý¿âµÄ×î´óÁ¬½ÓÊý£¿
2.linuxϲ鿴alert log?
3.ÔÚ×Ô¶¨ÒåµÄÀàÐͺóÃæ¼ÓÉÏindex by pls_integer ±íÊÇʲôÒâ˼£¿
4.oracleÖÐ×ÔÖÎÊÂÎñpragma autonomous_transaction µÄÀí½â£¿
5.Õâ¾ä»°ÔõôÀí½â£º
Èç¹ûijһ²Ù×÷°üº¬´óÁ¿µÄSQL´úÂë»ò·Ö±ð±»¶à´ÎÖ´ÐУ¬ÄÇô´æ´¢¹ý³ÌÒª±ÈÅú´¦ÀíµÄÖ´ÐÐËÙ¶È¿ìºÜ¶à¡£ÒòΪ´æ´¢¹ý³ÌÊÇ
Ô¤±àÒëµÄ£¬ÔÚÊ״α»ÔËÐÐÒ»¸ö´æ´¢¹ý³Ìʱ£¬²éѯÓÅ»¯Æ÷¶ÔÆä½øÐзÖÎöÓÅ»¯£¬²¢¸ø³ö×îÖÕ±»´æÔÚϵͳ±íÖеÄÖ´Ðмƻ®¡£
¶øÅú´¦ÀíµÄSQLÓï¾äÔÚÿ´ÎÔËÐÐʱ¶¼Òª½øÐбàÒëºÍÓÅ»¯£¬Òò´ËËÙ¶ÈÏà¶ÔÒªÂýһЩ¡£
4. ×ÔÖÎÊÂÎñ£¬Ï൱ÓÚ¿ªÆôÁËÁíÒ»¸ö¶ÀÁ¢µÄÊÂÎñ£¬Õâ¸öÊÂÎñ²»ÊÜÖ÷ÊÂÎñµÄ¿ØÖÆ
5.
¶øÅú´¦ÀíµÄSQLÓï¾äÔÚÿ´ÎÔËÐÐʱ¶¼Òª½øÐбàÒëºÍÓÅ»¯£¬Òò´ËËÙ¶ÈÏà¶ÔÒªÂýһЩ¡£
Õâ¸ö˵·¨ÊDz»¶ÔµÄ£¬Ç°¶ËÓ¦Óõ÷ÓÃÊý¾Ý¿âʱ¶¼ÓÐÀàËÆprepare()µÄ·½·¨£¬µ÷ÓÃÕâ¸ö·½·¨ºóÔÙ·´¸´Ö´ÐУ¬Ð§Âʸú´æ´¢¹ý³ÌÊÇÒ»ÑùµÄ¡£
ͬÒâÂ¥Éϵģ¬oracleûÄÇôÈõÖÇ£¬shared pool¾ÍÊÇÓÃÀ´´æ·Å½âÎö ¹ýµÄSQLÓï¾äµÄ¡£½ö½öÊÇ´ËSQLµÚÒ»´ÎÖ´ÐÐʱ´æ´¢¹ý³Ì±ÈÅú´¦Àí¿ì¡£µÚ¶þ´Î¡¢µÚÈý´Î¡£¡£¡£¾ÍÃ»Çø±ðÁË¡£
{{
Ïà¹ØÎÊ´ð£º
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨
ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001'
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿ÔÀ´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......
ÔÚÁ¬½ÓÊý¾ÝԴʱ£¬Êý¾ÝÁ¬½ÓÊôÐÔÖÐÑ¡Ôñoracle provider for ole db
µ¥»÷ÏÂÒ»²½Ê±±¨´í ¡°Ìṩ³ÌÐò²»ÔÙ¿ÉÓã¬ÇëÈ·¶¨Ìṩ³ÌÐò±»ÕýÈ·°²×°¡£¡±
ÎÒÓõÄÊÇoracle 8£¬ÏÈǰÓõÄ10gÒ²Óöµ½ÀàËÆµÄÎÊÌâ
ʹÓÃmicrosoft ole db pro ......