-
Õª¼Ç
2007-04-24 22:31:44
Ñ¡ÔñÄܹ»Âú×ãÔ¤ÆÚWeb¸ºÔØ£¨°üÀ¨Æ½¾ù¸ºÔØ¡¢·åÖµ¸ºÔØ¡¢ÈÝÁ¿¡¢³É³¤¹æ»®ÒÔ¼°ÏìӦʱ¼ä£©µÄÕýÈ·Ó²¼þÊ®·ÖÖØÒª¡£Ó²¼þÆ¿¾±»áÈÃÈí¼þµ÷Õû´øÀ´µÄÐÔÄÜÌáÉý´ó´òÕÛ¿Û¡£ÔÚÑ¡ÔñÓ²¼þʱ£¬Ç뿼ÂDZí7ËùÁгöµÄ¸÷¸öÒòËØ£º
±í7. ΪIIS 6.0Ñ¡ÔñÓ²¼þʱµÄ¿¼ÂÇÊÂÏî
ÒòËØ
¿¼ÂÇÊÂÏî
´¦ÀíÆ÷µÄÊýÄ¿¡¢ÀàÐͺÍËÙ¶È
¡¤ ½Å±¾£¨ASP»ò ASP.NET£©ÒÔ¼°¼ÓÃÜ£¨SSL£©¶¼ÊÇÊ®·ÖºÄÓÃCPU×ÊÔ´µÄ¹¤×÷¡£´ËÍ⣬²¢·¢µÄ¿Í»§¶Ë¸ºÔØÒ²»á¼ÓÖØCPUµÄ¸ºµ£¡£ÔÚΪϵͳѡÔñ´¦ÀíÆ÷µÄËٶȺÍÊýÁ¿Ê±£¬Ó¦¸Ã¿¼Âǵ½ÕâЩÒòËØ¡£
¡¤ ´óÈÝÁ¿µÄ L2 ´¦ÀíÆ÷»º´æÄܹ»Ìṩ¸ü³öÉ«µÄÐÔÄÜ¡£
¡¤ Á½¿ÅCPUµÄ×ÛºÏÐÔÄÜͨ³£ÎÞ·¨Óëµ¥¿Å¾ßÓÐË«±¶Ëٶȣ¨Ïà¶ÔÓÚÉÏÊöÁ½¿ÅËٶȽÏÂýµÄ CPU ¶øÑÔ£©µÄ CPU ÏàæÇÃÀ¡£
ÎïÀíÄڴ棨RAM£©µÄÊýÁ¿
ÔÚÌí¼Ó¸ü¶àµÄÕ¾µã¡¢ÄÚÈݽű¾£¨ÌرðÊÇASP.NET½Å±¾£©ºÍÓ¦ÓóÌÐò³Ø£¨»òÕß¹¤×÷½ø³Ì£©Ê±£¬Ìí¼ÓÄÚ´æÓÐÖúÓÚÌáÉýϵͳµÄÐÔÄÜ¡£
ÍøÂçÊÊÅäÆ÷µÄÊýÄ¿¡¢ÀàÐͺÍËÙ¶È
ÍøÂçÊÊÅäÆ÷²»Ó¦¸Ã³ÉΪƿ¾±¡£ÐͺŽÏеÄÍø¿¨¿ÉÒÔжÔØijЩ·þÎñÆ÷¹¦ÄÜ£¬´Ó¶øÌáÉýÐÔÄÜ¡£¸ü¶àϸ½ÚÐÅÏ¢£¬Çë²ÎÔÄÇ°ÎÄÖеÄÍøÂçÐÔÄܵ÷Õû¡£
´ÅÅÌ¿ØÖÆÆ÷µÄÀàÐÍ£¬ÎïÀí´ÅÅ̵ÄÊýÁ¿ºÍÈÝÁ¿
¡¤ IIS Äܹ»½«¾³£·ÃÎʵÄÎļþ»º´æÔÚÄÚ´æÖС£µ«ÊÇ£¬²»¾³£·ÃÎʵÄÎļþ£¨¡°ÀäÃÅ¡±Îļþ£©±ØÐëÔÚÐèҪʱ´Ó´ÅÅÌÉ϶ÁÈ¡£¬ÐèÒª¾³£·ÃÎÊ¡°ÀäÃÅ¡±ÎļþµÄ´óÐÍÕ¾µãÐèÒªÓµÓÐÁ¼ºÃµÄ´ÅÅÌÐÔÄÜ£¨Á¬½Óµ½´óÁ¿´ÅÅ̵ÄRAID¿ØÖÆÆ÷£©¡£
¡¤ IIS ÈÕÖ¾ÎļþµÄ´óСÒÔ¼°Ô¤¼ÆµÄÔö³¤Çé¿ö¶¼Ó¦¸ÃÄÉÈ뿼ÂÇ·¶Î§Ö®ÄÚ¡£
IIS¿ÉÄÜÒÀ¿¿µÄÆäËû·þÎñÆ÷
¡¤ ËٶȻºÂýµÄSQL Server ¿ÉÄÜ»áÖÆÔ¼Á¬½Óµ½ÆäÉϵÄIIS·þÎñÆ÷µÄÏìÓ¦ÂÊ£¬¼´Ê¹IIS ·þÎñÆ÷ÓµÓÐÓÅÐãµÄÓ²¼þ×é¼þ¡£
¡¤ Èç¹û½«IIS·þÎñÆ÷ºÍSQL Server£¨»òÕßÈκÎÆäËûCPUÃܼ¯ÐÍ×é¼þ£©·ÅÔÚͬһ̨·þÎñÆ÷ÉÏ£¬»áÏÞÖÆÿ¸ö×é¼þÄܹ»Ê¹ÓõÄ×ÊÔ´£¬²¢ÇÒÓ°ÏìϵͳµÄÕûÌåÐÔÄÜ¡£
¡¡
-
È˲ÅÄÑÇó
2007-04-18 19:52:16
°ì¹«ÊÒµÄJMs´ó¸Å¶ÔÕ⼸ÌìÎÒ´óÉùµÄ¡°ÂîÈË¡±ÓÐЩ²»ÊÊÓ¦£¬ÎÒËù˵µÄÂîÈË£¬×¼È·µØ˵¶ÔÐÂÕÐƸÀ´µÄ¼¸Î»´óѧÉúµÄÖ¸µ¼£¬µ«µ±ËûÃÇÒ»Ö±ÎÞ·¨Àí½âÄãµÄÄ¿µÄ£¬ÄãµÄÒâͼ£¬ÉõÖÁÁ¬×î¼òµ¥µÄÊÂÇéÒ²Òª½Ó¶þÁ¬ÈýµØÖظ´³ö´í£¬ÎÒ¾Íû·¨Ñ¹ÖÆÎҵĻðÆøÁË£¬ÌرðÔÚÎÒæÓÚ¹¤×÷µÄʱºò£¬»¹ÆµÆµµØ³ö×´¿ö£¬ÉõÖÁÆäËû²¿ÃŵÄͬʵ½ÎÒÕâÀïcomplain¡£×Ô¼ºÓв»ÉÙӦƸµÄ¾Ñ飬ҲÓÐÁËһЩÕÐƸµÄ¾Ñ飬´ÓÃæÊԹٵĽǶÈÀ´ÉóÊÓӦƸÕߣ¬·¢ÏÖѧ¼ÆËã»úÓ¦½ìÉúµÄ´óµÖÓÐÕâô¼¸ÖÖÈË¡£Ò»ÖÖÊÇÔÚÃæÊÔµÄʱºò£¬°Ñ×Ô¼ºÇÇ×°Ò»·¬£¬ËµµÃÌ컨ÂÒ×¹£¬ÎÞËù²»ÄÜ£¬ÎÞËù²»»á£¬±øÀ´½«µ²£¬Ë®À´ÍÁÑÚ,ÒòΪÏÖÔÚµÄÓ¦ÓÃÐÍѧУ£¬Ê²Ã´¶¼½ÌÒ»µã£¬ÔÙ¼ÓÉÏÄÇЩÐÎʽÖ÷ÒåµÄÉç»áʵ¼ù£¬ËùÒÔ£¬¼òÀú¾Í·ç»¨Ñ©ÔµعÚÃáÌûÊÁË¡£¼ÆËã»úרҵµÄºÜ¶àÅ®ÉúÊôÓÚÕâÀ࣡һÖÖÊǼ¼ÊõÐ͵ģ¬ÄÜÁ¦Ç¿£¬×êÑÐÉÄܳԿàÒ²ÄÍÀÍ£¬µ«¹µÍ¨ÆðÀ´ÊDz»ÖªËùÔƵÄ101010»¹ÊÇ001011£¬ÕâÖÖÊǸö±ðµÄÅ£ÈËÐÍ£¬¶ÔÕâÖÖÈ˸ßɽ¾°ÐУ¬ÐIJ»ÏòÍù£¡ÕâÖÖÈ˵ÄÒ»¸öºÃ´¦£¬¶ÔÃæÊÔ¹ÙÀ´Ëµ£¬Òª»ò²»Òª£¬ºÜÈÝÒ׶¨¶á¡£»¹ÓÐÒ»ÖÖ¾ÍÊÇÄѵõÄÊÇΪÎÒËùÓÃÐ͵ģ¬Ð´µ½ÕâÀÓôÃƵÄÐÄÇéҲ˲¼ä±äµÃÊæ̹£¬Ê¡ÐÄÓÖºÃÓã¬ÉÔÉÔÒ»µã²¦¼´¿É¡£ÕâÖÖÈËÃæÊÔµÄʱºò£¬²»»áÏóµÚÒ»ÖÖÄÇÑù£¬ÑÔÓïÈ籬ÖñÄÇÑùÅüÁ¨°ÈÀ²µØ½²¸ö²»Í꣬Ҳ²»»áÏóµÚ¶þÖÖÄÇÑù£¬Ê¼ÖÕÔÚÌÖÂÛһЩÎÞ¹ØÍ´Ñ÷µÄ»ðÐÇÓ֪֮Ϊ֪֮£¬²»Öª±ãÎÊÖ®£¬ºÃѧ£¬Ò²ÇÚÓÚ×êÑУ¬ÐéÐÄ£¬ÓÖ²»È±·¦ÍŶӾ«Éñ£¬Ö»ÊÇÕâÖÖÈ˲ÅÒ²Èçͬ²®ÀÖÒ»°ãÄÑÇó¡£»¹ÓÐÆäËûÉÙÊýÅɵģ¬ÔÚÕÐƸ¹ý³ÌÖÐÒ²Åöµ½¹ý£¬²»³ÉÆøºò£¬¾Í²»Ð´ÁË¡£ÔÚ¼ò¶ÌµÄ¼¸Ê®·ÖÖÓµÄ̸»°ÖУ¬Á˽âÒ»¸öÈË£¬ºÜÄÑ£»Ôڶ̶̵ļ¸Ì죬¼¸Ê®ÌìÖУ¬ÕÒµ½ºÏÊʵÄÈË£¬·Ç³£ÄÑ¡£µ±³õ£¬·Å³öÒ»¸öÕÐƸ¸Ú룬ÊÕµ½ÁË50¶à·ÝµÄӦƸ¼òÀú£¬ÎªÁË͵һʱ֮ÀÁ£¬Ã»ÓÐÏóµÚÒ»´ÎÕÐƸʱÄÇô½÷É÷£¬µ½Í·À´£¬»¹ÊÇ×ÔʳÆä¹û. -
GIS Óë CADµÄÇø±ð
2007-04-10 09:38:45
CADºÍGISÖ®¼äÓдóÁ¿µÄ¼¼ÊõÖصþ£¬Á½Õ߶¼ÓüÆËã»úͼÐΣ¬ÏàËƵÄÊäÈë¡¢Êä³öÉ豸£¬ºÍÉú³ÉƯÁÁµÄ²ÊɫͼÏñ¡£µ«ÊÇ£¬Á½ÕßµÄÏàËÆÐÔµ½´ËΪÖÁ¡£Í¬GISÏà±È£¬CAD½Ï¼òµ¥£¬Õâ¾ÍÊÇËæ׿ÆËã»úͼÐÎѧµÄ·¢Õ¹£¬Ëü·¢Õ¹¸ü¿ìµÄÔÒò¡£ÏÂÃæÊÇÒ»¸ö¶Ô±È£º£¨Newell and Theriault,1990£©
¡¡¡¡CADµÄ¼¸ºÎÐÎʽÖ÷ÒªÓÉÖÆͼԱ¹¹³É£¬¶øGISµÄ¼¸ºÎÐÎ×´ÊÇÓÉɨÃèÊý×Ö»¯»ò²âÁ¿·½·¨µÃµ½µÄ¡£
¡¡¡¡CAD¼¸ºÎÐÎ×´°üº¬Ë®½ºÍ´¹Ö±Ï߶Σ¬Í¨³£Ï߶ÎÖ®¼äµÄ¼Ð½ÇÊǹæÔòµÄ¡£GISʵ¼ÊÉϲ»°üº¬Ë®Æ½»ò´¹Ö±Ï߶Σ¬³ýÁËÖ±½Ç£¬ÆäËüµÄ¹æÔò¼Ð½ÇºÜÉÙ¡£ÁíÒ»·½Ã棬ÐÎ×´ÆÆËéµÄÏ߶Σ¬ÈçµÈ¸ßÏߺͺ£°¶Ïߣ¬ÔòºÜƽ³£¡£
¡¡¡¡ÔÚCADÖУ¬Ô²»¡ºÍÇúÏßÊÇ»ù±¾µÄ£¬ÔÚGISÖУ¬ËüÃÇʵ¼ÊÉϲ»´æÔÚ¡£
¡¡¡¡ÔÚCADÖУ¬Ò»¸öµäÐ͵Ķà±ßÐÎÓÐËĸö¶¥µã£»ÔÚGISÖУ¬Ò»¸ö¶à±ßÐοÉÄÜÓÐÉÏǧ¸ö¶¥µã¡£
¡¡¡¡ÔÚCADÖУ¬ÖîÈçÓ³Éä¡¢Ðýת¡¢±ÈÀý¡¢¿½±´Ö®ÀàµÄ²Ù×÷Ƶ·±µØ±»Óõ½£¬ÔÚGISÖв»³£Óá£
¡¡¡¡ÔÚCADÖУ¬Ä¿±ê¼äµÄÍØÆ˹Øϵʵ¼ÊÉϲ»´æÔÚ£»ÔÚGISÖУ¬ÍØÆËÊÇÖ÷ÒªµÄ¿¼ÂÇÖ®Ò»¡£
¡¡¡¡ÔÚCADÖУ¬Õ¤¸ñºÜÉÙÓ㻵«ÔÚGISÖУ¬ÕâÊÇ»ñÈ¡µØͼ¿â»òÎÀÐÇÊý¾ÝµÄÒ»¸öÓÐЧ¡¢¾¼ÃµÄ·½·¨¡£ -
Ê׶¼Ö®ÐÐ
2007-03-24 08:59:57
±±¾©ÕâÌ˶ù£¬ÎÒËæ¿ÚÀ´ËµËµ¡£ÏÈ˵Õâ×Ͻû³Ç£¬Ò»½øÓÖÒ»½ø£¬¸ßǽÀïÉñÃØ£¬¸ßǽÍâÓµ¼·¡£ÔÙ˵Õâ±±¾©³Ç£¬´ó³Ç°üС³Ç£¬¹¤µØƵÈëÑÛ£¬ÈËËÆÈëȦÌס£ËµËµÕâ±±¾©ÈË£¬»¹ÕæËãÈÈÇ飬ÄеÄÊÇ´óÒ¯£¬Å®µÄ¹Ü½Ð½ã¡£ËµÍêÕâ³ÇºÍÈË£¬ËµËµÕâ¸ßУ¡£Ç廪Բ¾²ÓÆ£¬Î´ÃûºþÊ«Ò⡣ʴÓITÒµ£¬ÖйشåÄÚת£¬Ç°Í·ÊÇ΢Èí£¬ºóÍ·¼ûÐÂÀË¡£¹Åɲ±ßÏÐ×ø£¬¼ªËûÉùÈë¶ú£¬³¤°²½ÖÐŲ½£¬Íõ¸®¾®ÎÅÏã¡£µÇÉÏ°Ë´ïÁ룬×÷Ò»»ØºÃºº£¬ÆßÈÕÕ£ÑÛ¹ý£¬Ô²Âú»®¾äºÅ¡£¸ü¶à¼ûPHOTOALBUM (0311-0318)
-
дÔÚOscar֮ǰ
2007-02-25 22:56:42
Ã÷ÌìÐÂÒ»½ìµÄOscar½±ÓÖÒª½ÒÏþÁË, È¥Äê¿´¹ýµÄÓ°ÊÓ×÷Æ·ÖÐ, ¹ú²úµÄ±ÈºÃÀ³ÎëµÄÒª¶à£¬Á¬Ðø¾ç±ÈµçÓ°Òª¶à£¬ËùÒÔ»¹ÊǵÈ×Å¿´Ã÷ÌìµÄ½á¹ûÁË¡£Ë³±ãɹɹнü¿´¹ýµÄÖµµÃÍƼöµÄƬ×Ó¡«¡«
- °®Çéºô½ÐתÒÆ----Ò»²¿ÇáËɵĵçÓ°£¬ÊʺϷÅËÉÐÄÇ飬»º½âÇéÐ÷¡£Å£ÍÜͬ־µÄËù˵µÄ½ÌÓýÒâÒåÎÒ±£ÁôÒâ¼û¡£ÓûÆÏþÃ÷µÄ»°Ëµ£º°®ÇéÌ°¶à½À²»Àã»what's more, from the point of female£¬ÎÞÂÛÊÇÄÐÅ®£¬ÔÚÁµ°®ºÍ»éÒöÖж¼²»ÒªÒòΪϰ¹ß£¬¶øÍüÁËÈ¥ÖÆÔìÄÇÒ»µãµãÀËÂþ¡£
- Ææ»ÃÈËÉú£¨Stranger than Fiction)----¹¹Ë¼ÇÉÃËãÊÇÖйæÖоØÖеÄÉϳ˼Ñ×÷¡£
- ͨÌìËþ£¨Babel)----Ò»²¿¹ÛÉÍÐÔ²»Ç¿£¬µ«Êʺϻñ½±µÄƬ×Ó¡£
- Æôʾ(Apocalypto)----¿ÉÒÔÁ˽âÒ»µãÂêÑÅÎÄ»¯£¬¶Ô¹ÅÀÏÀúÊ·ºÍÉñÃØÎÄ»¯ÓÐÐËȤµÄÈË¿ÉÒÔ¿´¿´¡£
ÏêϸÄÚÈÝ¿ÉÒÔµãÁ´½Ó²é¿´£º°®Çéºô½ÐתÒÆ£¬Ææ»ÃÈËÉú£¬Í¨ÌìËþ£¬Æôʾ -
Äê»á
2007-02-10 17:58:58
Äê»áµÄÄÚÈÝÄêÄ궼һÑù£¬Êܽ±ÀøµÄÈËËêËêÓб仯£¬ÓÐÖÖ¹«Ë¾´úÓвÅÈ˳ö£¬¸÷Áì·çɧÄǼ¸ÄêµÄζµÀ¡£Ã»ÓÐÈ¥ÄêÄÇÑù·ç¹âµØ¼¸´ÎÀ´»ØÔÚÊܽ±Ì¨Ç°£¬×øÔŲ́ÏÂ̸Ц·çÉú£¬Ã»ÓÐÒ»µãÑۺ죬Õæ³ÏµØ¹ÄÕÆ£¬Õæ³ÏµØµÀºØ¡£µ¹ÊÇÔÚ×ö²¿ÃŹ¤×÷Ñݽ²µÄʱºò£¬ÓÐһЩЩµÄ½ôÕÅ£¬Ò»ÄêÁ½´ÎµÄÉýǨ£¬ÎÒ»¹Ã»À´µÃ¼°×öºÃ×¼±¸£¬¶ÔÕâÖÖ¹«¹ØµÄ¹¤×÷£¬¸ü²»ÊÇÎÒµÄÇ¿Ïî¡£ÔÚÎÒÕâÖÖСPº¢ÑÛÀÕâЩÊÇ¡°´óÈË¡±ÃǵÄÊÂÇé¡£
ÍíÑçÔÚÄê»áÖ®ºó£¬Õâ²»ÊÇÂò×íµÄµØ·½£¬²»¹ý²»ÓÃÌÍÑü°üµÄ£¬ºÃÕâ¿Ú×ÓµÄÈ˸üÀÖÒâµØ±íÑݾưÉÀïµÄС°ÑÏ·¡£ÓÚÊÇ£¬ÎÒµÈÈËÔçÔçµØÍ˳¡È¥ÁË¿¨ÀOK£¬ÌӵøöÇáËÉ×ÔÔÚ£¬ÔÚÄDz»µ½Ê®Æ½·½µÄС·¿¼äÀïÐð¾ÉÊ¡¢ÊãºÀÇé¡¢¼Ä׳־¡¢Ñ°ÀÖȤ¡£×îºó£º
³ªµ½ºíÁüɳÑÆ£¬¶¼»¹ÔÚÕùµ±Âó°Ô
ÎÒ¹ÊÒâÊÓ¶ø²»¼û£¬ÄãÃÇÔÚÅÔ¡°³³×żܡ±
ÎÒÓ¦¸ÃÌýÄãÃǵĻ°£¬ÎÒÓ¦¸Ã°Ñ»ú»áÈøø´ó¼Ò
¹Ô¹ÔµÄ´ôÔÚ¼Ò£¬×¼±¸×źóÌìµÄ½²»°
ÎÒÒѾ³ªµ½ºíÁüɳÑÆ£¬ÎÞ·¨¿ª¿Ú˵»°
ºóÌìµÄÅàѵ£¬ÎÒ¶Ô²»Æð´ó¼Ò
¶Ï¶ÏÐøÐø£¬ÐøÐø¶Ï¶Ï
Ò»×Ö Ò»´Ê ÔÚÕõÔú¡¡
ÒÔÉÏ´¿´âÓéÀÖ£¬
½ñÌìÖ®ºó£¬ÎÒµÄÄê¼ÙÒ²½øÈëÁË×¼±¸½×¶Î¡¡ÖÕÓÚ¿ÉÒԺúÃÐÝÏ¢Ò»¶Îʱ¼äÁË£¡ -
´ºÅ¯
2007-02-05 09:41:59
½ñÌìÊÇÁ¢´º£¬¶þÊ®ËĽÚÆøµÄµÚÒ»¸ö£¬ÕâЩÈÕ×Ó£¬ÄÏ·½µÄÌìÆøÒì³£µÄůºÍ£¬Ó¡Ö¤´ºÌìµÄµ½À´¡£Æ½Ê±¹¤×÷µÄæµ£¬ÎÒÊÇÊèÓÚ¹Û²ì½ÚÆøµÄÆøºòÌØÕ÷µÄ£¬×òÌìµÄÓÆÏУ¬¾¡¹ÜÒ²ÔÚæÈճ̰²ÅŵÄһЩÊÕβ¹¤×÷£¬µ«±Èƽʱ¶àÁËһЩÁôÒ⣬·¢ÏÖ°×Ö糤ÁË¡£ËµÆð°×ÖçºÍºÚÒ¹£¬ÓÖÈÃÎÒÏ뵽ŷÖ޵Ķ¬Ì죬ÌرðÊDZ±Å·£¬µ±Ä걱ŷÓÎÍæµÄ¼Æ»®Ò²ÒòÕâ¸öÔÒòÅÝÁËÌÀ¡£·²Ê¶¼½²¾¿¸öÌìʱ¡¢µØÀûºÍÈ˺͡£
Á¢´ºµÄÒ»¸öÏ°Ë×˵£¬Ó´ºÊÇÒªÔÚÁ¢´ºµÄÇ°Ò»Ìì×¼±¸µÄ¡£×òÌìµÄÎçºó£¬Å¯´ºµÄÑô¹âбÕÕÔڰ칫ÊÒÁÙ´°µÄɳ·¢ÉÏ£¬ÎÒÅÝÁËÒ»±Â̲裬¶Ë×øÔÚ´°Ç°£¬ÈçÆ·Çí½¬ÓñÒº°ãÆ·²è£¬µ±È»ÎÒÊDz»¶®²èµÀµÄ£¬ÔÙ¼ÓÉϹ«Ë¾µÄÁÓÖʲèÒ¶£¬Ö»Îª¡°ºÃ¿Í¡±µÄÀñ½Ú×öµÄ×¼±¸¡£Ö»ÊÇ×°Ä£×÷ÑùµÄ×Ë̬ÒýÀ´±ðÈ˵ĺÃÆ棬¶®Ò²°Õ£¬²»¶®Ò²°Õ£¬ÕâƬ¿ÌµÄÓÆÔÕ£¬¾ÍËãÔÚÓ½ÓÕâ¸ö´ºÌ죬ֻÊDz»ÖªµÀÎÒµÄÓ´º¹¤×÷ÊDz»ÊÇ×ã¹»£¿
Ó´ºÖ®ºó£¬¼ÌÐø¸ûÔÅ£¬°Ñ»¨¿ª¼¾½ÚµÄÈÎÎñÌáµ½ÁËÕⴺůµÄʱ·Ö£¬ÓÌÈçÔÚÓëÈÕÕù¡°¹â¡±£¬²»Êǹâ⣬ÊǹâÒõ£¬ÍµµÃ¹âÒõ£¬ÓÐÒ»ÖÖÓ®ÁËÈüÅܵÄÂú×ã¸Ð£¬ºÍÑóÑóµÃÒâµÄ³É¾Í¸Ð¡£¹âÒõ£¬ÖÕ¾¿ÊÇÓÃÀ´À˷ѵģ¬ÀË·ÑÔÚÄÇÎçºóµÄÂ̲èʱ¹â£¬ÀË·ÑÔÚ¡°ÈûÄɺÓÅÏ¡°µÄÒ¹Íí£¬µ«²»ÄÜÀË·ÑÔÚÕâ¿ÉЦµÄÖ°³¡¡£ -
ÖÊÁ¿ÌØÐÔ
2007-01-30 22:04:24
-
лµÄ²âÊÔÁ÷³Ìͼ
2007-01-30 16:11:39
-
°ÑÁ÷ˮд³É"Ê«"
2007-01-26 21:55:44
ææµµµÄÒ»¸öÐÇÆÚ£¬¿ÈËÔÉùÒ²»¹Ôڶ϶ÏÐøÐø¡£
°×³ãµÄ°ì¹«ÊÒµÆÅÝ£¬ÕÕÁÁ½ÇÂ䣬ҲµãȼÎһؼҵÄÏ£Íû¡£
Ò»¹ÉÄÔµØÏëÄîÂèÂèµÄ·¹²Ë£¬°Ö°ÖµÄ¹Ø»³£¬»¹ÓÐÄÇÎÂůµÄ´ó´²¡£
ÎÒµÄÖÜÄ©£¬È´Òѱ»°ÔÕ¼£¬Ö»µÃ¼ÌÐø°Ñ»Ø¼ÒµÄÐËÖ´æ·Å¡£
·³öÁË´óѧʱµÄÊé±¾£¬Ñо¿ÆðÁË·½²îºÍÒ³½»»»¡£
ѧ¹ýµÄ¶«Î÷Ò»Äê½ÓÒ»ÄêµØÒÅÍü¡£
×öÍêVivianµÄÍøÕ¾£¬ÍæЦµØÒªËý»Ø¹úÇë¿Í³Ô·¹¡£
¿ªÊ¼ÕÒ¹¤×÷ÁË£¬µ«Ô¸ÍøÕ¾ÄÜ°ïÒ»µãæ¡£
À°ÆßÀ°°Ë£¬¶³µôÏ°ͣ¬Ö»ÊÇÔÚµØÇòµÄÕâÒ»°ë¡£
°ÄÍøµÄÕ½»ð´òÏ죬ÏõÑÌÈ´²»ÃÖÂþ¡£
Ò»Ö¦¶ÀÐãµÄÂ޽ܣ¬°Ñ¾«ÒæÇó¾«Ñø³ÉÁËÏ°¹ß£¬
³ÉÁËÍø̳²»¿É»÷ÆƵÄÒ»¶Âǽ¡£
¸ô±ÚÁÚ¾ÓÀÏÒ¯Ò¯µÄ»¨ÑÛ£¬¿´²»¼ûµç»°ºÅÂ룬
È´ÒÀÈ»¹ØÐÄ×ÅËï×ӵĽü¿ö¡£
°ïÁËÒ»µãС棬Ã÷°×ÎÒûÓÐѧ·½ÑÔµÄÌ츳ºÍÔ¸Íû¡£
Ò»¾ä¡°²»¿ÍÆø¡±£¬²ÎÔÓÁËÎÒ1/3µÄÎÂÖÝ¿ÚÒô£¬1/3µÄÄþ²¨¿ÚÒô£¬
ÔÙ¼ÓÄÇÒ»µãµã²ÐÁôÏÂÀ´¹ã¶«Ç»¡£ -
[תÌù]¼Ó¿ì»Ø¹é²âÊԵIJ½·¥£ºÀÛ»ý²âÊÔ·ÖÎöºÍÄ¿±ê²âÊÔÈëÃÅ
2007-01-16 22:05:43
±¾ÎÄÀ´×ÔÓÚ Rational Edge£ºÍ¨³£Ëù˵µÄ¡°ÀÛ»ý²âÊÔ·ÖÎö£¨Cumulative Test Analysis£©¡±¼¼ÊõÏòÈí¼þ²âÊÔÍŶÓÌṩÁ˶Ô×Ô¶¯»¯²âÊÔ¸üºÏÀíµÄ·½·¨£¬ÌرðÊÇÔڻعé²âÊÔ¼¯µÄÁìÓòÄÚ¡£Àí½â CTA ÈçºÎÌá¸ßÄúµÄ²âÊÔЧÂÊ¡£
ÄúµÄ²âÊÔÍŶÓÒѾ·Ç³£³É¹¦ÁË¡£ÄúÒѾ¶Ô×Ô¶¯»¯´óÁ¿Í¶×Ê£¬²¢ÇÒÒòÉú³É´óÐÍÇÒÈ«ÃæµÄ²âÊÔ¼¯¶øÖø³Æ ¡ª¡ª Äú¿ÉÒÔÎÞ¿É·ÇÒéµØΪ֮×ÔºÀ£¡ÔÚÕû¸ö¿ª·¢¹ý³ÌºÍ¶à¸ö»·¾³ÖУ¬ÕâЩ×éºÏΪÄúºÜºÃµØ·þÎñ¡£Òò´ËÏÖÔÚÊÇÄúÐÝÏ¢Ò»»á£¬²¢ÇÒÊÕ»ñÄúËùÀͶ¯µÄºÃ´¦µÄʱºòÁË£¬¶ÔÂ𣿻òÕߣ¬Äú½«³ÉΪÄú×Ô¼ºµÄ×Ô¶¯»¯²âÊÔ¼¯µÄÎþÉüÆ·£¿
Ò²Ðí£¬ÏñÐí¶àÍŶÓÒ»Ñù£¬ÄúÒѾ´ïµ½±¥ºÍµã£¬ÏÖÔÚÄúÓÐÌ«¶àµÄ²âÊÔ£¬ÒÔÖÁÓÚ²»ÄÜ˵Ã÷¡£Ò²ÐíÔËÐвâÊÔµÄÍŶÓÒѾ²»ÔÙÊÇ׫дËüÃǵÄÍŶÓÁË£¬²¢ÇÒ֪ʶÊÇÏ¡Éٵġ£»òÕßÒ²ÐíÄúÊÜÀ§ÓÚ¶Ô´óÁ¿ËùÖ§³ÖµÄ»·¾³ºÍ´úÂëÁ÷²»¶ÏµØÖظ´ÔËÐÐͬÑùµÄ²âÊԵŤ×÷¡£¶ÔÓÚÄÇЩÄú²»ÄÜÔËÐеIJâÊÔ£¬»òÕßÄúûÓÐʱ¼äÔËÐеģ¬Äú¶ÔÄúËù´øÀ´µÄ·çÏÕ½øÐйý¹Û²ìÂð£¿
ÎÞÒɵأ¬Èç¹ûÄúÖ»ÔËÐÐÉÙÁ¿µÄ²âÊÔ£¬²¢ÇÒÈÔ¾ÉÔÚ´úÂëÖÐÕÒµ½Ò»ÑùµÄȱÏÝ£¬ÕâÊǸüºÃµÄ¡£Í¨¹ýÔËÐпÉÄܵIJâÊÔ¾¡¿ÉÄÜ¿ìµØÕÒµ½µÚÒ»´Î³öÏÖµÄȱÏݲ»Í¬ÑùÊǸüºÃµÄÂð£¿
²»ÄÜ´ïµ½µÄÄ¿±ê
ÉõÖÁÊdzöÓÚһƬºÃÐÄ£¬Ã¿¸ö²âÊÔÈËÔ±ÔÚËû»òËýµÄ¹¤×÷ÉúÑÄÖУ¬¶¼½«×«Ð´Ò»¸ö¸ù±¾²»²âÊÔËù´òËã²âÊÔÄÚÈݵIJâÊÔ¡£Õâ¿ÉÄÜÊÇÓÉÓÚȱ·¦¾Ñ飬¶Ô²úÆ·¹¦ÄÜÉè¼ÆµÄ±ä¸ü£¬ÒòΪ²âÊÔÈËÔ±×ö³ö¹ØÓÚ²úÆ·»òÆäÔ¤ÆÚʹÓüÛÖµµÄÎÞЧ¼ÙÉ裬»òÕßÖ»ÊÇÒòΪ²âÊÔÈËÔ±Óþ¡ÁËʱ¼ä¡£×ܶøÑÔÖ®£¬×îÖÕ½á¹ûÊÇÓÉÓÚÓë²úƷȱÏݲ»Ïà¹ØµÄÔÒò¶øʧ°ÜµÄ²âÊÔ¡£
ÕâЩʧ°Ü²âÊÔµÄÀÛ»ýЧӦ´´ÔìÁ˻عéÌ×¼þÖеĻÒÉ«ÇøÓò£¬ÄúµÄ»Ø¹é²âÊ﵀ 5£¥ µ½ 15£¥ÊÇÀ§Äѵġ¢²»¿É¿¿µÄ»ò²»¿ÉÄܳɹ¦µØÔËÐÐÍê³ÉµÄ¡£ÕâЩ×èÈûµÄ»ò²»¿É¿¿µÄ²âÊÔÏûºÄÁ˱¦¹óµÄ²âÊÔʱ¼ä£¬²¢ÇÒ»ìÏýÁ˲âÊÔÈËÔ±¶ÔÕæʵµÄ²úƷȱÏݵĹ۲죬Õâµ¼ÖÂÁËÔڻعé²âÊÔÑ»·Ä©Î²µÄ²âÊÔ½ø¶ÈÖеÄÖ¸ÊýµÄËõС¡£Ðé»ÃµÄËùÓпÉÓòâÊÔµÄ100£¥ µÄÔËÐÐÄ¿±ê³£³£¿´ÆðÀ´·Ç³£½Ó½ü£¬µ«ÊÇÈ´ÄÑÒÔ´ïµ½¡£
×Ô¶¯»¯ÏÝÚå
Ò²ÐíÄúÒѾÂäÈëÁËÑÏÖØÒÀÀµÓÚÄúµÄ²âÊÔ×Ô¶¯»¯»ù´¡¼Ü¹¹µÄÏÝÚåÁË¡£ÕâÀïÓÐһЩÄú¿ÉÄÜ¿¼ÂǵÄÎÊÌâ¡£ÄúÊÇ£º
ȱÉÙÓÃÓÚ²âÊÔÄúËùÆÚÍûµÄÿÑù¶«Î÷µÄ×ÊÔ´Âð£¿
ÏÝÈëÎÞÐÝÖ¹µÄ²âÊÔÑ»·Âð£¿
ÔÚûÓÐÕÒµ½ÈκÎеÄȱÏݵÄÇé¿öÏ£¬ÔËÐгÉǧÉÏÍòµÄ²âÊÔÂð£¿
ÔÚ²»Á˽âÄÇЩ²âÊԵļÛÖµµÄÇé¿öÏ£¬»¨·ÑÄú´ó²¿·ÖµÄʱ¼äÀ´È·¶¨»µµôµÄ²âÊÔÂð£¿
Ãé×¼ 100£¥ ÔËÐÐÄúËùÓеIJâÊÔµÄÄ¿±êÂð£¿ÔÚÖÊÁ¿ºÍ·çÏÕ·½ÃæÄúÁ˽â´ËÄ¿±êÂð£¿
Äú¿ÉÄÜÐèÒªµÄÊÇ£¬²»ÔÙÃé×¼ÈÎÒâÊýÁ¿µÄ²âÊÔ£¬¶ø×ÅÑÛÓÚ´ÓÉϴβâÊÔÒÔÀ´ÔÚ²úÆ·ÖÐʵ¼Ê±ä¸üµÄ¹¦ÄÜÊÇʲô£¬ÒÔ¼°²âÊԴ˱ä¸üËùÐèÒªµÄÊÇʲô¡£×ܶøÑÔÖ®£¬ÄúÐèҪתÒƵ½¸üÉî˼ÊìÂǵġ°Ä¿±ê¡±²âÊԵķ½·¨¡£
Í£Ö¹ÔËÐвâÊÔ£¬¿ªÊ¼Ñ°ÕÒȱÏÝ
ͨ³£Ëù˵µÄÀÛ»ý²âÊÔ·ÖÎö£¨Cumulative Test Analysis£¬CTA£©·½·¨ÊÇ»ùÓÚÎå¸ö»ù±¾ÔÔòµÄ£º
¶¨ÆÚµØÔËÐÐ×Ô¶¯»¯µÄ²âÊÔ¡£
Á˽âÏÖÓвâÊÔ²ÄÁϵÄʵ¼Ê¸²¸ÇºÍÖÊÁ¿¡£
ÔËÐо¡¿ÉÄÜÉٵIJâÊÔ¡£½«²âÊÔ¹Ø×¢ÔÚÖ»ÔËÐÐÄÇЩ¸²¸ÇÁË·¢Éú±ä¸üµÄ¹¦ÄܵIJâÊÔ¡£
ÔÚ×ö³öÆÀ¹Àʱ¿¼ÂÇËùÓеIJâÊԻ¡£
ÓÉËĸö½ÏÔçµÄ²½ÖèËù½ÚÊ¡ÏÂÀ´µÄʱ¼ä¿ÉÒÔÓÃÓÚÔö¼Ó²âÊÔÌ×¼þµÄÖÊÁ¿£¬»òÕßÖ´ÐжîÍâµÄ²âÊÔ¡£
ÈÃÎÒÃÇ°´Ë³ÐòÌÖÂÛÕâЩÔÔò¡£
ÔÔò 1£º¶¨ÆÚµØÔËÐÐ×Ô¶¯»¯µÄ²âÊÔ
CTA ·½·¨×ÅÖØÓÚͨ¹ýÔÚÕû¸öµÄ¿ª·¢Ñ»·ÖÐÔËÐÐ×Ô¶¯»¯µÄ²âÊÔ½«¡°·¢ÉúȱÏݵÄʱ¼ä¡± 1 ×îС»¯¡£ÈκλعéÀàÐ͵ÄȱÏݶ¼¿ÉÒÔºÜÔç·¢ÏÖ£¬²¢ÇÒÓëÔÚÑ»·µÄĩβÔËÐе¥¸öµÄ³¤ÆڻعéÔËÐÐÏà±ÈʹÓÃÁË×îСÁ¿µÄ²âÊÔ¡£
´Ë²âÊÔµÄÄ¿±êÊÇÌṩ¶ÔËùÓÐÇý¶¯³ÌÐòµÄ¹¦ÄÜÖÊÁ¿µÄÒ»¸ö¹Û²ì£¬×÷Ϊ½øÒ»²½²âÊÔºÍ×îÖÕÏòÊг¡·¢²¼µÄ»ù´¡¡£´Ë»Ø¹é²âÊÔ¼õÉÙÁ˽øÈë×îÖÕ²úÆ·µÄȱÏÝÊýÁ¿£¬ÒÔ¼°ÔÚÕâÆڼ䣬¼õÉÙ¿ÉÄÜ·ÀÖ¹ÐÂÌØÐԵĸü¸´ÔӵIJâÊԵĻù´¡¹¦ÄÜÎÊÌâ¡£Óɴ˿ɼû£¬ÕâЩ»Ø¹éÀàÐ͵ÄȱÏÝÐèÒªÔÚÆä×î·½±ãÈ·¶¨µÄʱºò¾¡¿ÉÄÜ¿ìËÙµØÇåÀíµô¡£
ÔÔò 2£ºÁ˽â»Ø¹é²âÊÔÌ×¼þÖÐÏÖÓвâÊÔ²ÄÁϵÄÖÊÁ¿ºÍ¸²¸Ç
ÈçÔçÏÈÌÖÂ۵ģ¬°üº¬ÓڻعéÌ×¼þÖеÄÐí¶à²âÊÔÔÚÈκιæÄ£µÄ²âÊÔ²Ù×÷ÖпÉÄܲ»ÄÜÉú³É¿É¿¿µÄ½á¹û¡£ÎªÁËÍêÈ«Á˽â²úÆ·µÄÖÊÁ¿£¬ÊÂʵÉÏ£¬¸ù¾ÝDZÔڵIJúƷȱÏÝ£¬ÄúÔÚ¹Û²ìµÄ½á¹ûÒâζ×Åʲô£¬Äú±ØÐëÊ×ÏÈÁ˽â²âÊÔʵ¼ÊÉϲâÊԵŦÄÜÊÇʲô¡£
Ϊ´Ë£¬ÎÒÃÇÇóÖúÓÚ´úÂ븲¸ÇµÄʹÓ᣶ÔÓÚÍâÐÐÀ´Ëµ£¬Õâʵ¼ÊÉÏÊÇËùÓз½·¨¡¢ÀàºÍ²âÊÔ´Ó¿ªÊ¼µ½½áÊøËù¾¹ýµÄ´úÂë;¾¶µÄϸ΢ºÛ¼£¡£ÕâÖÖÔÚÒ»¸ö²âÊÔ½ÓÒ»¸ö²âÊԵĻù´¡ÉϵÄÔËÐÐʱ¶ÈÁ¿ÌṩÁ˶ԲâÊÔ×öʲôµÄ¹Û²ì£¬²¢ÇÒ±ÈÆðÔÚʵ¼ÊµÄ²âÊÔÔËÐйý³ÌÖеÄÔËÐÐʱÊÕ¼¯ÐÅϢʱÒÀÀµÓÚ²âÊԼƻ®»ò²âÊÔÎĵµÀ´Ëµ£¬ÊÇÒ»ÖÖÁ˽âÒª²âʲôÄÚÈݵĸü¾«Á·µÄ·½·¨¡£µ±È»£¬¶ÔÓÚ´Ë;¾¶´æÔÚ×ÅÓÉ£¬ÀýÈ磬ѰÕÒȱÏݲ¢Ö´ÐÐÒ쳣·¾¶µÄ²âÊÔÒýÆðµÄÆ«²î¡£×ܵÄÀ´Ëµ£¬¾¡¹Ü£¬Èç¹û´úÂ븲¸ÇÊý¾ÝÊÇÔڳɹ¦µÄ²âÊÔÔËÐйý³ÌÖÐÊÕ¼¯µÄ£¬ÄÇô´ËÐÅÏ¢¿ÉÒÔ´æ´¢ÆðÀ´Ëæºó×÷Ϊ²âÊԵŦÄܵÄָʾ¡£
ÓÐÐí¶à¿ÉÓõŤ¾ß¿ÉÒÔÌṩ´úÂ븲¸ÇÂÊ¡£ËüÃǶ¼µäÐ͵ØʹÓñ»²â´úÂëµÄijÖÖÐÎʽµÄ×°Öã¬Õ⽫¹³×Ó£¨hooks £©¼ÓÈëÁ˲úÆ·´úÂëÖС£µ±²âÊÔ²ÄÁÏÓöµ½ÕâЩ¹³×Óʱ£¬´úÂ븲¸Ç¹¤¾ßʹÓÃÕâЩ¹³×ÓÀ´¼Ç¼ÿ¸ö²âÊÔÔÚÆäÖ´ÐÐʱËù¾ÀúµÄ¹ý³Ì¡£×îÖÕ½á¹ûÊÇÒ»¸ö±íʾÓëÌض¨µÄ²úÆ·Çý¶¯³ÌÐò³åײµÄËùÓвâÊÔµÄÍêÈ«¸²¸ÇµÄÊý¾Ý¿â¡£ÒòΪ»Ø¹é²âÊÔ²ÄÁÏËæ×Åʱ¼äµÄÍÆÒƱ仯µÃ²»´ó£¬ÄÇô´ËÊý¾ÝÈÔ¾ÉÏà¶Ô¾²Ì¬¡£È»¶ø£¬Èç¹û²úÆ·»ò²âÊÔ²ÄÁÏËæ×Åʱ¼äµÄÍÆÒƱ仯ºÜ´ó£¬ÄÇô¾ÍÐèÒªÖظ´ÊµÊ©×°Öá£
ÔÔò 3£º¾¡¿ÉÄÜÉÙµØÔËÐУº¹Ø×¢ÓÚÄúµÄ²âÊÔ
¸Ã±êÌâ¿ÉÒÔµÈͬÓÚÕâÑù´ë´Ç£¬¡°²»ÒªÀË·Ñʱ¼äÔËÐÐÄúÓëÏÈÇ°µÄÇý¶¯³ÌÐò³åײµÄ²âÊÔ£¬³ý·ÇËüÃDzâÊԵŦÄÜÒѾ±ä¸üÁË¡£¡±¼õÉÙ²âÊÔÔËÐеÄÊýÁ¿¿ÉÄܶÔÄÇЩʹÓûعéÌ×¼þ×÷Ϊ»ñÈ¡»Ø¹é°²È«ÍøµÄÐí¶àÍŶÓÀ´ËµÐèÒªÐÅÑöÉϵķÉÔ¾£¬µ«ÊÇÕâÖÖ·ÉÔ¾½«½ÚÊ¡Êý²»¾¡µÄ²»±ØÒªµÄ»Ø¹é²âÊÔʱ¼ä¡£
ʵ¼ÊÉÏ£¬ÊµÏÖÈ·¶¨Ä¿±êµÄ²âÊÔÐèÒªÁ½¼þÊ£º1£©Á˽âÔÚ²âµÄ²úÆ·Çý¶¯³ÌÐòÖÐÈ·Çбä¸üÁËʲô£¬ÒÔ¼° 2£©Á˽âÄúµÄ²âÊÔ²ÄÁÏ£¨ÈçÇ°Ã沿·ÖÖÐÌÖÂ۵ģ©¡£
ÉÏÃæÖеĵÚÒ»¸öÔÚ²úÆ·´úÂë´¦ÓÚijÖÖ¿â¿ØÖÆÐÎʽʱÏà¶ÔÈÝÒ×»ñµÃ¡£¿âϵͳ£¬ÀýÈç CMVC¡¢CVS »ò Rational ClearCase Ìṩ´´½¨Âß¼±ä¸ü»ò½ØÈ»²»Í¬µÄ²ã´Î¼¯ºÏµÄ»úÖÆ¡£¶ÔÓÚÕâЩ²ã´Î£¬¸ö±ðµÄ¹¤¾ßÄܹ»ÌṩijÖÖÁ£¶ÈÉϵÄһϵÁбä¸ü£¬²»ÂÛÊÇÎļþ¡¢°ü¡¢Àà»òijЩ¸üϸÁ£¶ÈµÄÀà±ð¡£ÓÐÁËÕâÁ½ÏîÐÅÏ¢£¬È·¶¨½«ÔÚ×îÉÙµÄʱ¼äÄÚ£¬´ïµ½±ä¸ü¹¦ÄܵÄ×î´ó´úÂë»ò·¾¶¸²¸ÇµÄÏÖÓвâÊԼǼµÄ×Ó¼¯ÊÇ¿ÉÄܵġ£
Èç¹ûûʲô·¢Éú±ä¸ü ¡ª¡ª »òÕߣ¬¸ü¿ÉÄܵÄÊÇ£¬ÄúûÓжԷ¢Éú±ä¸üµÄ¹¦ÄܽøÐвâÊÔ ¡ª¡ª ÄúÖ»ÊDz»ÔËÐÐÈκζ«Î÷£¡ÕâÑù×öÊǶÔÄú¿ÉÒÔ»¨·ÑÔÚÆäËûµØ·½µÄ±¦¹óʱ¼äµÄÀË·Ñ¡£
´Ë´¦¸ø³öÒ»¸ö¾¯¸æ£ºÈç¹û»Ø¹é²âÊÔÌ×¼þÊÇ·¶Î§·Ç³£¹ã·ºµÄ£¬ÄÇôÕ⽫Óм«ºÃµÄЧ¹û¡£µ«Èç¹û¸²¸ÇºÜµÍ£¬ÄÇôÓÐʱºò£¬Ä¿±ê²âÊÔ¿ÉÄÜʹÄúµÃ³ö½áÂÛ£¬ÄúûÓкÏÊʵIJâÊÔÖµµÃÔËÐС£¼Çס£¬ÔÚÕâÒ»µãÉÏ£¬Óûعé²âÊԵıê×¼·½·¨£¬ÍŶӻáäĿµØÔËÐÐÕû¸ö»Ø¹éÌ×¼þ¡£Õ⼸ºõ²»»áÔö¼Ó¼ÛÖµ£¬µ«È·Êµ»á»¨·ÑºÜ¶àʱ¼ä¡£Í¨¹ýʹÓà CTA ·½·¨£¬Äú¿ÉÒÔÀûÓýÚÊ¡µÄʱ¼äÀ´×«Ð´Ð²âÊÔÔö¼ÓÄúµÄ¸²¸ÇÂÊ£¨²Î¼ûÔÚÏÂÃæµÄÔÔò 5 ÖеÄÌÖÂÛ£©¡£
ÀÛ»ý¹Ûµã£ºÑØÓÃÏÈÇ°µÄ²âÊÔ½á¹û
³ýÁËÈ·¶¨²âÊÔÄ¿±ê£¬CTA »¹ÀûÓÃÁíÒ»¸ö¹Ø¼üµÄ¸ÅÄî¼õÉÙÁËËùÐèµÄ²âÊÔÔËÐеÄÊýÁ¿£ºÀÛ»ýµÄ½á¹û·ÖÎö¡£Ò»µ©È·¶¨Á˲âÊÔµÄÄ¿±êÊÇÖ»¸²¸Ç±ä¸üµÄ¹¦ÄÜ£¬ÄÇôÀ´×ÔÓÚδ±ä¸ü´úÂëÇøÓòµÄ½á¹û¾Í¿ÉÄÜ´ÓÒ»´Î¹¹½¨×ªÒƵ½ÏÂÒ»´Î¡£
´Ë·½·¨µÄÖØÒªºÃ´¦ÊÇÔÊÐíʹÓÃ×îÉٵIJâÊÔÊý¾Ý½øÐÐÖÊÁ¿ÆÀ¹À¡£Õâ¶ÔÓÚ·¢²¼Ñ»·µÄÄ©ÆÚÊÇÌرðÓÐÓõģ¬´ËʱҪ×ö³öÉÙÁ¿µÄ±ä¸ü£¬²¢ÇÒ´ó·¶Î§µÄÔËÐвâÊÔ»á¹ý¸ßµØºÄ·Ñʱ¼ä¡£×îÖյľö²ß¿ÉÒÔ¸ù¾Ýʵ¼ÊÉÏÐí¶àÐÇÆÚ»òÔÂ֮ǰµÄ²âÊÔÊý¾Ý×ö³ö£¬¶ø²úÆ·ÈԾɱ£³ÖÒ»¶Îʱ¼äµÄ¹¦ÄÜÎȶ¨¡£
ͨ¹ý½«Ä¿±ê²âÊÔºÍÀÛ»ý½á¹û·ÖÎöÁ½ÌõÔÔò×éºÏÆðÀ´£¬ÔÚ²âÊÔÑ»·ÔçÆÚÔËÐеIJâÊÔ¿ÉÄܲ»ÔÙÐèÒªÔÙ´ÎÔËÐÐÁË£¬ËüÃǵĽá¹û½«±£Áôµ½×îºó¡£ÀàËƵأ¬Èκθ²¸Ç²»Îȶ¨µÄ´úÂëÇøÓòµÄ²âÊÔ¿ÉÄÜÐèҪÿÌ춼ÖØÐÂÔËÐС£Í¨¹ý²ÉÓô˷½·¨£¬¿ÉÒÔ½«²âÊÔ×ÅÖØÓÚ²úÆ·µÄÄÇЩЯ´ø×î¸ß·çÏÕȱÏݵÄÇøÓò¡£
ʵÀý£º´«Í³²âÊÔÓëÄ¿±ê²âÊÔ
ÏÂÃæµÄһϵÁÐͼ±íÏÔʾÁËÒ»¸öÀ´×ÔÓÚµäÐ͵Ļعé²âÊÔÖ´ÐеĿÉÄÜÊä³öµÄÈËΪʵÀý¡£ÎÒÃÇÊ×ÏÈʹÓô«Í³·½·¨£¬È»ºó¶ÔÕâ¸öϵÁеĹ¹½¨Ê¹ÓÃÄ¿±ê·½·¨£¬ÒÔ¼°ÀÛ»ý½á¹û·ÖÎö¡£
¿¼ÂÇÏÂÃæͼ 1 ÖÐÏÔʾµÄ³¡¾°£¬Õâ¿ÉÄÜÊǵ¼ÖÂÊä³öÒ»°ãÀûÓÃÂÊ£¨GA£©µÄ¿ª·¢Ñ»·µÄÒ»²¿·Ö¡£²âÊÔÍŶÓÒѾÀûÓÃÁËÓɹ¹½¨ 3 ºÍ¹¹½¨ 11 »ñµÃµÄ×îÖØÒªµÄ½á¹ûÊý×Ö¶ÔÁ¬ÐøµÄ¹¹½¨³¢ÊÔÐí¶à»Ø¹éÖ´ÐС£
ͼ 1£ºÃ¿´Î¹¹½¨µÄ²âÊÔÍê³É°Ù·Ö±È£¬Ê¹Óô«Í³µÄ»Ø¹é²âÊÔ·½·¨
ÀûÓô«Í³µÄ·ÖÎö·½·¨²¢Ñо¿Í¼ 1 ÖеÄͼ±í£¬ÎÒÃÇÖ»ÄܵóöÒÔÏÂÓÐÏ޵ĽáÂÛ£º
ûÓÐÒ»´Î»Ø¹é´ïµ½ 100£¥ Íê³É ¡ª¡ª ²»¿ÉÄÜ˵³öÓàϵIJâÊÔ¶ÔÕû¸öÖÊÁ¿³ÂÊöÊÇ·ñÖØÒª¡£
ºÜ¿ÉÄܵÄÊǶԹ¹½¨ 4 µ½ 8 µÄС°Ù·Ö±ÈµÄ²âÊÔ£¬ÒªÃ´Îª²âÊÔµÄÈ·¶¨ÖØÐÂÔËÐУ¬ÒªÃ´ÐµIJâÊÔÊǸ²¸ÇûÓÐΪ¹¹½¨ 4 µÄ¶îÍ⹦ÄÜ ¡ª¡ª ²»ÂÛ·¢ÉúÄÄÖÖÇé¿ö£¬¶¼²»¿ÉÄÜÔÚ²»½øÒ»²½·ÖÎöµÄÇé¿öÏÂÈ·¶¨µØÖªµÀ¡£
´Ëͼ±íÖв»Çå³þµÄÊÇΪʲô¶Ô¹¹½¨ 9 Ö´ÐÐÈç´Ë¶àµÄ²âÊÔ¡£
²»¿ÉÄÜ´Óͼ 1 ÖеĵÃÖªµÄÊÇ£¬»Ø¹éÌ×¼þÖеÄËùÓвâÊÔÊÇ·ñÔÚijһ´¦¶¼ÔËÐÐÁË¡£¶Ô´Ë£¬ÎÒÃÇÇóÖúÓÚͼ 2 ÖÐÏÔʾµÄͼ±í¡£
ͼ 2£ºÀûÓô«Í³»Ø¹é²âÊÔ·½·¨µÄÀÛ»ý²âÊÔÍê³É°Ù·Ö±È¡£
ͼ 2 ÏÔʾÁ˶Թ¹½¨ 11 ÊÕ¼¯µÄÒ»¶Îʱ¼äµÄ²âÊÔµÄÀÛ»ý½á¹û¡£´Ë´¦£¬ºÜ¿ÉÄÜ¿´µ½µÄÊÇÍŶӼƻ®ÔËÐд󲿷ֿÉÓõIJâÊÔ£¬²¢ÇÒ·¢ÏÖÐí¶à²âÊÔʧ°Ü£¬È»¶ø£¬ÔËÐÐÕâЩ²âÊÔËù»¨·ÑµÄʱ¼äÒâζ×ÅÔÚ²úÆ··¢²¼µÄʱºòÕâЩÖеÄÐí¶àÈԾɴæÔÚ¡£
ÈÃÎÒÃÇΪ¸ÃÐéÄⳡ¾°Ìî³äһЩ±³ºóϸ½Ú¡£ÉèÏë¹¹½¨ 3 ÊÇ×î³õµÄ GA ºòÑ¡£¬²î²»¶à 80£¥ µÄ¿ÉÓòâÊÔÉú³ÉÁ˺õĽá¹û¡£Æä¼ä£¬È±ÏÝÈ·¶¨ºÍÆäËû±ä¸üÂýÂýµØ½øÈëµ½ÓÉÓÚ¹¤×÷¶¼¼¯ÖÐÓÚ¹¹½¨ 3 ¶øºÜÉÙ²âÊÔµ½µÄºó¼Ì¹¹½¨ÖС£¹¹½¨ 9 Ðû²¼ÎªÐ嵀 GA ºòÑ¡£¬²¢ÇÒ²âÊÔÔٴοªÊ¼¡£µ±¹¹½¨ 11 ³ÉΪ×îÖÕµÄ GA ¹¹½¨Ê±£¬²âÊÔ¹¤×÷ÔÙ´ÎÖØпªÊ¼¡£ÈçÔÚͼ 2 ÖпÉÒÔ¿´µ½µÄ£¬´Ë´Î¶Ô¹¹½¨µÄ²âÊÔÖ±µ½ GA Çý¶¯³ÌÐòÉú³ÉÖ®ºó 11 Ìì²ÅÄÜÍê³É¡£
ÀÛ»ý²âÊÔ·ÖÎöµÄÇé¿ö
ÏÖÔÚ£¬ÈÃÎÒÃǽ«Í¼ 1 ºÍ 2 ÖÐÀý¾ÙµÄ´«Í³·½·¨Óëз½·¨ÔÚͬÑùµÄÇé¿öϽøÐжԱȡ£Ê×ÏÈ£¬ÎÒÃǶÔÀ´×ÔÓÚÉÏÃæ²âÊԵĽá¹ûÖ´ÐÐÀÛ»ý²âÊÔ·ÖÎöµÄм¼Êõ¡£ÎªÁËÕâÑù×ö£¬ÎÒÃÇÏò´Ëͼ±íÒýÈëÐí¶à¸½¼ÓÑÕÉ«£¨²Î¼ûͼ 3£©¡£
ÈçÒÔÇ°Ò»Ñù£¬Í¨¹ý£¨ÂÌÉ«£©»òʧ°Ü£¨ºìÉ«£©µÄвâÊÔÏÔʾΪ°µÉ«¡£ÒòΪͼ 3 ÏÔʾÁ˲âÊÔÑ»·µÄĩ⣬ËùÒÔÏÔʾ³öºÜÉÙ¡°Ðµġ±²âÊÔÔËÐС£
ÓóÈÉ«Í»³öµÄ²âÊÔ±íʾÄÇЩÃé×¼ÒÑÖª¹¹½¨£¬µ«ÒòijÖÖÔÒòûÔËÐеķÖÎö¡£
dzÂ̺ÍdzºìÉ«µÄ½á¹û±íʾ´Ó½ÏÔçµÄ¹¹½¨ÖÐת¹ýÀ´µÄ½á¹û¡£¡°Ðµġ±ºÍ¡°ÖØÐÂÔËÐС±µÄ²âÊÔÖ®¼äµÄ²î±ð½ö½öÊÇ£¬¡°Ðµġ±²âÊÔÊÇÄÇЩ¶ÔÕýÌÖÂ۵Ĺ¹½¨Ê×´ÎÔËÐеIJâÊÔ¡£
»¹Òª×¢ÒâµÄÊÇͼ±í²»ÔÙ´Ó 0£¥ µ½ 100£¥£¬¶øÌ滻Ϊ²âÊԵĶÈÁ¿Êý×Ö¡£Õâ±³ºóµÄÔÒò½«ÔÚÎÒÃÇÌÖÂÛÐÂÊý¾ÝʱÏÔÏÖ³öÀ´¡£
ͼ 3£ºÀûÓô«Í³»Ø¹é²âÊÔ·½·¨µÄ CTA ÀÛ»ý²âÊÔ½á¹û
ÀûÓøü¼Êõ£¬ÎÒÃÇÁ¢¼´ÓÐÁ˸ü¶àÒª¿¼ÂǵÄÐÅÏ¢£º
³ÈÉ«¡°ÒÅ©¡±½á¹û±íÃ÷¹¹½¨ 1 ºÍ 2 ûÓгä·ÖµÄ²âÊÔ£¬µ«ËüÃÇ´Ó¶ÔÔçÆڵĹ¹½¨µÄ²âÊÔ£¨Ã»ÓÐÏÔʾ£©ÄÇÀï´øÀ´Á˷dz£¶àÓÐЧµÄ½á¹û¡£
¶Ô¹¹½¨ 3 µÄ²âÊÔ¼õÉÙµ½ÒÅ©²âÊÔÀÛ»ýµÄ´óÔ¼Èý·ÖÖ®¶þ£¬ËùÐèµÄÓàϵIJâÊÔÔÚÕû¸ö¹ý³ÌÖж¼Ã»ÔËÐУ¬Ö±µ½¹¹½¨ 11¡£
¸½¼ÓµÄ²âÊÔÕë¶ÔÓÚ¹¹½¨ 6£¨¡°ÒÅ©¡±²âÊÔµÄÊýÁ¿Ôö¼Ó£©£¬ËµÃ÷¶Ô²úÆ·Óи½¼ÓµÄ¹¦Äܱä¸ü¡£
¶ÔÐí¶à¹¹½¨³öÏÖÁË´óÁ¿µÄ²âÊÔ£¬¹¹½¨ 3¡¢¹¹½¨ 9 ºÍ¹¹½¨ 11 ÌرðµÄ°º¹ó ¡ª¡ª ÎÊÌâÊÇ£¬ÕâЩ¶¼ÊDZØÒªµÄÂð£¿
½ÓÏÂÀ´£¬ÒòΪ֪µÀ±ä¸üÊÇ CTA µÄÖØÒª²¿·Ö£¬ËùÒÔÎÒÃÇÒýÈëÒ»¸öͼ 4 ÖеÄÐÂͼ±í£¬ÏÔʾ³öÿ´Î¹¹½¨Öбä¸üµÄÓ°Ï죬ÒÔ¼°ÄÇЩ±ä¸ü²âÊÔµÃÓжàºÃ¡£Êý¾ÝÖØдӹ¹½¨´øµ½Ïà¹ØµÄ¹¹½¨ÖУ¬±»±ä¸üÁ˵ÄÀà±»·´Ó³ÔÚÁãÏßÒÔÉÏ£¬¶ø¸²¸ÇÕâЩ±ä¸üµÄ²âÊÔÔÚÁãÏßÒÔÏ¡£³ä·Ö²âÊԵıä¸ü½«Òò´ËÏÔʾΪһ¸öÂÌÉ«µÄÌõ£¬´¦ÓÚÓëÉÏÃæËùʾµÄ±ä¸üÏàͬ¸ß¶ÈµÄÖá֮ϡ£
ͼ 4£ºÃ¿´Ë¹¹½¨µÄ±ä¸üÒÔ¼°ËùÍê³ÉµÄ²âÊÔ
ͨ¹ý´«Í³µÄ»Ø¹é²âÊԵĹ۵ã²é¿´¸ÃÊý¾Ý£¬¿ÉÒÔ¿´µ½£¬¶Ô¹¹½¨ 3 µÄ²âÊÔÊÇÓÐЧµÄ£¬µ«Êǹ¹½¨ 4 µ½ 8 ÖжԲúÆ·ÀàµÄ¸½¼ÓµÄ¹¦Äܱä¸ü£¨ÏÔʾΪ¡°Ðµġ±»òÕß¡°·Ç³£Ðµġ±Ï£¬Ö±µ½¹¹½¨ 11 ²ÅÍêÈ«²âÊÔÍê³É¡£ÉÏÃæ½ÏÔçÃèÊöµÄÆäËüÌáʾµã£º
¹¹½¨ 1 ÖгöÏֵĴóÁ¿±ä¸ü£¬²¢ÇÒ¼¸ºõËùÓÐÕâЩ¶¼¶Ô¹¹½¨ 3 ³ä·Ö²âÊÔÁË¡£
ÔÚ¹¹½¨ 3 Ö®ºó£¬Ðí¶àδ²âÊԵıä¸ü´ÓÒ»¸ö¹¹½¨´øµ½ÁËÏÂÒ»¸öÖУ¬Ê¹¡°È·¶¨È±ÏݵÄʱ¼ä¡±ÀµÃ¸ü³¤¡£
ÔÚ¹¹½¨ 4 ºÍ 5 ÖгöÏֵĴóÁ¿±ä¸ü£¬¿ÉÄÜÒѾ·ñ¶¨ÁËÔçÏÈÖ´ÐеIJâÊÔµÄijЩºÃ´¦¡£¸üÖØÒªµÄÊÇ£¬¶Ô¹¹½¨ 3 ÔËÐеIJ¢ÇÒËæºó²»ÔÚÑ»·ÖÐÖØÐÂÔËÐеIJâÊÔ¿ÉÄÜ»á´í¹ý¹¹½¨ 4 »òÖ®ºóÒýÈëµÄȱÏÝ¡£
ÎÒÃǹÜÀíÁ˶Ôÿ¸ö¹¹½¨ÔËÐеÄÉÙÁ¿²âÊÔ£¬ÎÒÃǽ«ÌṩËùÒýÈë±ä¸üµÄ×îÓÐЧµÄ¸²¸Ç¡£
ÀûÓÃÄ¿±ê²âÊÔʹЧ¹û×î´ó»¯
Ö¸³öÁËÀÏ·½·¨ÖеIJ»×㣬ÎÒÃÇÏÖÔÚʹÓÃеķ½·¨¡£¼ÙÉèÏàͬµÄ»·¾³£¬Í¨¹ý CTA ¿ÉÒÔÍê³Éʲô£¿ÒªÂÛÖ¤Õâµã£¬ÈçÏÈÇ°Ò»Ñù£¬ÎÒÃÇʹÓÃͬÑùµÄÁ½¸öͼ±í£¬Í¼ 5 ºÍ 6 ÖзֱðÏÔʾ³ö½á¹ûºÍ±ä¸ü¡£
ͼ 5£ºÀûÓÃÄ¿±ê²âÊÔ·½·¨µÄ CTA ÀÛ»ý²âÊÔ½á¹û
ͼ 5 ºÍ 6 ÖеÄÊý¾ÝÊÇ»ùÓÚÒѾ²¿ÊðÁËÀÛ»ý²âÊÔ·ÖÎöºÍÄ¿±ê²âÊԵIJâÊÔÍŶӣ¬ÔÚÐèÒª¸²¸Çÿ´Î¹¹½¨Öеıä¸üʱֻÔËÐÐÄÇЩȷ¶¨³öÀ´µÄ²âÊÔ¡£
´Ó´Ë½á¹ûÊý¾ÝÖп´£¬µÚÒ»¼þҪעÒâµÄÊÂÇéÊDzÉÓÃÁ˽ÏÉٵIJâÊÔ ¡ª¡ª ʵ¼ÊÉÏ£¬Ïà±ÈʹÓô«Í³·½·¨µÄ 3000 ¸ö£¬ÔËÐÐÁË´óÔ¼ 1700 ¸ö²âÊÔ¡£ÕâÔÚͼ 5 ÖÐÏÔʾΪ½ÏÉٵġ°Ðµġ±»ò¡°ÖØÐÂÔËÐеġ±²âÊÔ£¬Õâ¿ÉÒÔÕÛºÏΪÏà¶Ô¶ÌµÄʱ¼ä¼ä¸ôÄÚµÄÖØÒªµÄʱ¼ä½ÚÊ¡¡£
ͼ 5 ºÍ 3 Öеڶþ¸öÃ÷ÏԵIJî±ðÊǹ¹½¨ 3 Ö®ºóûÓгÈÉ«µÄ¡°ÒÅ©¡±ÌõÁË¡£ÔÚÕâÖÖÇé¿öÏ£¬²âÊÔÍŶÓÀûÓÃÐí¶à¹¹½¨À´²âÊÔ¹¹½¨ 1 ÖÐÒýÈëµÄËùÓбä¸ü£¬¶øÔں̵ܶÄÒ»¶Îʱ¼äÄÚ£¬ÔËÐÐÁËËùÓÐÈ·¶¨µÄ²âÊÔ¡£¼´Ê¹ÓÐÕâÒ»µãÑÓ³Ù£¬È·¶¨È±ÏݵÄʱ¼ä±È´«Í³·½·¨¼õÉÙÁË¡£¸üÖØÒªµÄÊÇ£¬ÔÚ²âÊÔÑ»·ÖгöÏֵIJâÊÔÖУ¬²»ÔÙ´æÔÚ¶Ô×îÖÕ¹¹½¨ÖÊÁ¿ÉϵĹ۲ìµÄ 11 ÌìµÄÑÓ³Ù¡£Õ⼫´óµØ½µµÍÁËÒ»¸öÒѱ»½»¸¶µÄδ²âÊԵıä¸ü·çÏÕ¡£
ͼ 6 Öл¹ËµÃ÷ÁËЧÂÊ£¬ÕâÏÔʾ³ö¸üÉÙÁ¿µÄ´ÓÒ»´Î¹¹½¨µ½ÏÂÒ»´ÎµÄδ²âÊԵĻò¡°´ø¹ýÀ´µÄ¡±±ä¸ü¡£Í¨¹ýÔÚÒýÈëÁËȱÏݵĹ¹½¨ÖÐÕÒµ½ÕâЩȱÏÝ£¬¿ÉÒÔ¾¡¿ÉÄܵͳɱ¾µØ½øÐÐÈ·¶¨£¬²¢ÇÒ¼õÉÙÁËÏ໥ÒÀÀµµÄȱÏÝÐÞ¸´µÄ¸´ÔÓÁ´µÄ·çÏÕ¡£¶ÔÒ»´Î¹¹½¨Æô¶¯²âÊÔ£¬²¢ÔÚËæºóµÄ¹¹½¨Öг¥»¹Õ®ÎñµÄ·½·¨£¬Ö»ÒªÔÚºó¼ÌµÄ¹¹½¨ÖÐÏàͬµÄ¹¦ÄÜûÓбä¸üʱ¶¼»áÓÐЧ¡£
×îºóµÄÖصãÊÇÏàͬµÄȱÏÝ ¡ª¡ª Ò²¾ÍÊÇ£¬Í¼ 5 ÖеÄʧ°Ü²âÊÔ ¡ª¡ª ÓÃеĺ;ɵķ½·¨¶¼ÕÒµ½ÁË¡£
ͼ 6£ºÀûÓÃÄ¿±ê²âÊÔ·½·¨£¬Ã¿¸ö¹¹½¨µÄ±ä¸üºÍÍê³ÉµÄ²âÊÔ
ÔÔò 4£º¿¼ÂǶÔËùÓй¹½¨Ö´ÐеÄËùÓвâÊÔ
CTA µÄµÚËĸö»ù±¾ÔÔòÒÀÀµÓÚÕâÑùµÄÊÂʵ£¬Ã¿¸ö¶ÔÈí¼þµÄ²âÊÔ¶¼Ìṩһ¸öÖÊÁ¿Ö¸Êý¡£¸Ã²âÊÔ¿ÉÄÜÑÓÉìµ½»ù±¾µÄ²úÆ·°²×°¡¢µ¥Ôª²âÊÔ¡¢¼òµ¥µÄÅäÖ㬻òÕýʽµÄ FVT »ò SVT »î¶¯¡£ÀàËƵģ¬Èç¹ûÔÚ²»Í¬µÄ»·¾³ÖÐÔËÐÐͬÑùµÄ»òÏàËƵIJâÊÔ£¨¾ÙÀýÀ´Ëµ£¬ÔÚ²»Í¬µÄ²Ù×÷ϵͳÉÏ£©£¬ÄÇô½á¹ûÓ¦¸Ã°üº¬ÓÚÖÊÁ¿ËµÃ÷ÖС£
´ËÔÔòµÄÒ»¸öÀ©Õ¹ÊÇÕâÑùÒ»¸öÊÂʵ£¬¶ÔÒ»¸öûÓбä¸üµÄ¹¦ÄÜÖ´ÐеIJâÊÔ¿ÉÄÜÈÔ¾ÉÈÏΪÊÇÓÐЧµÄ¡£Èçͼ3 ºÍ ͼ5 ÖÐËùʾ£¬ÔÊÐíÊÕ¼¯ÀÛ»ýµÄ½á¹û¡£Í¬ÑùµÄ£¬Èç¹ûеÄÇøÓòÄڵĺó¼Ì²âÊÔÌṩÁËÒ»¸ö´æÔÚ²âÊÔÎÊÌâµÄָʾ£¬ÄÇôÕâÒ²Ó¦¸Ã°üº¬ÓÚÖÊÁ¿ÆÀ¹ÀÖС£Òò´ËÔÚÌṩÒÑÖª¹¹½¨µÄÖÊÁ¿Í¶Ó°µÄʱºò£¬¹¤¾ß¿¼ÂÇÁËËùÓвâÊÔ¡£
ÔÔò 5£ºÀûÓýÚÊ¡µÄʱ¼äÀ´Ìá¸ßÖÊÁ¿¡¢×«Ð´ÐµIJâÊÔ
ÀûÓà CTA ºÍÄ¿±ê²âÊÔÒâζ×ÅÄú²»ÔÙÓÐ 100£¥ Ö´ÐеÄÄ¿±êÁË¡£È·ÇеØ˵£¬Ä¿±êËæ×ŶԲúÆ·×ö³öµÄ±ä¸üÈÕ¸´Ò»Èյĸı䡣ÎÊÌâ³öÀ´ÁË£ºÈËÃÇÈçºÎÖªµÀʲôʱºò»Ø¹é²âÊÔÍê³ÉÁË£¿»Ø´ðºÜ¼òµ¥£ºÖ±µ½ËùÓбä¸ü¶¼Í£Ö¹ÁË£¬²¢ÇÒ¸²¸ÇËùÓеıä¸ü ¡ª¡ª ÄÇЩÓÉ·ÖÎö¹ý³ÌËùÈ·¶¨µÄ ¡ª¡ª µÄ²âÊÔ¶¼ÔËÐÐÁË£¬²âÊÔ²ÅÍê³É¡£ÔÚÕâÒ»µãÉÏ£¬ÍŶÓÀûÓûعéÌ×¼þ¼¸ºõÍê³ÉÁËÿ¼þ¿ÉÄܵÄÊÂÇ飬ÒÔÈ·±£²»»áÒýÈë¶îÍâµÄȱÏÝ¡£
×¢ÒâÎÒÃÇ˵¹ý¡°ÍŶӼ¸ºõ×öÁËÿ¼þÊÂÇ顱£¬ÒòΪ·½·¨½«Ö»Ãé×¼ÄÇЩÒѾ°üº¬ÓڻعéÌ×¼þÖеIJâÊÔ¡£Èç¹ûÒòΪ³öÏÖÁ˱ä¸ü£¬µ±ÄúûÓжԱä¸ü½øÐвâÊÔ£¬ÄÇôÄú½«»áÎÞ·¨²é¿´µ½ÄúÈԾɾßÓеķçÏÕ¡£
ʹÓôËз½·¨£¬Äú¿ÉÒÔÈ·ÐŵÄÊÇ£¬ÄúÒѾÔËÐÐÁËÄúÏÖÓеIJâÊÔ×éºÏÖпÉÄܵÄÿ¸ö²âÊÔ£¬À´È·±£×îµÍ¿ÉÄܵķçÏÕ¡£Í¼ 7 Àý¾ÙÁËÕâÒ»µã£¬»ùÓÚÿ¸ö±ä¸üÀàÐÍÖз½·¨µÄΨһ¸²¸ÇÂÊ£¬ÏÔʾ³ö²âÊÔÌ×¼þºÍËüÃÇËù¸²¸ÇµÄ±ä¸üÖ®¼äµÄ¹Øϵ¡£
ͼ 7£º²âÊÔÌ×¼þºÍËüÃÇËù¸²¸ÇµÄ±ä¸üÖ®¼äµÄ¹Øϵ
ÔÚͼ 7 ÖеÄʵÀýÖУ¬×é S3¡¢S4 ºÍ S5 ²»Î¨Ò»µØ¸²¸Ç S1 ºÍ S2 Ëù¸²¸ÇµÄÈκη½·¨£¬È»¶ø£¬Í¨¹ýÔËÐÐËüÃÇ£¬ÍŶӿÉÒÔÈ·¶¨ËüÃÇ¿ÉÒÔÔËÐд¥¼°²¿·Ö±ä¸üµÄÿһ¸ö²âÊÔ¡£
×îÏÔÖøµÄÊÇ£¬³ÈÉ«ÇøÓò ¡ª¡ª ûÓб»ÂÌÉ«¸²¸ÇµÄ²¿·Ö ¡ª¡ª ÔÚͼÖбíʾ¸ù±¾Ã»Óб»»Ø¹éÌ×¼þÖеIJâÊÔ¸²¸Çµ½µÄ±ä¸ü¡£Òò´ËÍŶÓÐèÒª½«ËûÃǹ¤×÷µÄÖص㼯ÖÐÓÚ׫дÌṩ´Ë¸²¸ÇµÄ²âÊÔ£¬ÎªÁËÍêÈ«²âÊÔ±ä¸ü²¢ÇÒ½«´í¹ýDZÔÚȱÏݵķçÏÕ¼õÉÙµ½Æä×îµÍ¿ÉÄܵÄÖµ¡£ÐÒÔ˵ÄÊÇ£¬CTA ·½·¨¸øÍŶÓʱ¼äÀ´¿ª·¢ÕâЩËùÐèµÄ²âÊÔ¡£
ÐÄÀíת±ä
Õâ²»ÊÇм¼Êõ»òÒ»ÖÖ¸ù±¾µÄÐÂÑùʽ¡£±³ºóµÄ˼ÏëÔÚ×î³õÉèÏë´úÂ븲¸Çʱ¾Í³öÏÖÁË¡£¼¼ÊõÌṩµÄ¶«Î÷£¬¾¡¹Ü£¬´Ó²âÊÔÍŶӵĹ۵ãÀ´¿´ÊÇÒ»×éÖ±¾õÉÏÕýÈ·µÄ˼Ï룬µ«ÕâÈԾɱíʾ¶ÔÐí¶àÄÚÈÝÇ¿µ÷µÄ»ù±¾±ä»¯¡£Ö»ÔËÐвâÊÔµÄ×Ó¼¯È¥µôÁË¡°×öһЩÓмÛÖµµÄÊÂÇ顱µÄÐ˷ܸоõ£¬ÕâÊÇÔËÐÐÕû¸ö»Ø¹éÌ×¼þµÄ´«Í³Êµ¼ùÌṩµÄ¸Ð¾õ¡£¸Ãз½·¨»¹ÐèÒªÀ´×ÔÓÚÏîÄ¿¹ÜÀíÍŶӶԲ»ÔÙ³¯×Å»ùÓÚ·çÏÕµÄ 100£¥µÄÔËÐÐÄ¿±ê£¬¶øÖ»¶Ôÿ´Î¹¹½¨ÔËÐÐÇ¡µ±µÄ²âÊÔµÄÁ˽âºÍÖ§³Ö¡£ÕâûÓÐÈ¥µô½«ÍŶÓ×ÅÖØÓÚµ÷ÊÔ²âÊÔʧ°Ü»ò׫двâÊÔµÄÐèÇ󣬵«ÕâÑù×ö¿ÉÒÔΪ×öÖØÒªµÄ¹¤×÷Ó®µÃ¶îÍâµÄʱ¼ä£¡
×¢ÊÍ
1 ·¢ÏÖȱÏݵÄʱ¼ä£¨Time to defect£©£º½«È±ÏÝÒýÈëµ½²úÆ·´úÂëÖкͽ«È±Ïݱ¨¸æ·ÖÅä¸ø½øÐÐÈ·¶¨µÄ¿ª·¢ÈËÔ±Æڼ侹ýµÄʱ¼ä¡£
²Î¿¼×ÊÁÏ
¡°McCabe ÍƼöµÄÈí¼þ±ä¸ü·ÖÎöµÄ·½·¨£¬¡±McCabe ¼°ÆäͬÊ£ºhttp://www.mccabe.com
A. Orso¡¢N. Shi ºÍ M.J. Harrold£¬¡°Scaling Regression Testing to Large Software Systems¡±£¬College of Computing, Georgia Institute of Technology, Atlanta, GA ¡£
Äú¿ÉÒÔ²ÎÔı¾ÎÄÔÚ developerWorks È«ÇòÍøÕ¾ÉÏµÄ Ó¢ÎÄÔÎÄ¡£ -
º¦ÅÂ
2007-01-11 21:32:19
¸¡Ôê×êÈë¶ú¸ù,çÔÈÆÄÔº£,ÓÚÊÇ,ÎÒº¦ÅÂÁË.(2007-1-11)
-
10 most recommended metrics
2006-12-19 10:16:06
The 10 most recommended metrics are taken from the V$SYSSTAT table:
• CPU used by this session - This is the amount of CPU time (in 10s of milliseconds) used by a session between when a user call started and ended. Some user calls can complete within 10 milliseconds and as a result, the start and end user-call time can be the same. In this case, 0 milliseconds are added to the statistic. A similar problem can exist in the reporting by the operating system, especially on systems that suffer from many context switches.
• Bytes received via SQL*Net from client - The total number of bytes received from the client over Net8.
• Logons current - The total number of current logons. This statistic is useful only in V$SYSSTAT.
• Opens of replaced files - The total number of files that needed to be reopened because they were no longer in the process file cache.
• User calls - Oracle allocates resources (Call State Objects) to keep track of relevant user call data structures every time you log in, parse, or execute. When determining activity, the ratio of user calls to RPI calls, give you an indication of how much internal work gets generated as a result of the type of requests the user is sending to Oracle.
• SQL*Net roundtrips to/from client - Total number of Net8 messages sent to and received from the client.
• Bytes sent via SQL*Net to client - The total number of bytes sent to the client from the foreground process(es).
• Opened cursors current - The total number of current open cursors.
• DB block changes - Closely related to consistent changes, this statistics counts the total number of changes that were made to all blocks in the SGA that were part of an update or delete operation. These are changes that are generating redo log entries and hence will be permanent changes to the database if the transaction is committed. This statistic is a rough indication of total database work. This statistic indicates (possibly on a per-transaction level) the rate at which buffers are being dirtied.
• Total file opens - The total number of file opens being performed by the instance. Each process needs a number of files (control file, log file, database file) in order to work against the database. -
½ø³Ì֪ʶ¿â
2006-12-18 22:48:56
½ø³Ì֪ʶ¿â
€€Copyright 2000-2006 СÍÁ¶¹¡£°æȨËùÓС£
Dofile.comÖйú×î´óµÄ½ø³Ì֪ʶ¿â
µçÐÅÕ¾ Íøͨվ Dofile°²È«ÂÛ̳
ÔÚÄãµÄ¼ÆËã»úÉÏ£¬ÓÐ20-30¸ö½ø³ÌÔÚºǫ́ÔËÐÐ×Å¡£ÓеÄÕ¼ÓÃÁËÌ«¶àµÄϵͳ×ÊÔ´£¬Ôì³É»úÆ÷ÔËÐлºÂý¡£¸üΪ²»ÐÒµÄÊÇ£¬Ò»Ð©½ø³ÌÊǼäµýÈí¼þºÍľÂí£¬Èç´ËÄãµÄÒþ˽ºÍ»úÆ÷µÄ¿ØÖÆȨ»á±»ºÚ¿ÍËùÕÆ¿Ø¡£ÕâÀïÌṩÁË´ó¶àÊý³£¼ûµÄ½ø³Ì֪ʶ¡£ÕâÀïµÄ·ÖÀà°üÀ¨£º- ´æÔÚ°²È«·çÏÕ½ø³ÌÁбí
- ϵͳ½ø³ÌÁбí
- Ó¦ÓóÌÐò½ø³ÌÁбí
- ÆäËü½ø³ÌÁбí
- DLL֪ʶ¿â
- ±¾Õ¾Ð¿ªÂÛ̳£¬ÎÞÐè×¢²á£¬¼´¿É·¢±íÎÄÕ£¡
- ¾É°æÁôÑÔ±¡£¨¹Ø±Õ£¬Çëµ½·ÃÎÊÂÛ̳ѰÇóÖ§³Ö£©
ÊäÈë½ø³ÌÃû³Æ£¬²éÕÒ½ø³ÌÐÅÏ¢£º
ËÑË÷WWW ËÑË÷½ø³Ì֪ʶ¿â
Dofile.com±¾µØÏÂÔØ 16361¾µÏñÏÂÔØ ÐÂÀ˾µÏñÏÂÔØ
½ø³ÌÈÈÃÅ֪ʶÎÊ´ð£º- ʲôÊǽø³Ì£¿
- ʲôÊÇľÂí£¿
- ʲôÊǼäµýÈí¼þSpyware£¿
- ÈçºÎ²ì¿´ÕýÔÚÔËÐеĽø³Ì£¿
¸ü¶àÎÊÌâÓë»Ø´ðÇë²Î¿¼½ø³Ì³£¼ûÎÊÌâ
½¨ÒéÌí¼ÓµÄ½ø³ÌÐÅÏ¢
ÉèDofile.comΪÖ÷Ò³ Ìí¼Ó±¾Õ¾µ½ÊղؼÐ
¸üÐÂÄÚÈÝ£º- ÐÂÔöLogo1_.exe¡¢SrvDll.dll¡¢55coc160.dllµÈËÄÏî½ø³Ì&DllÎļþµÄ½âÊÍ¡£
- ÐÂÔörealplayer.exe¡¢EXPLOREEKey.dll¡¢milnx.dllµÈÎåÏî½ø³Ì&DllÎļþµÄ½âÊÍ¡£
- ÐÂÔö9Sy.exe¡¢SysInfo.wmp¡¢WinWdg32.dllµÈËÄÏî½ø³Ì&DllÎļþµÄ½âÊÍ¡£
´æÔÚ°²È«·çÏÕ½ø³ÌTop°ñ
€€´æÔÚ°²È«·çÏÕ½ø³ÌÁÐ±í €€ €€ €€itunesff.exe €€mario.exe €€winfixer.exe €€win32ssr.exe €€Alchem.exe €€services32.exe.exe €€winsvc.exe €€niw.exe €€cfgwiz32.exe ϵͳ½ø³ÌÁбí
€€Top System Processes €€ €€ €€svchost.exe €€ctfmon.exe €€rundll32.exe €€alg.exe €€lsass.exe €€spoolsv.exe €€csrss.exe €€wuauclt.exe €€explorer.exe Ó¦ÓóÌÐò½ø³ÌÁбí
€€Top Applications €€ €€ €€ati2evxx.exe €€FrameworkService.exe €€iTunesHelper.exe €€kazaa.exe €€mshta.exe €€duduprosvc.exe €€foxmail.exe €€QQexternal.exe €€VM_STI.exe ÆäËü½ø³ÌÁбí
€€Other Processes €€ €€ €€Adobe Gamma Loader.exe €€AOLServiceHost.exe €€aspnet_admin.exe €€SearchNet.exe €€DuDuAcc.exe €€winjava.exe €€KPfwSvc.exe €€ServUDaemon.exe €€ymsgr_tray.exe DllÎļþÁбí
€€DllFiles List €€ €€ €€msvbvm60.dll €€mshtml.dll €€mfc70.dll €€mfc42.dll €€regsvr32.dll €€NvCplDaemon.dll €€wab32.dll €€twain.dll €€sqlsrv32.dll
Link URL: http://2in1.spaces.live.com/Blog/cns!AD6C47FFA04D2536!332.entry -
SOAP
2006-12-18 22:48:56
What is SOAP?
- SOAP stands for Simple Object Access Protocol
- SOAP is a communication protocol
- SOAP is for communication between applications
- SOAP is a format for sending messages
- SOAP is designed to communicate via Internet
- SOAP is platform independent
- SOAP is language independent
- SOAP is based on XML
- SOAP is simple and extensible
- SOAP allows you to get around firewalls
- SOAP will be developed as a W3C standard
Why SOAP?
It is important for application development to allow Internet communication between programs.
Today's applications communicate using Remote Procedure Calls (RPC) between objects like DCOM and CORBA, but HTTP was not designed for this. RPC represents a compatibility and security problem; firewalls and proxy servers will normally block this kind of traffic.
A better way to communicate between applications is over HTTP, because HTTP is supported by all Internet browsers and servers. SOAP was created to accomplish this.
SOAP provides a way to communicate between applications running on different operating systems, with different technologies and programming languages.
€€SOAP£¨Simple Object Access Protocol £©¼òµ¥¶ÔÏó·ÃÎÊÐÒéÊÇÔÚ·ÖÉ¢»ò·Ö²¼Ê½µÄ»·¾³Öн»»»ÐÅÏ¢µÄ¼òµ¥µÄÐÒ飬ÊÇÒ»¸ö»ùÓÚXMLµÄÐÒ飬Ëü°üÀ¨Ëĸö²¿·Ö£ºSOAP·â×°(envelop)£¬·â×°¶¨ÒåÁËÒ»¸öÃèÊöÏûÏ¢ÖеÄÄÚÈÝÊÇʲô£¬ÊÇË·¢Ë͵ģ¬ËÓ¦µ±½ÓÊܲ¢´¦ÀíËüÒÔ¼°ÈçºÎ´¦ÀíËüÃǵĿò¼Ü£»SOAP±àÂë¹æÔò£¨encoding rules£©£¬ÓÃÓÚ±íʾӦÓóÌÐòÐèҪʹÓõÄÊý¾ÝÀàÐ͵ÄʵÀý; SOAP RPC±íʾ(RPC representation)£¬±íʾԶ³Ì¹ý³Ìµ÷ÓúÍÓ¦´ðµÄж¨;SOAP°ó¶¨£¨binding£©£¬Ê¹ÓõײãÐÒé½»»»ÐÅÏ¢¡£
¡¡¡¡ËäÈ»ÕâËĸö²¿·Ö¶¼×÷ΪSOAPµÄÒ»²¿·Ö£¬×÷Ϊһ¸öÕûÌ嶨ÒåµÄ£¬µ«ËûÃÇÔÚ¹¦ÄÜÉÏÊÇÏཻµÄ¡¢±Ë´Ë¶ÀÁ¢µÄ¡£ÌرðµÄ£¬ÐÅ·âºÍ±àÂë¹æÔòÊDZ»¶¨ÒåÔÚ²»Í¬µÄXMLÃüÃû¿Õ¼ä(namespace)ÖУ¬ÕâÑùʹµÃ¶¨Òå¸ü¼Ó¼òµ¥
Link URL: http://2in1.spaces.live.com/Blog/cns!AD6C47FFA04D2536!333.entry -
Oracle Study Note
2006-12-18 22:48:56
Q: Íü¼ÇOracle SIDÃÜÂëÔõô°ì£¿
A: ½â¾ö°ì·¨£º
[Phase 1]1.´ò¿ªoracle°²×°Ä¿Â¼µÄX:\oracle\ora92\database
2.ɾ³ýPWDXXX.oraÎļþ(XXXÊǶÔÓ¦µÄSIDÃû)
3.ÔÚÃüÁîÐд°¿ÚÏÂÖ´ÐÐÈçÏÂÃüÁÐÂÉú³ÉÃÜÂ룺
€€ orapwd file=x:\oracle\ora92\database\pwdxxx.ora password=pwdpwd entries=10;
4.È»ºóÖØÆô¶ÔÓ¦µÄ·þÎñ[Phase2]
edit REMOTE_LOGIN_PASSWORDFILE to EXCLUSIVE in the initialization parameter file€€[Phase 3]
Add users to the password file and assign appropriate privileges to each user.
Q: ÒÔv$¿ªÍ·µÄÊý¾Ý×ÖµäÓëÒÔdba_¿ªÍ·µÄÊý¾Ý×ÖµäÖ÷ÒªÇø±ðÊÇʲô?
A: v$¿ªÍ·µÄÊý¾Ý×Öµä ½Ð¶¯Ì¬ÊÓͼ£¬ÆäÊý¾Ý´æ·ÅÔÚÄÚ´æÖУ¬¶¯Ì¬±ä»¯£¬Ò»µ©¹Ø±ÕʵÀý£¬ÀïÃæµÄÊý¾Ý¾Í»á±»Çå¿Õ£¬Æô¶¯ÊµÀýºó±»ÖØÐÂÉèÖá£
dba_¿ªÍ·µÄÊý¾Ý×ÖµäÊǾ²Ì¬ÊÓͼ£¬ÊÇÊý¾Ý´æ·ÅÔÚ±íÖеģ¬¹Ø±ÕʵÀýºó£¬Êý¾Ý²»»á±»Çå¿Õ€€Data dictionary views are static views that answer questions such as:
€€ Was the object ever created?
€€ What is the object a part of?
€€ Who owns the object?
€€ What privileges do users have?
€€ What restrictions are on the object?
The dynamic tables answer questions such as:
€€ Is the object online and available?
€€ Is the object open?
€€ What locks are being held?
€€ Is the session active?
ALTER SESSION
Modify the current user session.
Syntax:ALTER SESSION ADVISE {COMMIT | ROLLBACK | NOTHING} ALTER SESSION CLOSE DATABASE LINK link_name ALTER SESSION {ENABLE | DISABLE} COMMIT IN PROCEDURE ALTER SESSION {ENABLE | DISABLE | FORCE} PARALLEL {DML|DDL|QUERY} [PARALLEL int] ALTER SESSION ENABLE RESUMABLE {TIMEOUT int} {NAME string} ALTER SESSION DISABLE RESUMABLE ALTER SESSION SET option(s) [COMMENT='text'] Options: CONSTRAINT[S] {IMMEDIATE|DEFERRED|DEFAULT} CREATE_STORED_OUTLINES = {TRUE | FALSE| 'category_name' } CURRENT_SCHEMA = schema CURSOR_SHARING = {FORCE | EXACT} DB_BLOCK_CHECKING = {TRUE | FALSE} DB_CREATE_FILE_DEST = directory DB_CREATE_ONLINE_LOG_DEST_N = directory DB_FILE_MULTIBLOCK_READ_COUNT = int ERROR_ON_OVERLAP_TIME = {TRUE | FALSE} FILESYSTEMIO_OPTIONS = {none | setall | directIO | asynch} FLAGGER = {ENTRY | INTERMEDIATE | FULL | OFF} GLOBAL_NAMES = {TRUE | FALSE} HASH_AREA_SIZE = int HASH_JOIN_ENABLED = {TRUE | FALSE} INSTANCE = int ISOLATION_LEVEL = {SERIALIZABLE | READ_COMMITTED} LOG_ARCHIVE_DEST_n (read the Oracle8i Reference for more on this) LOG_ARCHIVE_DEST_STATE_n = {ENABLE | DEFER} LOG_ARCHIVE_MIN_SUCCEED_DEST = int MAX_DUMP_FILE_SIZE = { size | UNLIMITED } NLS_CALENDAR = 'text' NLS_COMP = 'text' NLS_CURRENCY = 'text' NLS_DATE_FORMAT = 'fmt' NLS_DATE_LANGUAGE = language NLS_DUAL_CURRENCY = 'text' NLS_ISO_CURRENCY = territory NLS_LANGUAGE = language NLS_LENGTH_SEMANTICS = {CHAR | BYTE} NLS_NCHAR_CONV_EXCP = {TRUE | FALSE} NLS_NUMERIC_CHARACTERS = 'text' NLS_SORT = {sort | BINARY} NLS_TERRITORY = territory NLS_TIMESTAMP_FORMAT = "datetime_format" NLS_TIMESTAMP_TZ_FORMAT = "datetime_format" OBJECT_CACHE_MAX_SIZE_PERCENT = int OBJECT_CACHE_OPTIMAL_SIZE = int OLAP_PAGE_POOL_SIZE = int OPTIMIZER_DYNAMIC_SAMPLING = int OPTIMIZER_INDEX_CACHING = int OPTIMIZER_INDEX_COST_ADJ = int OPTIMIZER_MAX_PERMUTATIONS = int OPTIMIZER_MODE = {ALL_ROWS | FIRST_ROWS | RULE | CHOOSE} ORACLE_TRACE_ENABLE = {TRUE | FALSE} PARALLEL_INSTANCE_GROUP = ' text ' PARALLEL_MIN_PERCENT = int PARTITION_VIEW_ENABLED = {TRUE | FALSE} PLSQL_COMPILER_FLAGS = {[DEBUG | NON_DEBUG], [INTERPRETED | NATIVE] } PLSQL_DEBUG = {TRUE | FALSE} QUERY_REWRITE_ENABLED = {FORCE | TRUE | FALSE} QUERY_REWRITE_INTEGRITY = {enforced | trusted | stale_tolerated} REMOTE_DEPENDENCIES_MODE = {TIMESTAMP | SIGNATURE} SESSION_CACHED_CURSORS = int SKIP_UNUSABLE_INDEXES = {TRUE | FALSE} SORT_AREA_RETAINED_SIZE = int SORT_AREA_SIZE = integer SORT_MULTIBLOCK_READ_COUNT = int SQL_TRACE = {TRUE | FALSE} STAR_TRANSFORMATION_ENABLED = {TRUE | FALSE | TEMP_DISABLE} STATISTICS_LEVEL = {ALL | TYPICAL | BASIC} TIMED_OS_STATISTICS = int TIMED_STATISTICS = {TRUE | FALSE} TRACE_ENABLED = {TRUE | FALSE} UNDO_SUPRESS_ERRORS = {TRUE | FALSE} USE_PRIVATE_OUTLINES = {TRUE | FALSE| 'category_name' } USE_STORED_OUTLINES = {TRUE | FALSE| 'category_name' } WORKSIZE_AREA_POLICY = {AUTO | MANUAL} Parameters shown in Green&Bold are Session Parameters, generally these are not reflected in V$PARAMETER (Some sessions paramaters are synonymous with parameter settings in init.ora) DEPRACATED OPTIONS... Version 8 Options - obsolete in v9 FAST_START_IO_TARGET = int HASH_MULTIBLOCK_IO_COUNT = int LABEL = {'text' | DBLOW | DBHIGH | OSLABEL} OPTIMIZER_PERCENT_PARALLEL = int PARALLEL_BROADCAST_ENABLED = {TRUE | FALSE} PLSQL_V2_COMPATIBILITY = {TRUE | FALSE} Version 7 Options - obsolete in v8 CLOSE_CACHED_OPEN_CURSORS = {TRUE | FALSE} NLS_ISO_CURRENCY = territory MLS_LABEL_FORMAT = 'fmt' OPTIMISER_GOAL - is now OPTIMISER_MODE SCHEMA=schema_name
ALTER DATABASE
Open an existing database, and /or modify associated files.
Syntax:ALTER DATABASE database_name options
Options:
open / mount options: MOUNT MOUNT STANDBY DATABASE MOUNT CLONE DATABASE MOUNT PARALLEL MOUNT STANDBY DATABASE CONVERT OPEN [READ ONLY] OPEN [READ WRITE] RESETLOGS|NORESETLOGS [MIGRATE] ACTIVATE STANDBY DATABASE [NATIONAL] CHARACTER SET char_set archivelog options: ARCHIVELOG NOARCHIVELOG backup and recovery options: BACKUP CONTROLFILE TO 'filename' [REUSE] BACKUP CONTROLFILE TO TRACE [RESETLOGS] [AS 'filename' [REUSE]] CREATE STANDBY CONTROLFILE AS 'filename' [REUSE] RECOVER recover_clause RECOVER MANAGED STANDBY standby_recover_clause END BACKUP Datafile options: CREATE DATAFILE 'filename' AS filespec DATAFILE 'filename' ONLINE DATAFILE 'filename' OFFLINE [DROP] DATAFILE 'filename' RESIZE int K | M DATAFILE 'filename' AUTOEXTEND OFF DATAFILE 'filename' AUTOEXTEND ON [NEXT int K | M] [MAXSIZE int K | M | UNLIMITED] DATAFILE 'filename' END BACKUP RENAME FILE 'data_file_name' TO 'data_file_name' TEMPFILE 'filename' ONLINE TEMPFILE 'filename' OFFLINE TEMPFILE 'filename' DROP [INCLUDING DATAFILES] TEMPFILE 'filename' RESIZE int K | M TEMPFILE 'filename' AUTOEXTEND OFF TEMPFILE 'filename' AUTOEXTEND ON [NEXT int K | M] [MAXSIZE int K | M | UNLIMITED] redo log options: ADD LOGFILE [THREAD int] [GROUP int] filespec ADD LOGFILE MEMBER 'filename' [REUSE] TO GROUP int ADD LOGFILE MEMBER 'filename' [REUSE] TO 'filename' DROP LOGFILE GROUP int DROP LOGFILE ('filename') DROP LOGFILE MEMBER 'filename' RENAME FILE 'redolog_file_name' TO 'redolog_file_name' CLEAR [UNARCHIVED] LOGFILE GROUP int [UNRECOVERABLE DATAFILE] CLEAR [UNARCHIVED] LOGFILE ('filename') [UNRECOVERABLE DATAFILE] Parallel server options: CREATE STANDBY CONTROLFILE AS 'filename' [REUSE] SET DBLOW = 'text' SET DBHIGH = 'text' SET DBMAC = ON | OFF ENABLE [PUBLIC] THREAD int DISABLE THREAD int Backwards compatibility options: RENAME GLOBAL_NAME TO database [domain] RESET COMPATIBILITY
Apart from RENAME, any option above that includes a 'filename' can be extended to cover multiple files using the syntax: ('filename1', 'filename2')
database_name
is defined when the database is created - it is normally set to the same as the database SID.
Some of the commands above can only be used when the database is in a particular state:
MOUNT, CONVERT - Require that the db is Not Mounted.
ARCHIVELOG, NOARCHIVLOG, RECOVER - Require that the db is Mounted but not open (must be mount exclusive - not mount parallel).
ENABLE, DISABLE, RENAME GLOBAL_NAME, RESET, SET - Require that the db is Open.
ALTER SYSTEM
Modify system settings.
Syntax:ALTER SYSTEM ARCHIVE LOG archive_log_clause ALTER SYSTEM CHECKPOINT [GLOBAL | LOCAL] ALTER SYSTEM CHECK DATAFILES [GLOBAL | LOCAL] ALTER SYSTEM FLUSH SHARED POOL ALTER SYSTEM {ENABLE | DISABLE} DISTRIBUTED RECOVERY ALTER SYSTEM {ENABLE | DISABLE} RESTRICTED SESSION ALTER SYSTEM RESUME ALTER SYSTEM SUSPEND ALTER SYSTEM SHUTDOWN [IMMEDIATE] dispatcher_name ALTER SYSTEM SWITCH LOGFILE ALTER SYSTEM KILL SESSION 'int1, int2' [POST TRANSACTION] [IMMEDIATE] ALTER SYSTEM DISCONNECT SESSION 'int1, int2' [IMMEDIATE] ALTER SYSTEM SET parameter = value [COMMENT 'text'] [DEFERRED] [Scope_options] ALTER SYSTEM RESET parameter(s) [scope_options] ALTER SYSTEM QUIESCE RESTRICTED
ALTER SYSTEM UNQUIESCE SET Parameters: Full list of Static and dynamic parameters. Scope_options: SCOPE = {MEMORY|SPFILE|BOTH} [SID = 'sid' [,SID =...]] DEFERRED - Set parameter values for future connecting sessions. Currently active sessions are not affected and they retain the old parameter value. This is required for parameters that have the ISSSYS_MODIFIABLE =DEFERRED (in V$PARAMETER) This is optional for parameters that have the ISSSYS_MODIFIABLE =IMMEDIATE (in V$PARAMETER) For static parameters, DEFERRED cannot be specified. COMMENT text is visible in the UPDATE_COMMENT column of V$SpPARAMETER The SID clause is for RAC, where it's possible to change a parameter value for one instance only. SID= '*' will affect all instances on the cluster If the instance is started with an SpFILE the default = * (all instances) If the instance is started with a PFILE then default SID = the current instance.Quiesce
Putting the database into a quiesced state will prevent inactive user sessions from becoming active, Oracle then waits for existing transactions to finish. In shared server mode, Oracle will also block user logins.
This allows SYS/SYSTEM to perform some maintenance tasks without a full shutdown.Notes
All Byte values can also be specified in K or M or Ge.g. you can enter 8388608 or 8192 K or 8M
All directory paths follow standard notation i.e UNIX 'quotes' or Windows "double quotes"
Link URL: http://2in1.spaces.live.com/Blog/cns!AD6C47FFA04D2536!335.entry -
An A-Z Index of Oracle SQL Commands (version 9.2)
2006-12-18 22:48:56
AUDIT
CALL
Cluster - CREATE CLUSTER
€€€€€€€€€€€€€€ - ALTER€€ CLUSTER
€€€€€€€€€€€€€€ - DROP€€€€ CLUSTER
COMMENTCOMMIT
CONNECT
CONSTRAINT - Add / Enable
Context - CREATE CONTEXT
€€€€€€€€€€€€€€ - DROP CONTEXT
Controlfile - CREATE CONTROLFILE
Database - CREATE DATABASE
€€€€€€€€€€€€€€€€ - ALTER€€ DATABASE
DELETE
DESCRIBE
Dimension - CREATE DIMENSION
€€€€€€€€€€€€€€€€€€ - ALTER DIMENSION
€€€€€€€€€€€€€€€€€€ - DROP DIMENSION
Directory - CREATE DIRECTORY
€€€€€€€€€€€€€€€€€€ - DROP DIRECTORY
EXEC
EXECUTE IMMEDIATE
EXPLAIN PLAN
Function - CREATE FUNCTION
€€€€€€€€€€€€€€€€ - ALTER€€ FUNCTION
€€€€€€€€€€€€€€€€ - DROP€€€€ FUNCTION
GRANT
Index - CREATE INDEX
€€€€€€€€€€ - ALTER€€ INDEX
€€€€€€€€€€ - DROP€€€€ INDEX
Indextype - CREATE INDEXTYPE
€€€€€€€€€€€€€€€€€€ - DROP INDEXTYPE
INSERT
INTERSECT
Java - CREATE JAVA
€€€€€€€€ - ALTER JAVA
€€€€€€€€ - DROP JAVA
Library - CREATE LIBRARY
€€€€€€€€€€€€€€ - DROP LIBRARY
Link - CREATE DATABASE LINK
€€€€€€€€ - DROP DATABASE LINK
LOCK TABLE
Mview - CREATE MATERIALIZED VIEW
€€€€€€€€€€ - ALTER MATERIALIZED VIEW
€€€€€€€€€€ - DROP MATERIALIZED VIEW
€€€€€€€€€€ - CREATE MATERIALIZED VIEW LOG
€€€€€€€€€€ - ALTER MATERIALIZED VIEW LOG
€€€€€€€€€€ - DROP MATERIALIZED VIEW LOG
MINUS
NOAUDIT
Operator - CREATE OPERATOR
€€€€€€€€€€€€€€€€ - DROP OPERATOR
Outline - CREATE OUTLINE
€€€€€€€€€€€€€€ - ALTER OUTLINE
€€€€€€€€€€€€€€ - DROP OUTLINE
Package - CREATE PACKAGE/BODY
€€€€€€€€€€€€€€ - ALTER€€ PACKAGE
€€€€€€€€€€€€€€ - DROP€€€€ PACKAGE
Pfile - CREATE PFILE
Procedure - CREATE PROCEDURE
€€€€€€€€€€€€€€€€€€ - ALTER€€ PROCEDURE
€€€€€€€€€€€€€€€€€€ - DROP€€€€ PROCEDURE
Profile - CREATE PROFILE
€€€€€€€€€€€€€€ - ALTER€€ PROFILE
€€€€€€€€€€€€€€ - DROP€€€€ PROFILE
RECOVER
RENAME
Resource - ALTER RESOURCE COST
REVOKE
RMAN - Recovery Manager
Role - CREATE ROLE
€€€€€€€€ - SET€€€€€€ ROLE
€€€€€€€€ - ALTER€€ ROLE
€€€€€€€€ - DROP€€€€ ROLE
ROLLBACK
Rollback - CREATE ROLLBACK SEGMENT
€€€€€€€€€€€€€€€€ - ALTER€€ ROLLBACK SEGMENT
€€€€€€€€€€€€€€€€ - DROP€€€€ ROLLBACK SEGMENT
SAVEPOINT
Schema - CREATE SCHEMA
SELECT
Sequence - CREATE SEQUENCE
€€€€€€€€€€€€€€€€ - ALTER€€ SEQUENCE
€€€€€€€€€€€€€€€€ - DROP€€€€ SEQUENCE
Session - ALTER SESSION
SHUTDOWN
SNAPSHOT
SPfile - CREATE SPFILE
STARTUP
Statistics - ASSOCIATE STATISTICS
€€€€€€€€€€€€€€€€€€€€ - DISASSOCIATE STATISTICS
Synonym - CREATE SYNONYM
€€€€€€€€€€€€€€ - DROP€€€€ SYNONYM
System - ALTER SYSTEM
Table - CREATE TABLE
€€€€€€€€€€ - ALTER€€ TABLE
€€€€€€€€€€ - DROP€€€€ TABLE
Tablespace - CREATE TABLESPACE
€€€€€€€€€€€€€€€€€€€€ - ALTER€€ TABLESPACE
€€€€€€€€€€€€€€€€€€€€ - DROP€€€€ TABLESPACE
€€€€€€€€€€€€€€€€€€€€ - CREATE TEMPORARY TABLESPACE
Transaction - SET TRANSACTION
Trigger - CREATE TRIGGER
€€€€€€€€€€€€€€ - ALTER€€ TRIGGER
€€€€€€€€€€€€€€ - DROP€€€€ TRIGGER
TRUNCATE
Type - CREATE TYPE
€€€€€€€€ - ALTER TYPE
€€€€€€€€ - DROP TYPE
€€€€€€€€ - CREATE TYPE BODY
€€€€€€€€ - DROP TYPE BODY
UPDATE
UNION
User - CREATE USER
€€€€€€€€ - ALTER€€ USER
€€€€€€€€ - DROP€€€€ USER
View - CREATE VIEW
€€€€€€€€ - ALTER€€ VIEW
€€€€€€€€ - DROP€€€€ VIEW
SYNTAX:
Words in CAPS are Oracle commands, words in lower-case are the options you can modify.
Sections enclosed in[]
are optional, underlined options are the default
Sections enclosed in{}
are alternatives. The pipe symbol | indicates OR (more)
Link URL: http://2in1.spaces.live.com/Blog/cns!AD6C47FFA04D2536!336.entry -
Dynamic Performance View
2006-12-18 22:48:56
-
ÓÅ»¯²ßÂÔ
2006-12-18 22:48:56
ORACLEÊý¾Ý¿âÐÔÄÜÓÅ»¯¸ÅÊö
¡¡¡¡Êµ¼ÊÉÏ£¬ÎªÁ˱£Ö¤ORACLEÊý¾Ý¿âÔËÐÐÔÚ×î¼ÑµÄÐÔÄÜ״̬Ï£¬ÔÚÐÅϢϵͳ¿ª·¢Ö®Ç°¾ÍÓ¦¸Ã¿¼ÂÇÊý¾Ý¿âµÄÓÅ»¯²ßÂÔ¡£ÓÅ»¯²ßÂÔÒ»°ã°üÀ¨·þÎñÆ÷²Ù×÷ϵͳ²ÎÊýµ÷Õû¡¢ORACLEÊý¾Ý¿â²ÎÊýµ÷Õû¡¢ÍøÂçÐÔÄܵ÷Õû¡¢Ó¦ÓóÌÐòSQLÓï¾ä·ÖÎö¼°Éè¼ÆµÈ¼¸¸ö·½Ã棬ÆäÖÐÓ¦ÓóÌÐòµÄ·ÖÎöÓëÉè¼ÆÊÇÔÚÐÅϢϵͳ¿ª·¢Ö®Ç°Íê³ÉµÄ¡£
¡¡¡¡·ÖÎöÆÀ¼ÛORACLEÊý¾Ý¿âÐÔÄÜÖ÷ÒªÓÐÊý¾Ý¿âÍÌÍÂÁ¿¡¢Êý¾Ý¿âÓû§ÏìӦʱ¼äÁ½ÏîÖ¸±ê¡£Êý¾Ý¿âÍÌÍÂÁ¿ÊÇÖ¸µ¥Î»Ê±¼äÄÚÊý¾Ý¿âÍê³ÉµÄSQLÓï¾äÊýÄ¿£»Êý¾Ý¿âÓû§ÏìӦʱ¼äÊÇÖ¸Óû§´ÓÌá½»SQLÓï¾ä¿ªÊ¼µ½»ñµÃ½á¹ûµÄÄÇÒ»¶Îʱ¼ä¡£Êý¾Ý¿âÓû§ÏìӦʱ¼äÓÖ¿ÉÒÔ·ÖΪϵͳ·þÎñʱ¼äºÍÓû§µÈ´ýʱ¼äÁ½Ï¼´£º
¡¡¡¡Êý¾Ý¿âÓû§ÏìӦʱ¼ä£½ÏµÍ³·þÎñʱ¼ä £« Óû§µÈ´ýʱ¼ä
¡¡¡¡ÉÏÊö¹«Ê½¸æËßÎÒÃÇ£¬»ñµÃÂúÒâµÄÓû§ÏìӦʱ¼äÓÐÁ½¸ö;¾¶£ºÒ»ÊǼõÉÙϵͳ·þÎñʱ¼ä£¬¼´Ìá¸ßÊý¾Ý¿âµÄÍÌÍÂÁ¿£»¶þÊǼõÉÙÓû§µÈ´ýʱ¼ä£¬¼´¼õÉÙÓû§·ÃÎÊͬһÊý¾Ý¿â×ÊÔ´µÄ³åÍ»ÂÊ¡£
¡¡¡¡Êý¾Ý¿âÐÔÄÜÓÅ»¯°üÀ¨Èçϼ¸¸ö²¿·Ö£º
¡¡¡¡1¡¢µ÷ÕûÊý¾Ý½á¹¹µÄÉè¼Æ¡£ÕâÒ»²¿·ÖÔÚ¿ª·¢ÐÅϢϵͳ֮ǰÍê³É£¬³ÌÐòÔ±ÐèÒª¿¼ÂÇÊÇ·ñʹÓÃORACLEÊý¾Ý¿âµÄ·ÖÇø¹¦ÄÜ£¬¶ÔÓÚ¾³£·ÃÎʵÄÊý¾Ý¿â±íÊÇ·ñÐèÒª½¨Á¢Ë÷ÒýµÈ¡£
¡¡¡¡2¡¢µ÷ÕûÓ¦ÓóÌÐò½á¹¹Éè¼Æ¡£ÕâÒ»²¿·ÖÒ²ÊÇÔÚ¿ª·¢ÐÅϢϵͳ֮ǰÍê³É£¬³ÌÐòÔ±ÔÚÕâÒ»²½ÐèÒª¿¼ÂÇÓ¦ÓóÌÐòʹÓÃʲôÑùµÄÌåϵ½á¹¹£¬ÊÇʹÓô«Í³µÄClient/ServerÁ½²ãÌåϵ½á¹¹£¬»¹ÊÇʹÓÃBrowser/Web/DatabaseµÄÈý²ãÌåϵ½á¹¹¡£²»Í¬µÄÓ¦ÓóÌÐòÌåϵ½á¹¹ÒªÇóµÄÊý¾Ý¿â×ÊÔ´ÊDz»Í¬µÄ¡£
¡¡¡¡3¡¢µ÷ÕûÊý¾Ý¿âSQLÓï¾ä¡£Ó¦ÓóÌÐòµÄÖ´ÐÐ×îÖÕ½«¹é½áΪÊý¾Ý¿âÖеÄSQLÓï¾äÖ´ÐУ¬Òò´ËSQLÓï¾äµÄÖ´ÐÐЧÂÊ×îÖÕ¾ö¶¨ÁËORACLEÊý¾Ý¿âµÄÐÔÄÜ¡£ORACLE¹«Ë¾ÍƼöʹÓÃORACLEÓï¾äÓÅ»¯Æ÷£¨Oracle Optimizer£©ºÍÐÐËø¹ÜÀíÆ÷£¨row-level manager£©À´µ÷ÕûÓÅ»¯SQLÓï¾ä¡£
¡¡¡¡4¡¢µ÷Õû·þÎñÆ÷ÄÚ´æ·ÖÅä¡£ÄÚ´æ·ÖÅäÊÇÔÚÐÅϢϵͳÔËÐйý³ÌÖÐÓÅ»¯ÅäÖõģ¬Êý¾Ý¿â¹ÜÀíÔ±¿ÉÒÔ¸ù¾ÝÊý¾Ý¿âÔËÐÐ×´¿öµ÷ÕûÊý¾Ý¿âϵͳȫ¾ÖÇø£¨SGAÇø£©µÄÊý¾Ý»º³åÇø¡¢ÈÕÖ¾»º³åÇøºÍ¹²Ïí³ØµÄ´óС£»»¹¿ÉÒÔµ÷Õû³ÌÐòÈ«¾ÖÇø£¨PGAÇø£©µÄ´óС¡£ÐèҪעÒâµÄÊÇ£¬SGAÇø²»ÊÇÔ½´óÔ½ºÃ£¬SGAÇø¹ý´ó»áÕ¼ÓòÙ×÷ϵͳʹÓõÄÄÚ´æ¶øÒýÆðÐéÄâÄÚ´æµÄÒ³Ãæ½»»»£¬ÕâÑù·´¶ø»á½µµÍϵͳ¡£
¡¡¡¡5¡¢µ÷ÕûÓ²ÅÌI/O£¬ÕâÒ»²½ÊÇÔÚÐÅϢϵͳ¿ª·¢Ö®Ç°Íê³ÉµÄ¡£Êý¾Ý¿â¹ÜÀíÔ±¿ÉÒÔ½«×é³Éͬһ¸ö±í¿Õ¼äµÄÊý¾ÝÎļþ·ÅÔÚ²»Í¬µÄÓ²ÅÌÉÏ£¬×öµ½Ó²ÅÌÖ®¼äI/O¸ºÔؾùºâ¡£
¡¡¡¡6¡¢µ÷Õû²Ù×÷ϵͳ²ÎÊý£¬ÀýÈ磺ÔËÐÐÔÚUNIX²Ù×÷ϵͳÉϵÄORACLEÊý¾Ý¿â£¬¿ÉÒÔµ÷ÕûUNIXÊý¾Ý»º³å³ØµÄ´óС£¬Ã¿¸ö½ø³ÌËùÄÜʹÓõÄÄÚ´æ´óСµÈ²ÎÊý¡£
¡¡¡¡Êµ¼ÊÉÏ£¬ÉÏÊöÊý¾Ý¿âÓÅ»¯´ëÊ©Ö®¼äÊÇÏ໥ÁªÏµµÄ¡£ORACLEÊý¾Ý¿âÐÔÄܶñ»¯±íÏÖ»ù±¾É϶¼ÊÇÓû§ÏìӦʱ¼ä±È½Ï³¤£¬ÐèÒªÓû§³¤Ê±¼äµÄµÈ´ý¡£µ«ÐÔÄܶñ»¯µÄÔÒòÈ´ÊǶàÖÖ¶àÑùµÄ£¬ÓÐʱÊǶà¸öÒòËع²Í¬Ôì³ÉÁËÐÔÄܶñ»¯µÄ½á¹û£¬Õâ¾ÍÐèÒªÊý¾Ý¿â¹ÜÀíÔ±ÓбȽÏÈ«ÃæµÄ¼ÆËã»ú֪ʶ£¬Äܹ»Ãô¸ÐµØ²ì¾õµ½Ó°ÏìÊý¾Ý¿âÐÔÄܵÄÖ÷ÒªÔÒòËùÔÚ¡£ÁíÍ⣬Á¼ºÃµÄÊý¾Ý¿â¹ÜÀí¹¤¾ß¶ÔÓÚÓÅ»¯Êý¾Ý¿âÐÔÄÜÒ²ÊǺÜÖØÒªµÄ¡£
¡¡¡¡ORACLEÊý¾Ý¿âÐÔÄÜÓÅ»¯¹¤¾ß
¡¡¡¡³£ÓõÄÊý¾Ý¿âÐÔÄÜÓÅ»¯¹¤¾ßÓУº
¡¡¡¡1¡¢ORACLEÊý¾Ý¿âÔÚÏßÊý¾Ý×ֵ䣬ORACLEÔÚÏßÊý¾Ý×ÖµäÄܹ»·´Ó³³öORACLE¶¯Ì¬ÔËÐÐÇé¿ö£¬¶ÔÓÚµ÷ÕûÊý¾Ý¿âÐÔÄÜÊǺÜÓаïÖúµÄ¡£
¡¡¡¡2¡¢²Ù×÷ϵͳ¹¤¾ß£¬ÀýÈçUNIX²Ù×÷ϵͳµÄvmstat£¬iostatµÈÃüÁî¿ÉÒԲ鿴µ½ÏµÍ³ÏµÍ³¼¶ÄÚ´æºÍÓ²ÅÌI/OµÄʹÓÃÇé¿ö£¬ÕâЩ¹¤¾ß¶ÔÓÚ¹ÜÀíԱŪÇå³öϵͳƿ¾±³öÏÖÔÚʲôµØ·½ÓÐʱºòºÜÓÐÓá£
¡¡¡¡4¡¢ORACLE Enterprise Manager£¨OEM£©£¬ÕâÊÇÒ»¸öͼÐεÄÓû§¹ÜÀí½çÃ棬Óû§¿ÉÒÔʹÓÃËü·½±ãµØ½øÐÐÊý¾Ý¿â¹ÜÀí¶ø²»±Ø¼Çס¸´ÔÓµÄORACLEÊý¾Ý¿â¹ÜÀíµÄÃüÁî¡£5¡¢EXPLAIN PLAN¡ª¡ªSQLÓïÑÔÓÅ»¯ÃüÁʹÓÃÕâ¸öÃüÁî¿ÉÒÔ°ïÖú³ÌÐòԱд³ö¸ßЧµÄSQLÓïÑÔ¡£
¡¡¡¡ORACLEÊý¾Ý¿âµÄϵͳÐÔÄÜÆÀ¹À
¡¡¡¡ÐÅϢϵͳµÄÀàÐͲ»Í¬£¬ÐèÒª¹Ø×¢µÄÊý¾Ý¿â²ÎÊýÒ²ÊDz»Í¬µÄ¡£Êý¾Ý¿â¹ÜÀíÔ±ÐèÒª¸ù¾Ý×Ô¼ºµÄÐÅϢϵͳµÄÀàÐÍ×ÅÖØ¿¼ÂDz»Í¬µÄÊý¾Ý¿â²ÎÊý¡£
¡¡¡¡1¡¢ÔÚÏßÊÂÎñ´¦ÀíÐÅϢϵͳ£¨OLTP£©£¬ÕâÖÖÀàÐ͵ÄÐÅϢϵͳһ°ãÐèÒªÓдóÁ¿µÄInsert¡¢Update²Ù×÷£¬µäÐ͵Äϵͳ°üÀ¨Ãñº½»úƱ·¢ÊÛϵͳ¡¢ÒøÐд¢ÐîϵͳµÈ¡£OLTPϵͳÐèÒª±£Ö¤Êý¾Ý¿âµÄ²¢·¢ÐÔ¡¢¿É¿¿ÐÔºÍ×îÖÕÓû§µÄËٶȣ¬ÕâÀàϵͳʹÓõÄORACLEÊý¾Ý¿âÐèÒªÖ÷Òª¿¼ÂÇÏÂÊö²ÎÊý£º
¡¡¡¡l Êý¾Ý¿â»Ø¹ö¶ÎÊÇ·ñ×ã¹»£¿
¡¡¡¡l ÊÇ·ñÐèÒª½¨Á¢ORACLEÊý¾Ý¿âË÷Òý¡¢¾Û¼¯¡¢É¢ÁУ¿
¡¡¡¡l ϵͳȫ¾ÖÇø£¨SGA£©´óСÊÇ·ñ×ã¹»£¿
¡¡¡¡l SQLÓï¾äÊÇ·ñ¸ßЧ£¿
¡¡¡¡2¡¢Êý¾Ý²Ö¿âϵͳ£¨Data Warehousing£©£¬ÕâÖÖÐÅϢϵͳµÄÖ÷ÒªÈÎÎñÊÇ´ÓORACLEµÄº£Á¿Êý¾ÝÖнøÐвéѯ£¬µÃµ½Êý¾ÝÖ®¼äµÄijЩ¹æÂÉ¡£Êý¾Ý¿â¹ÜÀíÔ±ÐèҪΪÕâÖÖÀàÐ͵ÄORACLEÊý¾Ý¿â×ÅÖØ¿¼ÂÇÏÂÊö²ÎÊý£º
¡¡¡¡l ÊÇ·ñ²ÉÓÃB*-Ë÷Òý»òÕßbitmapË÷Òý£¿
¡¡¡¡l ÊÇ·ñ²ÉÓò¢ÐÐSQL²éѯÒÔÌá¸ß²éѯЧÂÊ£¿
¡¡¡¡l ÊÇ·ñ²ÉÓÃPL/SQLº¯Êý±àд´æ´¢¹ý³Ì£¿
¡¡¡¡l ÓбØÒªµÄ»°£¬ÐèÒª½¨Á¢²¢ÐÐÊý¾Ý¿âÌá¸ßÊý¾Ý¿âµÄ²éѯЧÂÊ
¡¡¡¡SQLÓï¾äµÄµ÷ÕûÔÔò
¡¡¡¡SQLÓïÑÔÊÇÒ»ÖÖÁé»îµÄÓïÑÔ£¬ÏàͬµÄ¹¦ÄÜ¿ÉÒÔʹÓò»Í¬µÄÓï¾äÀ´ÊµÏÖ£¬µ«ÊÇÓï¾äµÄÖ´ÐÐЧÂÊÊǺܲ»ÏàͬµÄ¡£³ÌÐòÔ±¿ÉÒÔʹÓÃEXPLAIN PLANÓï¾äÀ´±È½Ï¸÷ÖÖʵÏÖ·½°¸£¬²¢Ñ¡³ö×îÓŵÄʵÏÖ·½°¸¡£×ܵÃÀ´½²£¬³ÌÐòԱдSQLÓï¾äÐèÒªÂú×㿼ÂÇÈçϹæÔò£º
¡¡¡¡1¡¢¾¡Á¿Ê¹ÓÃË÷Òý¡£ÊԱȽÏÏÂÃæÁ½ÌõSQLÓï¾ä£º
¡¡¡¡Óï¾äA£ºSELECT dname, deptno FROM dept WHERE deptno NOT IN
¡¡¡¡(SELECT deptno FROM emp);
¡¡¡¡Óï¾äB£ºSELECT dname, deptno FROM dept WHERE NOT EXISTS
¡¡¡¡(SELECT deptno FROM emp WHERE dept.deptno = emp.deptno);
¡¡¡¡ÕâÁ½Ìõ²éѯÓï¾äʵÏֵĽá¹ûÊÇÏàͬµÄ£¬µ«ÊÇÖ´ÐÐÓï¾äAµÄʱºò£¬ORACLE»á¶ÔÕû¸öemp±í½øÐÐɨÃ裬ûÓÐʹÓý¨Á¢ÔÚemp±íÉϵÄdeptnoË÷Òý£¬Ö´ÐÐÓï¾äBµÄʱºò£¬ÓÉÓÚÔÚ×Ó²éѯÖÐʹÓÃÁËÁªºÏ²éѯ£¬ORACLEÖ»ÊǶÔemp±í½øÐеIJ¿·ÖÊý¾ÝɨÃ裬²¢ÀûÓÃÁËdeptnoÁеÄË÷Òý£¬ËùÒÔÓï¾äBµÄЧÂÊÒª±ÈÓï¾äAµÄЧÂʸßһЩ¡£
¡¡¡¡2¡¢Ñ¡ÔñÁªºÏ²éѯµÄÁªºÏ´ÎÐò¡£¿¼ÂÇÏÂÃæµÄÀý×Ó£º
¡¡¡¡SELECT stuff FROM taba a, tabb b, tabc c
¡¡¡¡WHERE a.acol between :alow and :ahigh
¡¡¡¡AND b.bcol between :blow and :bhigh
¡¡¡¡AND c.ccol between :clow and :chigh
¡¡¡¡AND a.key1 = b.key1
¡¡¡¡AMD a.key2 = c.key2;
¡¡¡¡Õâ¸öSQLÀý×ÓÖУ¬³ÌÐòÔ±Ê×ÏÈÐèҪѡÔñÒª²éѯµÄÖ÷±í£¬ÒòΪÖ÷±íÒª½øÐÐÕû¸ö±íÊý¾ÝµÄɨÃ裬ËùÒÔÖ÷±íÓ¦¸ÃÊý¾ÝÁ¿×îС£¬ËùÒÔÀý×ÓÖбíAµÄacolÁеķ¶Î§Ó¦¸Ã±È±íBºÍ±íCÏàÓ¦Áеķ¶Î§Ð¡¡£
¡¡¡¡3¡¢ÔÚ×Ó²éѯÖÐÉ÷ÖØʹÓÃIN»òÕßNOT INÓï¾ä£¬Ê¹ÓÃwhere (NOT) existsµÄЧ¹ûÒªºÃµÄ¶à¡£
¡¡¡¡4¡¢É÷ÖØʹÓÃÊÓͼµÄÁªºÏ²éѯ£¬ÓÈÆäÊDZȽϸ´ÔÓµÄÊÓͼ֮¼äµÄÁªºÏ²éѯ¡£Ò»°ã¶ÔÊÓͼµÄ²éѯ×îºÃ¶¼·Ö½âΪ¶ÔÊý¾Ý±íµÄÖ±½Ó²éѯЧ¹ûÒªºÃһЩ¡£
¡¡¡¡5¡¢¿ÉÒÔÔÚ²ÎÊýÎļþÖÐÉèÖÃSHARED_POOL_RESERVED_SIZE²ÎÊý£¬Õâ¸ö²ÎÊýÔÚSGA¹²Ïí³ØÖб£ÁôÒ»¸öÁ¬ÐøµÄÄÚ´æ¿Õ¼ä£¬Á¬ÐøµÄÄÚ´æ¿Õ¼äÓÐÒæÓÚ´æ·Å´óµÄSQL³ÌÐò°ü¡£
¡¡¡¡6¡¢ORACLE¹«Ë¾ÌṩµÄDBMS_SHARED_POOL³ÌÐò¿ÉÒÔ°ïÖú³ÌÐòÔ±½«Ä³Ð©¾³£Ê¹ÓõĴ洢¹ý³Ì¡°¶¤¡±ÔÚSQLÇøÖжø²»±»»»³öÄڴ棬³ÌÐòÔ±¶ÔÓÚ¾³£Ê¹Óò¢ÇÒÕ¼ÓÃÄÚ´æºÜ¶àµÄ´æ´¢¹ý³Ì¡°¶¤¡±µ½ÄÚ´æÖÐÓÐÀûÓÚÌá¸ß×îÖÕÓû§µÄÏìӦʱ¼ä¡£
¡¡¡¡CPU²ÎÊýµÄµ÷Õû
¡¡¡¡CPUÊÇ·þÎñÆ÷µÄÒ»ÏîÖØÒª×ÊÔ´£¬·þÎñÆ÷Á¼ºÃµÄ¹¤×÷״̬ÊÇÔÚ¹¤×÷¸ß·åʱCPUµÄʹÓÃÂÊÔÚ90£¥ÒÔÉÏ¡£Èç¹û¿ÕÏÐʱ¼äCPUʹÓÃÂʾÍÔÚ90£¥ÒÔÉÏ£¬ËµÃ÷·þÎñÆ÷ȱ·¦CPU×ÊÔ´£¬Èç¹û¹¤×÷¸ß·åʱCPUʹÓÃÂÊÈÔÈ»ºÜµÍ£¬ËµÃ÷·þÎñÆ÷CPU×ÊÔ´»¹±È½Ï¸»Óà¡£
¡¡¡¡Ê¹ÓòÙ×÷ÏàͬÃüÁî¿ÉÒÔ¿´µ½CPUµÄʹÓÃÇé¿ö£¬Ò»°ãUNIX²Ù×÷ϵͳµÄ·þÎñÆ÷£¬¿ÉÒÔʹÓÃsar €€uÃüÁî²é¿´CPUµÄʹÓÃÂÊ£¬NT²Ù×÷ϵͳµÄ·þÎñÆ÷£¬¿ÉÒÔʹÓÃNTµÄÐÔÄܹÜÀíÆ÷À´²é¿´CPUµÄʹÓÃÂÊ¡£Êý¾Ý¿â¹ÜÀíÔ±¿ÉÒÔͨ¹ý²é¿´v$sysstatÊý¾Ý×ÖµäÖС°CPU used by this session¡±Í³¼ÆÏîµÃÖªORACLEÊý¾Ý¿âʹÓõÄCPUʱ¼ä£¬²é¿´¡°OS User level CPU time¡±Í³¼ÆÏîµÃÖª²Ù×÷ϵͳÓû§Ì¬ÏµÄCPUʱ¼ä£¬²é¿´¡°OS System call CPU time¡±Í³¼ÆÏîµÃÖª²Ù×÷ϵͳϵͳ̬ϵÄCPUʱ¼ä£¬²Ù×÷ϵͳ×ܵÄCPUʱ¼ä¾ÍÊÇÓû§Ì¬ºÍϵͳ̬ʱ¼äÖ®ºÍ£¬Èç¹ûORACLEÊý¾Ý¿âʹÓõÄCPUʱ¼äÕ¼²Ù×÷ϵͳ×ܵÄCPUʱ¼ä90£¥ÒÔÉÏ£¬ËµÃ÷·þÎñÆ÷CPU»ù±¾Éϱ»ORACLEÊý¾Ý¿âʹÓÃ×Å£¬ÕâÊǺÏÀí£¬·´Ö®£¬ËµÃ÷·þÎñÆ÷CPU±»ÆäËü³ÌÐòÕ¼Óùý¶à£¬ORACLEÊý¾Ý¿âÎÞ·¨µÃµ½¸ü¶àµÄCPUʱ¼ä¡£
¡¡¡¡Êý¾Ý¿â¹ÜÀíÔ±»¹¿ÉÒÔͨ¹ý²é¿´v$sesstatÊý¾Ý×ÖµäÀ´»ñµÃµ±Ç°Á¬½ÓORACLEÊý¾Ý¿â¸÷¸ö»á»°Õ¼ÓõÄCPUʱ¼ä£¬´Ó¶øµÃ֪ʲô»á»°ºÄÓ÷þÎñÆ÷CPU±È½Ï¶à¡£
¡¡¡¡³öÏÖCPU×ÊÔ´²»×ãµÄÇé¿öÊǺܶàµÄ£ºSQLÓï¾äµÄÖؽâÎö¡¢µÍЧÂʵÄSQLÓï¾ä¡¢Ëø³å
Link URL: http://2in1.spaces.live.com/Blog/cns!AD6C47FFA04D2536!365.entry -
OracleÐÔÄÜÓÅ»¯ÊµÀý
2006-12-18 22:48:56
ÎÒµÄÀ¸Ä¿
±êÌâËÑË÷
ÎҵĴ浵
Êý¾Ýͳ¼Æ
- ·ÃÎÊÁ¿: 24440
- ÈÕÖ¾Êý: 56
- ͼƬÊý: 1
- ÎļþÊý: 3
- ÊéÇ©Êý: 2
- ½¨Á¢Ê±¼ä: 2006-12-06
- ¸üÐÂʱ¼ä: 2009-06-10