Toad? for Oracle
QuestºçÌìÈí¼þ£¨±±¾©£©ÓÐÏÞ¹«Ë¾
¶þÁãÁãÁùÄê°ËÔÂ
Ó¦Óÿª·¢½â¾ö·½°¸
Ŀ ¼
1. 2.
·½°¸¼ò½é..................................................................................................................................4 TOAD? FOR ORACLE........................................................................................................5 2.1. SCHEMA BROSWER............................................................................................................6 2.2. SQL EDITOR......................................................................................................................6 2.3. PROCEDURE EDITOR..........................................................................................................7 2.4. SQL MODELER..................................................................................................................8 2.5. FASTREPORT......................................................................................................................9 2.6. SCRIPT MANAGER............................................................................................................10 2.7. MASTER/DETAIL BROWSER.............................................................................................10 2.8. CONNECTION COLOR-CODING.........................................................................................11 3.
TOAD? FOR ORACLE PROFESSIONAL......................................................................11 3.1. PL/SQL DEBUGGER.........................................................................................................12 3.2. CODE PROFILING.............................................................................................................12 3.3. KNOWLEDGE XPERT? FOR PL/SQL...............................................................................13 3.4. TEAM CODING.................................................................................................................14 3.5. CODE XPERT....................................................................................................................14 4.
TOAD? FOR ORACLE XPERT.......................................................................................15 4.1. SQL SCANNER.................................................................................................................15 4.2. SQL INSPECTOR...............................................................................................................15 4.3. SQL OPTIMIZER...............................................................................................................16 4.4. INDEX EXPERT.................................................................................................................19 4.5. CROSS INDEX ANALYSIS..................................................................................................19 4.6. OUTLINE MANAGER........................................................................................................20 4.7. PLAN CHANGE ANALYZER...............................................................................................20 4.8. BEST PRACTICES..............................................................................................................22 5.
TOAD? FOR ORACLE SUITE.........................................................................................22 5.1. DBA MODULE.................................................................................................................22 5.1.1. Database Monitor...................................................................................................22 5.1.2. Database Probe.......................................................................................................23 5.1.3. Health Check...........................................................................................................24 5.1.4. Instance Manager....................................................................................................24 5.1.5. Top Session Finder..................................................................................................25 5.1.6. Oracle Parameters..................................................................................................26 5.1.7. Session Browser......................................................................................................26 5.2. KNOWLEDGE XPERT? FOR ORACLE ADMINISTRATION..................................................27 5.3. DATAFACTORY? DEVELOPER EDITION..........................................................................27 5.4. BENCHMARK FACTORY? FOR DATABASES.....................................................................27
2
Ó¦Óÿª·¢½â¾ö·½°¸
5.5. TOAD DATA MODELER?.................................................................................................28 5.6. ORACLE E-BUSINESS MODULE........................................................................................30
3
Ó¦Óÿª·¢½â¾ö·½°¸
1. ·½°¸¼ò½é
Toad¨D¨D¼ÓËÙÄãµÄÊý¾Ý¿âÉè¼Æ¡¢¿ª·¢¡¢²âÊԺ͹ÜÀí
Êý¾Ý¿âµÄÓÅÒìÐÔÄܺ͸߿ÉÓÃÐÔÔ´×ÔÓÚÁ¼ºÃµÄÊý¾Ý¿âÉè¼Æ£¬QuestÈí¼þ¹«Ë¾ÎªÄúÌṩÁËToad
Data Modeler¨D¨DÒ»¸öרҵµÄÊý¾Ý¿âÉè¼Æ¹ÜÀí¹¤¾ß£¬¿ÉÒÔ¿ÉÊÓ»¯µÄΪ¸÷ÖÖÊý¾Ý¿âÉú³ÉÓëά»¤ÊµÌå¹ØÏµÍ¼£¬ÊÇÊý¾Ý¿â¿ª·¢ÈËÔ±µÄÀíÏëÑ¡Ôñ¡£Data Modeler¿ÉÒÔͨ¹ýºÏÀí¹æ»®µÄERͼ£¬ÎªÄúÉú³É¸÷ÖÖÊý¾Ý¿âµÄÎïÀí½¨±íSQLÓï¾ä¡£¶øÊý¾Ý¿â±íÖ®¼äµÄÊý¾ÝÁ÷Ïò£¬¿ÉÒÔͨ¹ýÊý¾ÝÁ÷ͼ½øÐз½±ãµÄ¶¨Òå¡£ÔÚÉú³ÉʵÌå¹ØÏµÍ¼µÄʱºò£¬Data Modeler»á¼æ¹ËËùÓÐÀàÐÍÊý¾Ý¿âµÄʵÌå²îÒ죬ÀýÈçÒýÓÃÒ»ÖÂÐÔ£¬Ô¼Êø£¬Óò£¬´¥·¢Æ÷µÈ¡£
QuestÈí¼þ¹«Ë¾µÄÒµ½çÁìÏȵĿª·¢¹¤¾ßToadÄܹ»°ïÖú¿ª·¢ÐÂÊÖÌá¸ß¹¤×÷ЧÂÊ£»°ïÖúÓоÑéµÄ¿ª·¢ÈËÔ±ÍØ¿íÖ°Òµ¼¼ÄÜ¡£ToadµÄ¼¯³É»¯¿ª·¢»·¾³Öаüº¬ÁË´æ´¢¹ý³Ì±àÂ룬ģʽä¯ÀÀ£¬SQL±àÂëµÈÖî¶à¹¦ÄÜ¿ÉÒÔÔÚÊý¾Ý¿âÓ¦Óÿª·¢µÄ¹ý³ÌÖÐÌá¸ß¹¤×÷ЧÂÊ¡£µ÷ÊÔÆ÷£¬SQLÓÅ»¯£¬´úÂëר¼ÒºÍͨÓùÜÀíµÈ¹¦ÄÜ¿ÉÒÔÌá¸ß´úÂëÖÊÁ¿£¬Ìá¸ßϵͳÐÔÄÜ¡£
¶àÏß³Ì±à¼Æ÷ÔÊÐíÓû§Í¬Ê±±à¼¶à¸öÎļþ£¬Ö§³ÖµÄÎļþÀàÐͰüÀ¨SQL£¬PL/SQL£¬HTML£¬JavaºÍÎı¾Îļþ¡£SQL±à¼Æ÷ÖÐÌṩÈȼüÖ§³Ö£¬×Ô¶¯´íÎó¸üÕý£¬ÊäÈëÕì²â£¬Óï·¨¸ßÁÁ£¬°æ±¾¿ØÖƺÍÐí¶àÆäËüÌá¸ß¿ª·¢ËٶȵÄС¹¦ÄÜ¡£Ö§³Ö¶à±êÇ©¹¦ÄܵĴ洢¹ý³Ì±à¼Æ÷¿ÉÒÔÓë¸÷ÖÖSCC¼æÈݵİ汾¿ØÖƳÌÐò½áºÏ£¬Èöà¸ö¿ª·¢Õßͬʱµ÷ÊÔ±àÒë´æ´¢¹ý³Ì¡£
¼ò½àµÄ¶à±êÇ©ÐÎʽչʾµÄģʽä¯ÀÀÆ÷¿ÉÒÔÈÃÄú¿ìËٵĶ¨Î»ºÍ¹ÜÀíÊý¾Ý¿â¶ÔÏó¡£ SQL ModelerÈÃÄúÔÚͼÐη½Ê½Ï¿ìËÙ½¨Á¢¸´ÔӵĶà±í²éѯSQL½Å±¾¡£
·þÎñÆ÷ºÍ»á»°Í³¼Æ£¬°üÀ¨¼ÆËãͳ¼ÆºÍµ÷ÓÅÌáʾÌṩÁË¿ìËٲ鿴·þÎñÆ÷»·¾³µÄÄÜÁ¦¡£ DBAÄ£¿é¿ÉÒÔÈÃÄúÍê³É±È½ÏºÍͬ²½Êý¾Ý¿âģʽ£¬¹ÜÀíÊý¾Ý¿â¿Õ¼ä£¬µ¼³öµ¼ÈëÊý¾ÝµÈËùÓÐDBAÈÕ³£¹¤×÷¡£
SQLµ÷ÓŹ¦ÄÜ£¬¿ÉÒÔ´ÓSQL½Å±¾Îļþ£¬Êý¾Ý¶ÔÏó»òÊý¾Ý¿âSGAÇøÖÐÊÕ¼¯µÍЧµÄSQLÓï¾ä¡£¶ÔÕâЩSQLÓï¾ä½øÐÐ×Ô¶¯¸Äдµ÷ÓÅ£¬Êä³ö¸ßÖÊÁ¿µÄSQLÓï¾ä£¬½µµÍϵͳÏìӦʱ¼ä£¬½µµÍ×ÊԴʹÓá£
ΪÁ˰ïÖúÄúÈ«ÃæµÄ²âÊÔÄúµÄÓ¦ÓÃϵͳ£¬QuestÈí¼þ¹«Ë¾ÎªÄúÌṩÁËBenchmark Factory¨D¨DÒ»¸ö¸ºÔزâÊÔ½â¾ö·½°¸£¬¿ÉÒÔÄ£ÄâÕæÊµ»·¾³ÏÂÊýÒÔǧ¼ÆµÄÓû§·ÃÎÊÄãµÄÓ¦ÓÃϵͳµÄ³¡¾°¡£Ìáǰ»ñÖªÓ¦ÓÃϵͳÉÏÏߺóÔÚ¹ýÔØÇé¿öϵÄÓ¦ÓñíÏÖ£¬¾Í¿ÉÒÔÔÚÉÏÏßǰ¶¨Î»²¢½â¾öÐÔÄÜÎÊÌâºÍÉìËõÐÔÎÊÌâ¡£ÁíÍ⣬QuestÈí¼þ»¹ÌṩÁËÒ»¸ö²âÊÔÊý¾ÝÉú³É¹¤¾ß¨D¨DData Factory£¬¿ÉÒÔ°ïÖú¿ª·¢ºÍQA¹¤³Ìʦ¼òµ¥¿ìËÙµÄÏò²âÊÔÊý¾Ý¿âÖÐÌî³ä¾ßÓÐÒýÓùØÏµµÄ±íÊý¾Ý£¬ÒÔ±ã½øÐвâÊÔ¡£
4
Ó¦Óÿª·¢½â¾ö·½°¸
ÄúÄÜÏàÐÅÂð£¿ÒÔÉϽéÉܵÄÕâЩ¼ò±ãÒ×Ó㬹¦ÄÜÇ¿´óµÄÊý¾Ý¿âÓ¦ÓõÄÉè¼Æ£¬¿ª·¢£¬²âÊÔ£¬¹ÜÀíµÄ¹¤¾ß¶¼ÊÇQuestÈí¼þ¹«Ë¾µÄToadÌ×¼þÖеÄÒ»²¿·Ö¡£Ò²¾ÍÊÇ˵£¬Ñ¡ÔñToad£¬Äú¾ÍÓµÓÐÁËÊý¾Ý¿âÓ¦Óÿª·¢µÄÈ«Ì×½â¾ö·½°¸¡£
Ãæ¶Ô²»Í¬²ã´ÎµÄÊý¾Ý¿â¿ª·¢ºÍ¹ÜÀíÐèÇó£¬Toad for Oracle¹²·ÖΪËĸö°æ±¾£¬²»Í¬Ö°Ô𿪷¢ÈËÔ±¿ÉÒÔ¸ù¾Ý×Ô¼ºµÄʹÓÃÒªÇóÑ¡Ôñ×îÊʺÏ×Ô¼ºµÄ°æ±¾¡£
°æ±¾
Toad? for Oracle
ÃèÊö
ÌṩOracle¿ª·¢´úÂë¡¢½¨Á¢ºÍ¹ÜÀíÊý¾Ý¿â¶ÔÏóËùÐèÒªµÄËùÓÐרҵ»¯¹¦ÄÜ¡£Toad Standard Edition רÃÅΪOracleÓ¦Óÿª·¢ÈËÔ±¶øÉè¼Æ£¬°üÀ¨¹¦ÄÜÇ¿´óµÄSQL±à¼Æ÷¡¢PL/SQL±à¼Æ÷£¬Ä£Ê½ä¯ÀÀÆ÷µÈµÈ¡£
Toad? for Oracle Professional
£¨°üÀ¨Toad? for Oracle µÄËùÓй¦ÄÜ£¬ÒÔ¼°µ÷ÊÔ¡¢PL/SQL ֪ʶ¿âºÍ´úÂëProfile¹¦ÄÜ£©
¿ª·¢PL/SQL ´úÂëÊÇÒ»¸öÈß³¤µÄ¹ý³Ì£¬ÐèÒª¼«¸ßµÄ׼ȷÐÔ¡£Toad? for Oracle Professional ÌṩÁËר¼Ò¼¶´úÂëÉó²é¹¦ÄÜ£¬¿ÉÓëToad for Oracle µÄ Procedure Editor ·½±ã¼¯³É£¬ÀûÓÃÏÖÓеĹæÔò£¬·ÖÎö´æ´¢½ø³Ì£¬ »ñµÃÏêϸ¡¢ÕýÈ·µÄ½¨Òé¡£
Toad? for Oracle Xpert
£¨°üÀ¨Toad? for Oracle Professional µÄËùÓй¦ÄÜ£¬ÒÔ¼°Óë SQL Tuning ºÍͨ¹ý CodeXpert µÄ SQL & PL/SQL Optimization ɨÃèµÄ¼¯³É£©
Èç¹ûÓû§Ï£Íû¼ò»¯SQL´úÂëÓÅ»¯£¬Ìá¸ß¹¤×÷ЧÂÊ£¬¾Í¿ÉÀûÓà Toad? for Oracle Xpert ´ïµ½ÕâһĿ±ê¡£Í¨¹ýʶ±ðDZÔÚµÄÐÔÄÜÒþ»¼£¬¿ÉÒԸ߼¶ÓÅ»¯×é¼þ£¬´ó·ùËõ¶Ì¿ª·¢Õß¡¢DBAºÍ·ÖÎöÈËÔ±ËùÐèµÄÓÅ»¯Ê±¼ä¡£°üÀ¨Toad? for Oracle Suite °üÀ¨Toad? for Oracle Xpert µÄËùÓй¦ÄÜ£¬
ÒÔ¼°¶àÖֿɸÄÉÆOracleרҵÈËÔ±´úÂ뿪·¢ºÍÊý¾Ý¿â¶ÔÏóά»¤¹¤×÷µÄ¹¤¾ß¡£
? DBA Module
? Knowledge Xpert? for Oracle Administration ? Knowledge Xpert? for PL/SQL ? DataFactory? Developer Edition ? Benchmark Factory? for Databases ? QDesigner? PhysicalArchitect
ÕâÖÖÍêÕûµÄ¿ª·¢Ì×¼þ£¬ÌṩÁËÉè¼Æ ¡¢¿ª·¢¡¢²âÊԺ͹ÜÀíÊý¾Ý¿âʱËùÐèµÄÈ«²¿¹¤¾ß¡£
Toad? for Oracle Suite
2. Toad? for Oracle
Toad for OracleÊÇToad±ê×¼°æ¡£
5
Ïà¹ØÍÆ¼ö£º