Çë½Ì¹ØÓÚ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 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿ 1 ¿ÉÒÔɾ³ý 2 ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl"; private static final String USERNAME = "sys"; private static final String PASSWORD = "s ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó #topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬ Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04 #lslv -l lv04
......
²é¿´ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁ MySQLʹÓõÄÊÇselect @@tx_isolation; ÔÚOracleÖв鿴ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁîÊÇÄĸö£¿ SQL code: SELECT /*+ rule */ s.username,decode(l.type,'TM','TABLE LOCK','TX','ROW LOCK', ......