Oracle & SUN£¬ÑϾþµÄÌôÕ½£¨Ò»£©
½ñÌì²Î¼ÓÁËOracle & SUNºÏ²¢ºóµÚÒ»´ÎÓëºÏ×÷»ï°é¼°¿Í»§µÄÍ¨Æø»á¡£Õû¸ö»áÒ鏸ÎҵĸоõÊÇ£ºOracleÐÛÐIJª²ª£¬SUNÒâÆø·ç·¢£¬¶øÎÒ×Ô¼º£¬ÐÄ»³ã·ã·¡£ OracleÓÐÁËSUN£¬ÄÇô´ÓÓ²¼þµ½Èí¼þOracleµÄ²úÆ·Ïß¾ÍÊ®·ÖÆë±¸ÁË¡£Oracle°ëÄêÇ°ÍÆ³ö11gR2 for linux£¬½Ó×Åfor solaris£¬¶øÖÁ½ñ¶¼Ã»ÓÐfor windows¡£ÕâÊÇ·ñÒâζ×Å£ºOracleÒÑÓÐ×ã¹»ÄÜÁ¦¶ÔÆäËûƽ̨˵²»¡£ÊÇ·ñÒâζ×Å£ºOracle½«½èÖúÆäÊý¾Ý¿âÊг¡µÄÁìÏȵØÎ»£¬È«ÃæÍƹãfor OracleµÄStorage¡¢Server¡¢OS¡¢Middleware¡¢APP¡£Èç¹ûÊÇ£¬ÄÇôOracle½«³ÉΪÊÂʵÉϵÄ¢¶ÏÕß¡£ÎÞÂÛSI¡¢Customer£¬¶¼½«Êܵ½¸ºÃæÓ°Ïì¡£ MySQLÔõô°ì£¿Èç¹ûOracle¼È²»¶ÔÆäÖ§³Ö¡¢Ò²²»¶ÔÆä·ÅÊÖ£¬ÉõÖÁͨ¹ý²ÏʳµÄÊÖ¶ÎÎüÊÕÆäÊг¡¡£ÄǺó¹û»áÔõÑù£¿¼Ó¾çOracle¶ÔÆóÒµ¼¶Êý¾Ý¿âÊг¡µÄ¢¶Ï£¿Õâ²¢·Ç½öÊÇÎҵı¯¹ÛÂÛµ÷£º½ñÌìÎÒÔڻ᳡ÉÏûÓÐÌýµ½ÈκιØÓÚMySQLδÀ´µÄ˵·¨£¬²¢ÇÒÏÖ³¡Ñ¯ÎÊOracle & SUNµÄ¸ß²ã¹ÙԱҲûÄܵõ½ÇåÎúµÄÏìÓ¦¡£Oracle¹ÙԱ˵²»·ÅÆú£¬Õâ²»ÊÇÎÒÃÇÏëÌýµ½µÄ£¬ÎÒÃÇÏ£ÍûOracleÄܶÔMySQL×ö³ö¹æ»®£¬·ñÔò¹í²ÅÏàÐÅËü»áÔ½À´Ô½ºÃ¡£ ÔSUNµÄϵͳ×ܼàÔÚÑݽ²¹ý³ÌÖжÔSUNµÄÈ«Ïß²úÆ·´ó¿äÌØ¿ç£¬ÀÏʵ˵ÎÒ¶ÔSUN»¹ÊǺÜÓкøеģ¬Ö»ÊÇʵÔÚûÃ÷°×£¬¼ÈÈ»SUNÕâôºÃ£¬ÎªÊ²Ã´»¹»á¾ÓªÀ§ÄÑ£¬ÒÔÖ±»ÊÕ¹º£¿
FLYµÄÊý¾Ý¿âϵͳ½«ºÎÈ¥ºÎ´Ó£¿ÕâÐèÒªÈ«ÃæReview£ºFLYµÄSI´æ´¢²ãÃæÐèÒªÃæ¶ÔÁ½¸öÌôÕ½£¬ÒµÎñÊý¾Ý´æÈ¡¼°ÔªÊý¾Ý´æÈ¡¡£µÚÒ»¸öÌôÕ½ÐèÒª´óÈÝÁ¿¡¢¸ßÐÔÄÜ¡¢¸ß¿É¿¿ÐԵĴ洢É豸¼°¹²ÏíÎļþϵͳ£»µÚ¶þ¸öÌôÕ½ÐèÒªÎȶ¨¿É¿¿¡¢¸ßÐԼ۱ȵÄÊý¾Ý¿â¼°Öмä¼þ¡£ÀÏ´óËÆºõÒ»Ö±ÔÚÓëµÚÒ»¸öÌôÕ½×ö¶·Õù£ºFLY SEC¡¢FLY FS¡¢FLY NAS£¬ÕâЩ²úÆ·ÕÃÏÔ³ö½«FLY´òÔì³ÉÖйúAvidµÄÒ°ÐÄ¡£ÔÚÎÒ¿´À´£¬µÚÒ»¸öÌôÕ½Òѱ»½â¾öÁË60%£¬ÎÒ¶ÔʣϵÄ40%Òà±£³ÖÀÖ¹Û¡£µÚ¶þ¸öÌôÕ½£¬ÎÒ¸üÇãÏòÓÚ°ÑËü¿´³ÉÊǶÔÎÒµÄÌôÕ½£¬³ÃÀÏ´ó»¹Ã»ÓÐ×ã¹»µÄ¾«Á¦¹Ø×¢Ëü¡£ Èç½ñ£¬OracleÓëSUNºÏ²¢ÁË£¬ÌôÕ½ÖØÐ³äÂúÁ˱äÊý¡£
Ïà¹ØÎĵµ£º
±¾ÎĵµÊÇOracle
Database 11.2.0.1 for RHEL5 Server(°üÀ¨x86ºÍx86_64ƽ̨)µÄ¾²Ä¬°²×°Ö¸ÄÏ. ËùÓвÙ×÷ÎÞÐèʹÓÃͼÐνçÃæ. ¾²Ä¬°²×°ÄܼõÉÙ°²×°³ö´íµÄ¿ÉÄÜÐÔ, Ò²ÄÜ´ó´ó¼Ó¿ì°²×°ËÙ¶È.
# ºó¸úÃüÁî±íʾÒÔ²Ù×÷ϵͳÏÂrootÓû§²Ù×÷; ºó¸úÃüÁî±íʾÒÔ²Ù×÷ϵͳÏÂoracleÓû§²Ù×÷;
1.1 ÉÏ´«Èí¼þ
¼ÙÈç·ÅÔÚ/wangnc/oracle/11g/Ä ......
.netµ÷ÓÃoracle³öÏÖÎÞ·¨¼ÓÔØoramts.dll
ÔÚµ÷ÓÃoracleʱ³öÏÖÎÞ·¨¼ÓÔØoramts.dll Õâʱ¿ÉÒÔ³¢ÊÔÒÔÏ·½·¨£º
ÏÈÒª¿´ÔÚÁ¬½Ó×Ö·û´®ÖÐ.ÊÇ·ñÌí¼ÓÁËenlist=false;ͨ³£²»Ìí¼ÓÕâ¸öÊôÐÔ..ϵͳ½«²»»áÈ¥×Ô¶¯µ÷ÓÃoramts.dll
ÏêÇéÇë¿´
½«msvcrtd.dll¿½µ½ C:windows\system32\
......
The DB File Scattered Read wait event generally indicates waits related to full table scans or fast
full index scans. As full table scans are pulled into memory, they are scattered throughout the
buffer cache, since it is usually unlikely that they fall into contiguous buffers. A large numb ......
Êý¾Ý±íµÄÁ¬½ÓÓÐ:
1¡¢ÄÚÁ¬½Ó(×ÔÈ»Á¬½Ó): Ö»ÓÐÁ½¸ö±íÏàÆ¥ÅäµÄÐвÅÄÜÔÚ½á¹û¼¯ÖгöÏÖ
2¡¢ÍâÁ¬½Ó: °üÀ¨
£¨1£©×óÍâÁ¬½Ó(×ó±ßµÄ±í²»¼ÓÏÞÖÆ)
£¨2£©ÓÒÍâÁ¬½Ó(ÓÒ±ßµÄ±í²»¼ÓÏÞÖÆ)
£¨3£©È«ÍâÁ¬½Ó(×óÓÒÁ½±í¶¼²»¼ÓÏÞÖÆ)
3¡¢×ÔÁ¬½Ó(Á¬½Ó·¢ÉúÔÚÒ»Õ ......