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

ÓÐʲôÊéÊǽ²¹ØÓÚ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 Performance Tuning Tips & Techniques
ÎÒÂòµÄ£¬¸Õ¿ªÊ¼¿´

..ÖÐÎÄÒëÃûÊÇ  Oracle Database 10g ÐÔÄܵ÷ÕûÓëÓÅ»¯
ÄÚÈÝÊÇÖÐÎĵÄ

ÒýÓÃ
ÒýÓà 1 Â¥ wildwave µÄ»Ø¸´:
Oracle Database 10g Performance Tuning Tips & Techniques
ÎÒÂòµÄ£¬¸Õ¿ªÊ¼¿´

..ÖÐÎÄÒëÃûÊÇ  Oracle Database 10g ÐÔÄܵ÷ÕûÓëÓÅ»¯
ÄÚÈÝÊÇÖÐÎĵÄ

......

ÒýÓÃ
Database Performance Tuning Guide and Reference

oracle¹«Ë¾×Ô¼ºµÄdocument£¬Ã¿¸ö´ó°æ±¾¶¼ÓÐ×Ô¼ºÒ»Ì×

ÄÖÁ˰ëÌìÊÇoracle¹«Ë¾µÄ......ÎÒ˵¿´×ÅÔõôÕâô·Ñ¾¢ÄØ......¹«Ë¾ÅªÁËÁ©±¾ÖÐÎĵÄ,ÎÒ¿´ÁËÁ©ÔÂû¿´Íê......Ò»±¾ÊÇ < <Oracle Database 10g ÍêÈ«²Î¿¼ÊÖ²á>>,Ò»±¾ÊÇ < <Oracle Database 10g ÐÔÄܵ÷ÕûÓëÓÅ»¯>>.
¿´¸Ç¹úÇ¿µÄ < <ÉîÈë½âÎöOracle>>ËٶȾÍÌØ±ð¿ì.

Â¥Ö÷¿ÉÒÔÈ¥http://www.eygle.com/¿´¿´,Õâ¸öÈËÊÇ´óʦ!

ÒýÓÃ
Oracle Database 10g Performance Tuning Tips & Techniques
ÎÒÂòµÄ£¬¸Õ¿ªÊ


Ïà¹ØÎÊ´ð£º

linux + oracleÓÃXP·ÃÎʲ»ÁË

ÎÒ°²×°Ò»Ì¨redhat linux5+oracle 10gµÄ·þÎñÆ÷£¬±Ê¼Ç±¾£¨XPϵͳ£©°²×°ÁËoracle 10g¿Í»§¶Ë,½á¹ûÀÏÊdzö12560µÄ´íÎó£¬Çë¸ßÊÖÖ¸µãÒ»¶þ£¬

-A RH-Firewall-1-INPUT -m state –state NEW -m tcp -p tcp –dpor ......

ÇóÖúORACLEÅúÁ¿Çå³ý±íÊý¾ÝµÄÎÊÌâ - Oracle / ¿ª·¢

±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......

oracleÖÐ×ÝÏòתºáÏò

ÓÐÒ»±íÈçÏ£º
      ID    ÐÕÃû    ¿ÆÄ¿    ³É¼¨ 
      1      ÕÅÈý    ÓïÎÄ    80  ......

oracle procedure ʵ¼Ê¿ª·¢Óöµ½µÄÎÊÌâ

ÓÐÁ½Õűí
1.µÚÒ»ÕÅ,ÊýÁ¿°ÙÍò¼¶
id  number Ö÷¼ü
name varchar(50)
2.µÚ¶þÕÅ,ÊýÁ¿1Íò¼¶
id number Ö÷¼ü
deletename varchar(50)


ÏÖÔÚµÄÎÊÌâÊÇҪдһ¸ö´æ´¢¹ý³Ì,ɾ³ýµÚÒ»ÕűíÖеÄn ......

ORACLE È¡×î´óÖµ

±í×Ö¶Î

ID      NAME    TIME    AMOUNT

14502  1111    0201    1
14502  1111    0201    5
14 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ