oracle·þÎñ¾³£×Ô¶¯¹Ø±Õ£¬Çë´ó¼Ò°ï棬ºÜ¼±£¡
oracle·þÎñ¾³£×Ô¶¯¹Ø±Õ£¬Çë´ó¼Ò°ï棬ºÜ¼±£¡ ·þÎñÆ÷ÊÇIBM X3650 ¡¢2C £¨Ö÷Ƶ2.0£© ¡¢4GÄÚ´æ ¡£ ²Ù×÷ϵͳÊÇ windows 2003 oracle°æ±¾ÐÅÏ¢£º Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production PL/SQL Release 9.2.0.1.0 - Production CORE 9.2.0.1.0 Production TNS for 32-bit Windows: Version 9.2.0.1.0 - Production NLSRTL Version 9.2.0.1.0 - Production oracle·þÎñ¾³£×Ô¶¯¹Ø±Õ£¬²»ÖªµÀÊDz»ÊÇ×ÊÔ´²»×ãÒýÆðµÄ¡£
²é¿´ÊµÀý¾¯¸æÈÕÖ¾¡£ ʵÀý¹Ø±Õ£¬ÀïÃæÒ»°ã¶¼ÓмǼ¡£ ÏÈ¿´¿´ ALERT.LOG àÅ£¬windowsÉÏ×ÜÊǹÖʶà¶à¡£ Ò»Ö±ÔÚÆÚ´ý,°ïÄã¶¥¡£ ¿´ÈÕÖ¾ googleÏ ¿´¾¯±¨ÈÕÖ¾£¬alter_sid.log ¿´¿´ÈÕÖ¾ºÍWindowµÄÈÕÖ¾¹ÜÀíÆ÷ÀïµÄ´íÎóÈÕ־ϰÐÅÏ¢¡£ °Ñ¸æ¾¯ÈÕÖ¾Ìù³öÀ´ ²»È»ËÖªµÀÔõô»ØÊÂÒýÓà ÏÈ¿´¿´ ALERT.LOG ... ²»ºÃÒâ˼£¬Õ⼸Ììһֱ棬ûÓлظ´£¬ÎÒµÄÎÊÌâ½â¾öÁË£¬Ð»Ð»´ó¼Ò¹ØÐÄ¡£ ÔΣ¬½â¾öÍê²»½áÌù¡£¡£¡£¡£¡£
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£ ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£ ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£ ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏ Errors in file /user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902: error in executing ODCIIndexStart() routine ORA-0 ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡ oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË ÒýÓà oracle ......
²é¿´ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁ MySQLʹÓõÄÊÇselect @@tx_isolation; ÔÚOracleÖв鿴ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁîÊÇÄĸö£¿ SQL code: SELECT /*+ rule */ s.username,decode(l.type,'TM','TABLE LOCK','TX','ROW LOCK', ......