oracle¼¸¸ö¸ÅÄîÎÊÌâ
ÐÂÊÖ£¬¶ÔÓÚoracleÖеÄÊý¾Ý¿âʵÀý£¬·½°¸£¬Óû§Ö®¼äµÄ¹ØÏµÓе㲻̫Ã÷°×£¬Ï£Íû¸÷λ¸ßÊÖÖ¸½Ì¡£
Ôõô¸Ð¾õÔÚÊý¾Ý¿âʵÀýÖпÉÒÔÓжà¸öÓû§£¬¶øÃ¿¸öÓû§ÓÐÒ»¸ö·½°¸£¬ÔÚ·½°¸Ï²ŶÔÓ¦ºÜ¶àÊý¾Ý¿â¶ÔÏó£¨Èç±í£¬ÊÓͼµÈ£©
ʵÀýÊÇÒ»×éORACLEºǫ́½ø³Ì¼°Ò»¿éÄڴ棨ͨ³£³ÆÖ®ÎªSGA£¬ÏµÍ³È«¾ÖÇø£©µÄ¼¯ºÏ¡£
·½°¸(schema)£¬ÊÇָijһÓû§¼°ÆäËùÓжÔÏó£¨±í¡¢ÊÓͼ¡¢¹ý³Ì¡¢°üµÈµÈ£©µÄ¼¯ºÏ¡£
Èç¹ûijÓû§ÎÞÈκζÔÏó£¬ÄÇô£¬Êý¾Ý¿âÀïÖ»´æÔÚ¸ÃÓû§£¬²¢ÎÞ¸Ãschema¡£
1£¬Êý¾Ý¿âʵÀý¾ÍÊǺǫ́½ø³Ì ÔÚ¼ÓÉÏ Ò»¿éÄÚ´æÇø(SGAÓëPGA£¬ÓеÄʱºò»¹ÓÐUGA)¡£
2£¬·½°¸¾ÍÊǽ¨Á¢µÄÓû§ÒÔ¼°¸ÃÓû§ÏÂÃæËùÊôµÄËùÓжÔÏ󣨰üÀ¨±í¡¢ÊÓͼ¡¢¹ý³Ì¡¢°ü¡¢Ë÷Òý¡¢´¥·¢Æ÷µÈµÈ£©µÄ¼¯ºÏ¡£
3£¬Óû§¾ÍÊǼòµ¥µÄ´¿´âµÄÓû§£¬Èç¹ûÊǽ¨Á¢µÄ¿ÕÓû§£¬¾ÍÊÇ˵Óû§ÏÂÃæÃ»ÓÐÈÎºÎ±í¡¢ÊÓͼ¡¢¹ý³ÌµÈ¶ÔÏóµÄ»°£¬ÄÇô£¬Êý¾Ý¿âÀïÃæ¿ÉÒÔÕâô˵£¬Ö»´æÔÚÓû§£¬¶øÃ»ÓÐÏàÓ¦µÄ·½°¸schema¡£
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨
ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
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 / ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001'
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......