Çë½Ì¹ØÓÚoracleË÷ÒýµÄ¼¸¸öÎÊÌâ
ÎÒÏÖÔÚÓõÄÊÇoracle 9i 1.Ò»¸ö±í½¨Á¢¶àÉÙ¸öË÷Òý±È½ÏºÏÊÊ£¿±ÈÈç˵²»´óÓÚ5¸ö 2.ÁªºÏË÷Òý±Èµ¥Ë÷ÒýµÄЧÂʸßô£¿ 3.compress Õâ¸öѹËõ £¬ÄÜÆðµ½Ê²Ã´×÷Óã¿ 4.ÉÏÍøÉϲé×ÊÁÏʱ£¬¶¼ËµoracleʹÓÃÁªºÏË÷ÒýÐèҪǰµ¼ÁУ¬Õâ¸öºÍ°æ±¾ÓйØÏµÂ𣿠5.Èç¹û²»ÐèҪǰµ¼Áеϰ£¬reverse Õâ¸ö·´×ª ÓÖÆðµ½Ê²Ã´×÷ÓÃÄØ£¿ ÎÒ×Ô¼ºÓÃÒ»¸öµ¥±í¶ÔË÷Òý½øÐÐÁËÒ»¸ö¼òµ¥µÄ²âÊÔ£¬½á¹ûÈçÏ£º 1¡¢¶à¸öµ¥Ë÷Òý Ò»ÆðʹÓà »á·Ö±ðµ÷Óø÷×ÔµÄË÷Òý 2¡¢µ¥Ë÷ÒýºÍÎÞË÷Òý×Ö¶Î »áʹÓõ¥Ë÷Òý 3¡¢ÁªºÏË÷ÒýºÍÎÞË÷Òý×Ö¶Î £¨²»³öÏÖµ¥Ë÷Òý×ֶΣ© »áʹÓÃÁªºÏË÷Òý £¨ÁªºÏË÷Òý×Ö¶Î ²»ÓÃÇ¿µ÷˳Ðò £¬Ò²¾ÍÊDz»ÐèҪǰµ¼ÁУ¬ÎÞË÷Òý×ֶλ¹¿ÉÒÔÔÚÁªºÏË÷Òý×Ö¶ÎÖ®¼ä£© 4¡¢µ¥Ë÷ÒýºÍÁªºÏË÷ÒýÒ»ÆðʹÓà 1£©Èç¹ûÁªºÏË÷ÒýÖÐ×Ö¶ÎÈ«²¿³öÏÖ ÔòʹÓÃÁªºÏË÷Òý £¨ÁªºÏË÷Òý×Ö¶Î ²»ÓÃÇ¿µ÷˳Ðò£© 2£©Èç¹ûÁªºÏË÷ÒýÖÐÖ»Óв¿·Ö×ֶγöÏÖ Ôò»áʹÓõ¥Ë÷Òý 5¡¢ÁªºÏË÷ÒýºÍÁªºÏË÷ÒýÒ»ÆðʹÓà 1£©Èç¹ûÆäÖÐÒ»¸öÁªºÏË÷ÒýÖÐÖ»Óв¿·Ö×ֶγöÏÖ Ôò»áʹÓÃÁíÒ»¸öÁªºÏË÷Òý 2£©Èç¹ûÁ½¸ö¶¼ÍêȫʹÓ㬻ò¶¼²»ÍêȫʹÓà »áÑ¡ÔñÆäÖÐÒ»¸öʹÓ㨲»³öÏÖµ¥Ë÷Òý×ֶΣ¬Èç¹û³öÏÖ£¬»áʹÓü䵥Ë÷Òý£©£¬ ¾ßÌåÔõôѡÔñµÄ£¬²»Çå³þ£¿£¿£¿£¿ ˵µÄ²»×¨Òµ ´ó¼Ò´ÕºÏ¿´£¬ Ï£ÍûÖ¸µãСµÜһϡ£ ÏÈллÀ²¡£
ÎÞÈËÎʽòѽ¡£ ×Ô¼º¶¥Ò»Ï¡£ ¸øLZ¶¥ÆðÀ´ÏÈ£¬Ï£ÍûÄãµÄÎÊÌâÄܱ»½â¾ö ßÀ¡£¡£ ÈËÆø²»ºÃѽ¡£ ÐÖµÜÃǸ÷Ê㼺¼ûѽ¡£ÒýÓà ÎÒÏÖÔÚÓõÄÊÇoracle 9i 1.Ò»¸ö±í½¨Á¢¶àÉÙ¸öË÷Òý±È½ÏºÏÊÊ£¿±ÈÈç˵²»´óÓÚ5¸ö Õâ¸öûÓж¨ÂÛ£
Ïà¹ØÎÊ´ð£º
ÔÚÖ´ÐаüµÄʱºòÒýÓÃ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 ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó #topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬ Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04 #lslv -l lv04
......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨ ÒýÓà °²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
eclipse 3.3Æô¶¯web¹¤³Ì£¬ÒªÁ¬½Óoracle9iÊý¾Ý¿â±¨ ÑÏÖØ: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error: ORA-12518, TNS:listener could not hand off cli ......
SQL code: declare v_deptno number(2); v_dname varchar2(14); begin dbms_output.put_line('ÇëÊäÈ벿ÃźźͲ¿ÃÅÃû:'); v_deptno:=&deptno; v_dname:='&dname'; insert into dept01(deptno,dnam ......