oracleÖÐÌí¼ÓºÍɾ³ýÊý¾Ýʱ³ö´í - Oracle / »ù´¡ºÍ¹ÜÀí
1.Ìí¼Óʱ³ö´í: ´´½¨Ò»¸öÁÙʱ±í£¬²åÈë1000wÌõ¼Ç¼ʱ£¬±¨´í£ºora-30009: connect by ²Ù×÷ÄÚ´æ²»×㠸ijÉÖ»²åÈë500wÐÐʱ¾Íû´íÁË¡£ ¹ÊÇó¸ßÊÖÃǰïæ ½â¾öora-30009: connect by ²Ù×÷ÄÚ´æ²»×ãµÄÎÊÌâ 2.ɾ³ýÊý¾Ýʱ±¨´í: ÔÚʹÓÃforall...delete...ÅúÁ¿É¾³ýʱ³ö´í ´íÎó´úÂëÈçÏÂ: SQL code: ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes ORA-06512: ÔÚ "SYS.DBMS_OUTPUT", line 32 ORA-06512: ÔÚ "SYS.DBMS_OUTPUT", line 97 ORA-06512: ÔÚ "SYS.DBMS_OUTPUT", line 112 ORA-06512: ÔÚ line 15 Ï£Íû´ó¼Ò°ïæ½â¾öÒÔÉÏÁ½¸öÎÊÌ⣬²»Éõ¸Ð¼¤£¡
ÄÚ´æÏÞÖÆÁË£¬Çë¼ì²é ½«outputµÄbuffer size µ÷´óÒýÓà ÄÚ´æÏÞÖÆÁË£¬Çë¼ì²é ÔõÑù½â¾ö°¡£¡ À´¸ö¸ßÊÖ£¡ 2.ɾ³ýÊý¾Ýʱ±¨´í: ÔÚʹÓÃforall...delete...ÅúÁ¿É¾³ýʱ³ö´í ´íÎó´úÂëÈçÏÂ: ---------------------------------- DBMS_OUTPUT.ENABLE(1000000); -- ¼Óµ½×ã¹»´óΪֹ ÎÒ¾õµÃÄ㻹ÊÇ·ÖÅúÌá½»Ò»Ï塃 »¥Ïàѧϰ SQL> exec dbms_output.enable(100000); PL/SQL ¹ý³ÌÒѳɹ¦Íê³É¡£ ÊÔÊÔ¿´ ora-30009: connect by ²Ù×÷ÄÚ´æ²»×ã Õâ¸öÎÊÌâÔõÑù½â¾öÄØ£¿ ÏÖÔÚ»¹Ã»Óöµ½¹ýÕâÑùµÄÎÊÌâ ÏȼÇÏ¡£ ½â¾ö
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£ ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£ ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£ ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ emp_no emp_name ------- ------------ 0001 TOM 0002 JOHN 0003 MARY ³£Óõ绰 ¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput) 0001,TOM 0002,JOHN
......
oracle 11g °²×° 01092 ´íÎó, ÈÕÖ¾ÐÅÏ¢£º [oracle@linux trace]$ vi alert_orcl.log MMON started with pid=14, OS id=9089 RESETLOGS after incomplete recovery UNTIL CHANGE 522752 Errors in file / ......
ÎҵĴ¦ÀíÊÇÕâÑùµÄ£º ÎÒÓÐÒ»¸öºÜ´óµÄÊý¾Ý¼¯ºÏ£¬´¦ÓÚÐÔÄÜ·½ÃæµÄ¿¼ÂÇÐèҪʹÓÃÁÙʱ±í¹ý¶É£¬²¢ÇÒʹÓ÷ÖÒ³µÄ·½Ê½ÏòÁÙʱ±íÖвåÈëÊý¾Ý£¬Êý¾ÝʹÓÃÍê±Ïºó£¬É¾³ýÁÙʱ±íµÄÊý¾Ý¡£ ³öÏÖµÄÏÖÏ󣺵±OracleÖØÐÂÆô¶¯ºó£¬µÚÒ»Ò³²åÈëµÄ ......
Ð»Ð»ÌÆÈËÀÏ´óµÄÖ¸µã£¬Ð»Ð»¸÷λ¸ßÊÖµÄÖ¸µã£¡ °²×°10g Enterprise¡£ÉÏÍøÏÂÁËMLDNµÄOracleÊÓÆµ£¬¸ú×ÅÊÓÆµÉϵÄÅäÖÃ×ߣ¬°²×°³É¹¦ÁË£¬µ«ÊÇûÍêÕûµØÅäÖᣠµã»÷½øÈ룺Database Configuration Assistant 1. ´´½¨Êý¾Ý¿â£»
......