Redhat Linux oracle 10g em °´Å¥ÂÒÂë½â¾ö
ÍøÉÏÓкܶàµÄ×ÊÁÏ£¬²Î¿¼itput£¨http://space.itpub.net/471666/viewspace-215923£©µÄ¡£
OS : Redhat
DB : Oracle 10.2.0.4.0
1.ÐÞ¸Äjdk ÏÂÃæµÄ×ÖÌå¡£
[oracle@a ~]$ cd $ORACLE_HOME/jdk/jre/lib/
[oracle@a ~]]$ mv font.properties font.properties_bak
[oracle@a ~]]$
[oracle@a ~]]$ cp font.properties.zh_CN.Redhat font.properties
[oracle@a ~]]$
2.ÐÞ¸Äjre ÏÂÃæµÄ×ÖÌå
[oracle@a lib]$ cd $ORACLE_HOME/jre/1.4.2/lib
[oracle@a lib]$ mv font.properties font.properties_bak
[oracle@a lib]$ cp font.properties.zh_CN.Redhat font.properties
3.Çå³ýemµÄcache
[oracle@a lib]$ cd $ORACLE_HOME/oc4j/j2ee/oc4j_applications/applications/em/em/cabo/images/cache/zhs
[oracle@a zhs]$ rm *.gif
4. ÖØÐÂÆô¶¯em
[oracle@a zhs]$ emctl stop dbconsole
[oracle@a zhs]$ emctl start dbconsole
5.¸ü¸ÄIEä¯ÀÀÆ÷µÄÓïÑÔÅäÖãº
Ñ¡Ôñ“¹¤¾ß”→Ñ¡Ôñ”Internet Ñ¡Ïî(0)“→Ñ¡Ôñ"³£¹æ"Ñ¡Ï→Ñ¡Ôñ"ÓïÑÔ"→Ñ¡Ôñ"Ìí¼Ó"
Ìí¼Ó"Ó¢Óï(ÃÀ¹ú)"£¬²¢½«ÆäÒÆÖ²µÚһλ£¬ÖØÐ´ò¿ªem¾ÍOKÀ²£¬·´ÕýÎÒÊÔ¹ýÊÇÓÐÓõ쬰´Å¥µÄÎÄ×Ö±ä³ÉÓ¢ÎÄÁË¡£
Ïà¹ØÎĵµ£º
ÓÃÃüÁîÐÐ(CMD)ÖÐÆô¶¯ºÍ¹Ø±ÕORACLE·þÎñ
¼àÌýÆô¶¯
lsnrctl start
¼àÌýÍ£Ö¹
lsnrctl stop
Æô¶¯Oracle
net start oracleservicesid
Í£Ö¹Oracle
net stop oracleservicesid
netÃüÁîÊÇwinϵͳÃüÁÆäËüµÄ·þÎñÆô¶¯ºÍÉÏÃæµÄÀàËÆ£¡
......
Ò»¡¢Êý¾Ý¿â
Êý¾Ý¿â¹ËÃû˼ÒåÊÇÊý¾ÝµÄ¼¯ºÏ£¬¶øOracleÔòÊǹÜÀíÕâЩÊý¾Ý¼¯ºÏµÄÈí¼þϵͳ£¬ËüÊÇÒ»¸ö¶ÔÏó¹ØÏµÐ͵ÄÊý¾Ý¿â¹ÜÀíϵͳ¡£
¶þ¡¢±í¿Õ¼ä
±í¿Õ¼äÊÇOracle¶ÔÎïÀíÊý¾Ý¿âÉÏÏà¹ØÊý¾ÝµÄÂß¼Ó³Éä¡£Ò»¸öÊý¾Ý¿âÔÚÂß¼Éϱ»»®·Ö³ÉÒ»µ½Èô¸É¸ö±í¿Õ¼ä£¬Ã¿¸ö±í¿Õ¼ä°üº¬ÁËÔÚÂß¼ÉÏÏà¹ØÁªµÄÒ»×é½á¹¹¡£Ã¿¸öÊý¾Ý¿âÖ ......
¼ÙÉèÓÐÕÅ±í£¬½Ðtable1£¬ÀïÃæÓÐ5000ÍòÐÐÊý¾Ý£¬¼ÙÉèÔ¤¼ÆÈ«±íɨÃè1´ÎÐèÒª1¸öСʱ£¬ÎÒÃÇ´Ó¹ý³ÌÀ´¿´£º
1¡¢ÔÚ1µãÖÓ£¬ÓиöÓû§A·¢³öÁËselect * from table1;´Ëʱ²»¹Ü½«À´table1Ôõô±ä»¯£¬ÕýÈ·µÄ½á¹ûÓ¦¸ÃÊÇÓû§A»á¿´µ½ÔÚ1µãÖÓÕâ¸öʱ¿ÌµÄÄÚÈÝ¡£Õâ¸öÊÇûÓÐÒÉÎʵġ£
2¡¢ÔÚ1µã30·Ö£¬ÓиöÓû§BÖ´ÐÐÁËupdateÃüÁ¸üÐÂÁËtable1±íÖеĵ ......
½áºÏÎÒ¹¤×÷ÖÐÅöµ½µÄÔËάÎÊÌ⣬×ܽáÒ»ÏÂlinuxÏÂserver³£¼ûµÄÔËάÎÊÌâÒÔ¼°¶¨Î»·½Ê½¡£ÕâÀïµÄserverÖ÷ÒªÖ¸×ÔÖ÷¿ª·¢µÄÂß¼server£¬web srvÒòΪͨ³£²ÉÓÃͨÓõļܹ¹ËùÒÔÎÊÌâ±È½ÏÉÙ¡£
Âß¼serverͨ³£µÄ´¦ÀíÄÜÁ¦ÔÚ3k/s - 1w/sÖ®¼ä£¬ÒòÒµÎñÌØµã¶ø²»Í¬¡£Âß¼serverÒ»°ãÊÇ×ÔÖ÷¿ª·¢µÄ£¬ËäÈ»ÔÚÉÏÏ ......