°²×°OracleÐèÒªµçÄÔµÄʲôÅäÖð¡ - Oracle / ·Ç¼¼ÊõÇø
ÎÒ°²×°Oracle£¬µçÄÔÌáʾÎÒʲô256²»¹»Óã¬ÐèҪʲô¶«Î÷¾Í²»ÖªµÀÁË£¬Ó¦¸ÃÔõôÉèÖð¡
ÒªÁ÷³©ÔËÐÐoracle 9i¶¼ÒªÇóÖÁÉÙ512m, 10gÖÁÉÙÒªÇó1g 256m¿ÉÒÔ×°8i Ò»°ãÊÇÄÚ´æ²»¹» ½¨ÒéÔö¼ÓÐéÄâÄڴ棡526MB µÄÄÚ´æÐéÄâÄÚ´æÖÁÉÙÊÇ1024MB ·ñÔòÅܲ»ÆðÀ´£¡ Õý³£µÄÄÚ´æÔÚ1G ÒÔÉÏ£¡ Ò²ÒªÐéÄâÄڴ棡 ÎÒµÄÊÇ512MµÄÄڴ棬ÏÖÔÚÆô¶¯Ê±·Ç³£µÄÂý£¬10g°æ±¾¡£ ÓÐʱºò²Ù×÷ÆäËû»¹±ØÐë°Ñ·þÎñͣһϠ512ºÃÏñÒ²ÄÜ×°£¬ÎÒÒÔǰװ¹ý9i. ÎÒÏÖÔÚÍæµÄÐéÄâ»ú£¬·ÖÅä512ÄÚ´æ¸øÐéÄâ»úÒ²ÄÜÍæÆðÀ´ ¼Ó¸ùÄÚ´æÌõ 256M¿ÉÒÔ°²×°¿Í»§¶Ë,·þÎñ¶Ë°²×°²»ÁË~~~ ÏÖÔÚ»¹ÓÐ256µÄ»úÆ÷°¡,¶¼ÒѾ³ÉΪÓÐÊղؼÛÖµµÄ¶«Î÷ÁË............... ¾ÍËãÈÃÄã×°ÆðÀ´,Äã»úÆ÷Ò²¶¯²»ÁË................................ ½¨Òé¸ü»»»úÆ÷°É.ʵÔÚ¸ü»»²»ÁË,ÔÚÅóÓѵĻúÆ÷ÉÏ×°¸ö·þÎñ¶Ë,Äã×Ô¼ºµÄ»úÆ÷×°¸ö¿Í»§¶ËÀ´²Ù×÷,ˣˣ,ѧϰѧϰ¾ÍÊÇÁË.............. 256ÏÔÈ»²»¹»£¬¶Ô10gÀ´Ëµ£¬512ÄÚ´æÊÇ×îµÍÒªÇ󣬵¥´¿µÄ¿ªÆôÊý¾Ý¿â»¹¿ÉÒÔÓã¬Æô¶¯µÄʱºò×îºÃ°ÑÆäËûµÄ³ÌÐò¹ØÁË£¬²»È»¾ÍÌ«¿¨ÁË 512Äڴ棬»¹ÊÇÎÏÅ£ÅÀÒýÓà ҪÁ÷³©ÔËÐÐoracle 9i¶¼ÒªÇóÖÁÉÙ512m, 10gÖÁÉÙÒªÇó1g 256m¿ÉÒÔ×°8i 10gµÄÎÒµÄÊÇ512£¬ÅÜÆðÀ´Ã»Ê²Ã´Ó°Ïì Ôø¾ÔÚÄÚ´æ½öÓÐ128MµÄ»úÆ÷Àï×°¹ý9i£¬256MµÄÐéÄâ»úÀï×°¹ý10g ÕâʱҪ½èÖúÓÚswap¿Õ¼ä»òÕßÐé´æ¡£
Ïà¹ØÎÊ´ð£º
ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿ Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£ ²»ÄÜÖ±½ÓÁ¬½ÓÂ𣿠ÒýÓà ²»ÄÜÖ±½ÓÁ¬½ÓÂ𣿠²»ÄÜ ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿ ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ.. ÒýÓà ¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql declare TYPE test_rec IS record( code varchar(10), name varchar(30) ); v_book test_rec; ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......