Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Ìåϵ½á¹¹ ʵÀý

ORACLEʵÀýÓÐϵͳȫ¾ÖÇø£¨SGA£©ºÍһЩºǫ́½ø³Ì×é³É.
ϵͳȫ¾ÖÇø£¨SGA£©Óй²Ïí³Ø£¨shared pool£©,Êý¾Ý¿â¸ßËÙ»º³åÇø£¨database buffer cache£©,ÖØ×öÈÕÖ¾»º³åÇø£¨redo log buffer£©.¹²Ïí³ØÓÖÓпâ¸ßËÙ»º´æ£¨library cache£©ºÍÊý¾Ý×Öµä¸ßËÙ»º´æ£¨dictionary cache£©×é³É¡£
ORACLE ʵÀý5¸ö±ØÐèµÄºǫ́½ø³Ì£ºSMON,PMON,DBWR,LGWR, ......

oracle Êý¾ÝÀàÐÍÏê½â ÈÕÆÚÐÍ

oracle Êý¾ÝÀàÐÍÏê½â---ÈÕÆÚÐÍ
      oracleÊý¾ÝÀàÐÍ¿´ÆðÀ´·Ç³£¼òµ¥£¬µ«ÓÃÆðÀ´»á·¢ÏÖÓÐÐí¶à֪ʶµã£¬±¾ÎÄÊÇÎÒ¶ÔORACLEÈÕÆÚÊý¾ÝÀàÐ͵ÄһЩÕûÀí£¬¶¼ÊÇ¿ª·¢ÈëÃÅ×ÊÁÏ£¬Óë´ó¼Ò·ÖÏí£º
×¢£ºÓÉÓÚINTERVAL¼°TIME ZONEʵ¼ÊÓõñȽÏÉÙ£¬ËùÒÔ±¾ÎÄÄÚÈÝÎ´Éæ¼°ÕâÁ½¸ö·½Ãæ¡£
1¡¢³£ÓÃÈÕÆÚÐÍÊý¾ÝÀàÐÍ
1.1¡¢DATE
......

ORACLE Ä£Äâ java SPLIT

CREATE OR REPLACE FUNCTION F_HPS_SPLIT
/*
 * ¹¦    ÄÜ: split.
 * ÊäÈë²ÎÊý: Liststr  string
 * ÊäÈë²ÎÊý: Sepe     index
 * ÊäÈë²ÎÊý: Sepe     separator. default is ','.
 * return sepeCount
 */
(
  ......

redhat enterprise linux5.4 °²×° oracle 11g R2

Ò»£¬Ó²¼þÅäÖÃ×îµÍÒªÇó£º
32루X86£©£º
¸öÈËÈÏΪÖÁÉÙ1GÄڴ棨linux ÉÏ512M ¿ÉÒÔ£¬µ«Ì«¹ýÓÚÃãÇ¿ÁË£¬ÄÇÑùÈÝÒ×ËÀ»ú»ò¿¨×¡²»¶¯£¬»áÈÃÈË×¥¿ñµÄ;
windows 512M µÄ¿Ï¶¨²»ÐУ©

10GµÄ¿ÉÓô ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ