Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

oracle¼¸¸ö¸ÅÄîÎÊÌâ

ÐÂÊÖ£¬¶ÔÓÚoracleÖеÄÊý¾Ý¿âʵÀý£¬·½°¸£¬Óû§Ö®¼äµÄ¹ØÏµÓе㲻̫Ã÷°×£¬Ï£Íû¸÷λ¸ßÊÖÖ¸½Ì¡£
Ôõô¸Ð¾õÔÚÊý¾Ý¿âʵÀýÖпÉÒÔÓжà¸öÓû§£¬¶øÃ¿¸öÓû§ÓÐÒ»¸ö·½°¸£¬ÔÚ·½°¸Ï²ŶÔÓ¦ºÜ¶àÊý¾Ý¿â¶ÔÏó£¨Èç±í£¬ÊÓͼµÈ£©
ʵÀýÊÇÒ»×éORACLEºǫ́½ø³Ì¼°Ò»¿éÄڴ棨ͨ³£³ÆÖ®ÎªSGA£¬ÏµÍ³È«¾ÖÇø£©µÄ¼¯ºÏ¡£

·½°¸(schema)£¬ÊÇָijһÓû§¼°ÆäËùÓжÔÏó£¨±í¡¢ÊÓͼ¡¢¹ý³Ì¡¢°üµÈµÈ£©µÄ¼¯ºÏ¡£

Èç¹ûijÓû§ÎÞÈκζÔÏó£¬ÄÇô£¬Êý¾Ý¿âÀïÖ»´æÔÚ¸ÃÓû§£¬²¢ÎÞ¸Ãschema¡£

1£¬Êý¾Ý¿âʵÀý¾ÍÊǺǫ́½ø³Ì ÔÚ¼ÓÉÏ Ò»¿éÄÚ´æÇø(SGAÓëPGA£¬ÓеÄʱºò»¹ÓÐUGA)¡£

2£¬·½°¸¾ÍÊǽ¨Á¢µÄÓû§ÒÔ¼°¸ÃÓû§ÏÂÃæËùÊôµÄËùÓжÔÏ󣨰üÀ¨±í¡¢ÊÓͼ¡¢¹ý³Ì¡¢°ü¡¢Ë÷Òý¡¢´¥·¢Æ÷µÈµÈ£©µÄ¼¯ºÏ¡£

3£¬Óû§¾ÍÊǼòµ¥µÄ´¿´âµÄÓû§£¬Èç¹ûÊǽ¨Á¢µÄ¿ÕÓû§£¬¾ÍÊÇ˵Óû§ÏÂÃæÃ»ÓÐÈÎºÎ±í¡¢ÊÓͼ¡¢¹ý³ÌµÈ¶ÔÏóµÄ»°£¬ÄÇô£¬Êý¾Ý¿âÀïÃæ¿ÉÒÔÕâô˵£¬Ö»´æÔÚÓû§£¬¶øÃ»ÓÐÏàÓ¦µÄ·½°¸schema¡£


Ïà¹ØÎÊ´ð£º

OracleÀëÏß·ÃÎÊ---ÇóÖú - Oracle / »ù´¡ºÍ¹ÜÀí

´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄԭʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
    ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......

OracleµÄblob×Ö¶ÎÎÊÌâ - Oracle / ¿ª·¢

²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......

server 2000Êý¾Ý×ªÒÆµ½oracle - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔ­À´oracleÀïµÄÔ­ÓеÄÊý¾Ý¿â,Ö»ÄÜн¨

ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......

oracle °²×° 01092 ´íÎó - 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 / ......

sqlÓÅ»¯ - Oracle / »ù´¡ºÍ¹ÜÀí

select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ