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

oracle »»ÐеĽâ¾ö°ì·¨

ÆäʵÕâ¸öºÜ¼òµ¥¾Í°²×°Èý¸ö°ü¾Í¿ÉÒÔÁË£¬·Ö±ðÊÇ£º
IO-Tty-1.07.tar.gz£¬Term-ReadLine-Gnu-1.16.tar.gz£¬ uniread-1.01.tar.gz¡£
 
ÕâÈý¸ö°üÔÚÎҵĿռäÀï¶¼ÓÐ http://fwx515354.download.csdn.net/
½âѹ
tar -zxvf IO-Tty-1.07.tar.gz
tar -zxvf Term-ReadLine-Gnu-1.16.tar.gz
tar -zxvf uniread-1.01.tar.gz
°²×°(Òª°´ÕÕÕâ¸ö˳ÐòÀ´£¬ËüÃÇÖ®¼äÓÐÒÀÀµ¹ØÏµ)
cd IO-Tty-1.07
perl Makefile.PL
make
make install
 
cd ..
cd Term-ReadLine-Gnu-1.16
perl Makefile.PL
make
make install
 
cd ..
cd uniread-1.014
perl Makefile.PL
make
make install
 
×¢Ïú»òÖØÐµÇ¼¾Í¿ÉÒÔÁË¡£


Ïà¹ØÎĵµ£º

oracleÖÐtruncate,delete,dropµÄÒìͬµã

truncate,delete,dropµÄÒìͬµã
×¢Òâ:ÕâÀï˵µÄdeleteÊÇÖ¸²»´øwhere×Ó¾äµÄdeleteÓï¾ä
Ïàͬµã:truncateºÍ²»´øwhere×Ó¾äµÄdelete, ÒÔ¼°drop¶¼»áɾ³ý±íÄÚµÄÊý¾Ý
²»Í¬µã:
1. truncateºÍ deleteֻɾ³ýÊý¾Ý²»É¾³ý±íµÄ½á¹¹(¶¨Òå)
dropÓï¾ä½«É¾³ý±íµÄ½á¹¹±»ÒÀÀµµÄÔ¼Êø(constrain),´¥·¢Æ÷(trigger),Ë÷Òý(index); ÒÀÀµÓÚ¸Ã±íµ ......

oracle·þÎñÓ²¼þÉý¼¶ µ÷Õû²ÎÊý

author£ºskate
time£º2010-05-13
1)If memory increases and you're 64-bit,  e.g  8G to 16G,  Oracle SGA and related parameters need adjust; So are some the Unix kernel parameters.
2)As for CPU related configuration,  some  parameters, based on CPU_co ......

Oracle Sql ÓÅ»¯


»ù±¾µÄSql±àдעÒâÊÂÏî
¾¡Á¿ÉÙÓÃIN²Ù×÷·û£¬»ù±¾ÉÏËùÓеÄIN²Ù×÷·û¶¼¿ÉÒÔÓÃEXISTS´úÌæ¡£
²»ÓÃNOT IN²Ù×÷·û£¬¿ÉÒÔÓÃNOT EXISTS»òÕßÍâÁ¬½Ó+Ìæ´ú¡£
OracleÔÚÖ´ÐÐIN×Ó²éѯʱ£¬Ê×ÏÈÖ´ÐÐ×Ó²éѯ£¬½«²éѯ½á¹û·ÅÈëÁÙʱ±íÔÙÖ´ÐÐÖ÷²éѯ¡£¶øEXISTÔòÊÇÊ×Ïȼì²éÖ÷²éѯ£¬È»ºóÔËÐÐ×Ó²éѯֱµ½ÕÒµ½
µÚÒ»¸öÆ¥ÅäÏî¡£NOT EXISTS±ÈNOT INЧÂÊÉ ......

Oracle ¸ÅÄOracle 10.2£© ½ø³Ì½á¹¹

http://blog.csdn.net/flysyq/archive/2009/02/26/3939877.aspx
Oracle ¸ÅÄOracle 10.2£©
9¡¢½ø³Ì½á¹¹
ÕâÒ»ÕÂÂÛÊöÁËOracleÊý¾Ý¿âϵͳµÄ½ø³ÌºÍOracleϵͳµÄ¿ÉÓõIJ»Í¬ÅäÖá£
ÕâÒ»Õ°üº¬ÏÂÁÐÖ÷Ì⣺
u ½ø³Ì½éÉÜ
u Óû§½ø³Ì¸ÅÊö
u Oracle½ø³Ì¸ÅÊö
u ¹²Ïí·þÎñÆ÷¼Ü¹¹
u רÓ÷þÎñÆ÷ÅäÖÃ
u ³ÌÐò½Ó¿Ú
½ø³Ì½éÉÜ
ËùÓÐÁ¬ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ