°²×°OracleÐèÒªµçÄÔµÄʲôÅäÖð¡ - Oracle / ·Ç¼¼ÊõÇø
ÎÒ°²×°Oracle£¬µçÄÔÌáʾÎÒʲô256²»¹»Óã¬ÐèҪʲô¶«Î÷¾Í²»ÖªµÀÁË£¬Ó¦¸ÃÔõôÉèÖð¡
ÒªÁ÷³©ÔËÐÐoracle
9i¶¼ÒªÇóÖÁÉÙ512m,
10gÖÁÉÙÒªÇó1g
256m¿ÉÒÔ×°8i
Ò»°ãÊÇÄÚ´æ²»¹» ½¨ÒéÔö¼ÓÐéÄâÄڴ棡526MB µÄÄÚ´æÐéÄâÄÚ´æÖÁÉÙÊÇ1024MB
·ñÔòÅܲ»ÆðÀ´£¡
Õý³£µÄÄÚ´æÔÚ1G ÒÔÉÏ£¡ Ò²ÒªÐéÄâÄڴ棡
ÎÒµÄÊÇ512MµÄÄڴ棬ÏÖÔÚÆô¶¯Ê±·Ç³£µÄÂý£¬10g°æ±¾¡£
ÓÐʱºò²Ù×÷ÆäËû»¹±ØÐë°Ñ·þÎñÍ£Ò»ÏÂ
512ºÃÏñÒ²ÄÜ×°£¬ÎÒÒÔǰװ¹ý9i.
ÎÒÏÖÔÚÍæµÄÐéÄâ»ú£¬·ÖÅä512ÄÚ´æ¸øÐéÄâ»úÒ²ÄÜÍæÆðÀ´
¼Ó¸ùÄÚ´æÌõ
256M¿ÉÒÔ°²×°¿Í»§¶Ë,·þÎñ¶Ë°²×°²»ÁË~~~
ÏÖÔÚ»¹ÓÐ256µÄ»úÆ÷°¡,¶¼ÒѾ³ÉΪÓÐÊղؼÛÖµµÄ¶«Î÷ÁË...............
¾ÍËãÈÃÄã×°ÆðÀ´,Äã»úÆ÷Ò²¶¯²»ÁË................................
½¨Òé¸ü»»»úÆ÷°É.ʵÔÚ¸ü»»²»ÁË,ÔÚÅóÓѵĻúÆ÷ÉÏ×°¸ö·þÎñ¶Ë,Äã×Ô¼ºµÄ»úÆ÷×°¸ö¿Í»§¶ËÀ´²Ù×÷,ˣˣ,ѧϰѧϰ¾ÍÊÇÁË..............
256ÏÔÈ»²»¹»£¬¶Ô10gÀ´Ëµ£¬512ÄÚ´æÊÇ×îµÍÒªÇ󣬵¥´¿µÄ¿ªÆôÊý¾Ý¿â»¹¿ÉÒÔÓã¬Æô¶¯µÄʱºò×îºÃ°ÑÆäËûµÄ³ÌÐò¹ØÁË£¬²»È»¾ÍÌ«¿¨ÁË
512Äڴ棬»¹ÊÇÎÏÅ£ÅÀ
10gµÄÎÒµÄÊÇ512£¬ÅÜÆðÀ´Ã»Ê²Ã´Ó°Ïì
Ôø¾ÔÚÄÚ´æ½öÓÐ128MµÄ»úÆ÷Àï×°¹ý9i£¬256MµÄÐéÄâ»úÀï×°¹ý10g
ÕâʱҪ½èÖúÓÚswap¿Õ¼ä»òÕßÐé´æ¡£
Ïà¹ØÎÊ´ð£º
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿
1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN
......