ÓÐʲôÊéÊǽ²¹ØÓÚOracleµÄЧÂʵÄ
´ó¼ÒÍÆ¼öÒ»ÏÂ
Oracle Database 10g Performance Tuning Tips & Techniques
ÎÒÂòµÄ£¬¸Õ¿ªÊ¼¿´
Database Performance Tuning Guide and Reference
oracle¹«Ë¾×Ô¼ºµÄdocument£¬Ã¿¸ö´ó°æ±¾¶¼ÓÐ×Ô¼ºÒ»Ì×
http://www.oracle.com/pls/db112/portal.portal_db?selected=17&frame=
ÓÐûÓÐÖÐÎĵİ¡
..ÖÐÎÄÒëÃûÊÇ Oracle Database 10g ÐÔÄܵ÷ÕûÓëÓÅ»¯
ÄÚÈÝÊÇÖÐÎĵÄ
......
ÄÖÁ˰ëÌìÊÇoracle¹«Ë¾µÄ......ÎÒ˵¿´×ÅÔõôÕâô·Ñ¾¢ÄØ......¹«Ë¾ÅªÁËÁ©±¾ÖÐÎĵÄ,ÎÒ¿´ÁËÁ©ÔÂû¿´Íê......Ò»±¾ÊÇ < <Oracle Database 10g ÍêÈ«²Î¿¼ÊÖ²á>>,Ò»±¾ÊÇ < <Oracle Database 10g ÐÔÄܵ÷ÕûÓëÓÅ»¯>>.
¿´¸Ç¹úÇ¿µÄ < <ÉîÈë½âÎöOracle>>ËٶȾÍÌØ±ð¿ì.
Â¥Ö÷¿ÉÒÔÈ¥http://www.eygle.com/¿´¿´,Õâ¸öÈËÊÇ´óʦ!
Ïà¹ØÎÊ´ð£º
ÎÒ°²×°Ò»Ì¨redhat linux5+oracle 10gµÄ·þÎñÆ÷£¬±Ê¼Ç±¾£¨XPϵͳ£©°²×°ÁËoracle 10g¿Í»§¶Ë,½á¹ûÀÏÊdzö12560µÄ´íÎó£¬Çë¸ßÊÖÖ¸µãÒ»¶þ£¬
-A RH-Firewall-1-INPUT -m state –state NEW -m tcp -p tcp –dpor ......
±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......
ÓÐÒ»±íÈçÏ£º
ID ÐÕÃû ¿ÆÄ¿ ³É¼¨
1 ÕÅÈý ÓïÎÄ 80 ......
ÓÐÁ½Õűí
1.µÚÒ»ÕÅ,ÊýÁ¿°ÙÍò¼¶
id number Ö÷¼ü
name varchar(50)
2.µÚ¶þÕÅ,ÊýÁ¿1Íò¼¶
id number Ö÷¼ü
deletename varchar(50)
ÏÖÔÚµÄÎÊÌâÊÇҪдһ¸ö´æ´¢¹ý³Ì,ɾ³ýµÚÒ»ÕűíÖеÄn ......
±í×Ö¶Î
ID NAME TIME AMOUNT
14502 1111 0201 1
14502 1111 0201 5
14 ......