Quest TOAD for Oracle 中文使用手册:DBA工具与功能解析

4星 · 超过85%的资源 需积分: 15 22 下载量 98 浏览量 更新于2024-08-02 收藏 1.93MB PDF 举报
"TOAD中文使用手册是一份详细介绍如何使用TOAD进行数据库管理和开发的文档,涵盖从基础功能到高级特性的全方位指南。手册中包括了TOAD for Oracle的各项主要模块,如Schema Browser、SQL Editor、Procedure Editor、SQL Modeler等,并深入探讨了专业版中的PL/SQL调试器、代码分析工具、最佳实践检查等功能。此外,还介绍了TOAD for Oracle Expert的性能优化工具,如SQL Scanner、SQL Inspector和Index Expert。手册也提到了TOAD for Oracle Suite的DBA模块,包括数据库监控、健康检查等实用工具。" TOAD(Tool for Oracle Application Developers)是一款强大的Oracle数据库管理与开发工具,它为数据库管理员(DBA)、开发人员和分析师提供了丰富的功能。以下将详细阐述TOAD的一些核心功能: 1. **Schema Browser**: 用于浏览和管理数据库架构,包括表、视图、索引、触发器、存储过程等对象,支持搜索、修改和创建新的数据库对象。 2. **SQL Editor**: 提供了一个集成的环境来编写、执行和调试SQL语句,支持自动完成、语法高亮和错误检查,便于快速开发和测试SQL查询。 3. **Procedure Editor**: 专为编写、编辑和调试PL/SQL代码设计,支持多文档界面,可以进行断点设置、步进调试,帮助开发人员高效处理存储过程和函数。 4. **SQL Modeler**: 提供图形化的数据建模工具,用于设计和逆向工程数据库结构,支持创建和修改实体关系模型。 5. **FastReport**: 用于快速生成报告,可以从数据库中提取数据并以各种格式输出,如PDF、Excel等。 6. **Script Manager**: 管理和执行SQL脚本,支持批处理操作,方便DBA进行数据库维护和更新。 7. **Master/Detail Browser**: 用于查看和分析主-详情数据关系,帮助理解数据之间的关联。 8. **Connection Color-Coding**: 通过颜色编码不同的数据库连接,使用户能快速识别和切换不同环境。 在TOAD for Oracle Professional中,增加了以下高级特性: 9. **PL/SQL Debugger**: 允许用户调试PL/SQL代码,检查变量值,设置断点,逐步执行,有助于定位和修复问题。 10. **Code Profiling**: 分析代码性能,找出执行效率低下的部分,帮助优化代码。 11. **Knowledge Expert for PL/SQL**: 提供智能提示和代码建议,提高编码效率。 12. **Team Coding**: 支持团队协作,版本控制,使得多人协同开发更为顺畅。 13. **Code Expert**: 提供代码质量检查,确保遵循最佳编码实践。 TOAD for Oracle Expert则进一步增强了性能优化工具: 14. **SQL Scanner**: 自动扫描SQL语句,提供性能改进建议。 15. **SQL Inspector**: 深入分析SQL执行计划,帮助找出性能瓶颈。 16. **SQL Optimizer**: 提供SQL优化建议,提高查询速度。 17. **Index Expert**: 分析索引性能,推荐创建或删除索引以优化查询。 18. **Cross Index Analysis**: 跨索引分析,检查索引的使用效率。 19. **Outline Manager**: 管理和组织SQL脚本,方便快速访问常用查询。 20. **Plan Change Analyzer**: 监控SQL执行计划的变化,防止未预期的性能下降。 21. **Best Practices**: 验证代码是否符合最佳实践,提升代码质量。 TOAD for Oracle Suite还包含DBA模块,如: 22. **Database Monitor**: 实时监控数据库状态,包括性能指标和警告。 23. **Database Probe**: 进行深度探测,检测潜在的问题。 24. **Health Check**: 自动评估数据库健康状况,提供改进措施。 25. **Instance Manager**: 管理Oracle实例,进行启动、停止等操作。 26. **Top Session Finder**: 查找消耗资源最多的会话,帮助诊断性能问题。 27. **Oracle Parameters**: 查看和调整数据库参数,优化配置。 此外,手册还提到了其他工具,如Knowledge Expert for Oracle Administration、Data Factory Developer Edition、Benchmark Factory for Databases以及Toad Data Modeler等,这些工具扩展了TOAD的功能,使其成为一个全面的数据库管理和开发平台。通过这份手册,用户可以全面了解和掌握TOAD的使用,提高工作效率。
2012-09-22 上传
1073页啊,够爽吧: Introduction 15 New in This Release 15 Introduction to Toad 23 DB Admin Module 24 Toad and Oracle Enterprise Manager 29 Quick Search Bar 30 Additional Resources 31 Working with other Quest Products 32 Knowledge Xpert 32 Using SQL Optimizer with Toad 32 Benchmark Factory 33 Quest Code Tester Integration 35 Toad Basics 37 Toad Tips 37 Errors 37 RAC Support 37 Task Bar & Status Bar 38 Toolbars, Menus and Shortcut Keys 40 Installation and Administration of Toad 64 Window Privileges and Toad 64 Toad for Oracle, Read-Only 64 Registering Toad 65 Silent Installation 66 Group Policy Management 71 Citrix Support 71 SQL*Net Versions 72 Configuration Files 73 Server Side Objects Installation 93 Connecting to Oracle 97 Server Login Window 97 Create New Connection 99 Selecting Connection Color 101 SET ROLE 101 Auto Connect 103 Save Passwords for Connections 104 Select and View Favorite Connections 104 Organize your login display 105 Use Existing Connection 106 SQLNET Editor 106 LDAP Editor 107 Oracle Homes 108 TNSNames Editor 111 Tutorials 119 CodeXpert 119 PL/SQL Debugger 121 SQL*Loader 140 Team Coding 158 RMAN Templates 164 RMAN Scripts in Toad 164 Working with RMAN Templates 164 Executing RMAN Scripts from Toad 165 Comparing 166 Data Duplicates 166 Compare Single Objects 166 Comparing Databases 167 Comparing Data 174 Compare Files (Difference Viewer) 176 Comparing Schemas 180 Controlling Sessions 188 Select Session 188 End Connections 188 Test Connections 188 Configure User Lists 188 Session Information 189 Change Password 190 Commit & Rollback 190 Connect and Disconnect 191 DBMS_Flashback 191 Diagnosing Problems 193 View Extents 193 Identify Space Deficits 193 Log Switch Frequency Map 194 Tablespace Map 194 TKProf Interface Wizard 196 Undo Advisor 198 Segment Advisor 200 LogMiner Interface 203 Health Check 207 Trace File Browser 226 CodeXpert 231 Database Administration 259 Audit SQL/Sys Privs 259 NLS Parameters 260 Toad Features Security 260 ASM Manager 263 Audit Objects 269 Multiple Object Privileges 270 Oracle Parameters 272 Tablespaces 274 Redo Log Manager 282 Importing and Exporting Data 285 Data Pump 285 Export Dataset 304 Export DDL 310 Export File Browser 318 General Export 324 General Import 329 Generate Database Script 341 Generate Schema Script 342 Managing Projects 346 Using Automation Designer to Control Toad 346 Project Manager 387 Query Viewer 416 SQL Command Recall 418 Script Manager 419 Monitoring 431 Toad Server Statistics 431 SQL Monitor 432 Toad UNIX Monitor 432 ADDM/AWR 434 Database Browser 446 Database Monitor 449 Database Probe 453 Index Monitoring 458 Instance Manager 460 Session Browser 466 SGA Trace/Optimization 483 StatsPack Browser 486 Top Session Finder 495 Optimizing (Tuning) 499 DBMS_REDEFINITION Wizard 499 Estimate Index Size 500 Estimate Table Size 501 Explain Plan 503 Pinned Code 504 Repair Chained Rows 505 Rebuild Table 506 Unix Kernel Parms 507 Windows Registry Parms 508 Analyze All Objects 509 Profilers 512 Oracle Tuning 523 Rebuild Multiple Objects 525 Options 535 Formatting Options 535 Toad Options 536 Language Management 603 Printing 620 Printing 620 Print Grid 620 Report Link Designer 620 Reporting 623 Toad Control Files 623 Dependencies 624 ER Diagrams 624 Explain Plans 631 Code Road Map 636 HTML Schema Doc Generator 641 Master/Detail Browser 643 Reports Manager 648 Reporting from Data Grids 655 Spool SQL 659 Spool SQL 659 Utilities 660 Archive 660 Wrap Code 660 Service Manager 661 External tools 662 FTP 665 Java Manager 668 Network Utilities 672 Task Scheduler 676 Unix Job Scheduler 678 Source Control and Team Coding 693 Support for Version Control Products 693 Third Party File Based Source Control 694 Team Coding 697 Status in the Editor Status Bar or Team Coding Viewer Status Column 707 Detailed File Properties 708 Checking Objects and Scripts in and out 709 Using Automatic Check-in and Automatic Check-out 709 Manually check-in or check-out 709 Entering Comments on Check in or out 710 Check In All 711 Undo Checkout 712 Freezing an Object 713 TC Locks not selected 726 TC Locks selected 726 Working from the Command Line 738 Command Line Syntax 738 Converting Old Settings Files to Actions 743 Command Line Passwords 744 Export Tables, Views, SQL Queries from the Command Line 744 Run Analyze Objects from the Command Line 745 Run CodeXpert from the Command Line 750 Running Actions from the Command Line 751 Run Compare Databases from Command Prompt 754 Run Compare Schemas from a Command Prompt 757 Run Copy to another Schema from Command Prompt 757 Run Generate Database Script from a Command Prompt 758 Run Generate Schema Script from Command Line 760 Run Rebuild Objects from the Command Prompt 762 Run Reports Manager from the Command Line 766 Using Variables 768 Using Variables 768 Working with Code 769 Editor 769 Debugging 819 Query Builder 851 Working with Data 861 Column Names Supported 861 Graph Properties 861 OPS$ Accounts 861 Viewing or Hiding Docked Windows 862 Viewing Source Surrounding a PL/SQL Error 863 Dataset Operations 864 Data Grids 866 DBMS Output 881 Finding Data 883 Generate Test Data 890 Working with Database Objects 896 Schema Browser Overview 896 Auto-Refreshing the Datagrid 897 Icon Legend 898 Privileges 898 Schema Browser Toolbars 899 Statement Processing 900 Create Objects in Another Schema 900 Personalizing the Schema Browser 900 General Schema Browser Actions 903 Browser Filters 907 Clusters 912 Constraints 914 Contexts 917 DB Links 918 Dimensions 920 Directories 921 Favorites 923 Flashback Archives 924 Functions 926 Indexes 928 Invalid Objects 929 Java 931 Jobs 933 Libraries 936 Materialized Views (Snapshots) 938 Materialized View (Snapshot) Logs 940 Oracle Scheduler 941 Packages 953 Policies 955 Policy Groups 956 Procedures 957 Profiles 959 Queue Tables 960 Queues 964 Recycle Bin 966 Refresh Groups 968 Resource Consumer Groups 970 Resource Plans 972 Roles 974 Rollback Segments 975 Sequences 977 Synonyms 978 System Privileges 980 Tables 981 Tablespaces 996 Triggers 1002 Types 1004 Users 1010 Views 1012 Troubleshooting 1017 Unicode Troubleshooting 1017 Hints and Tips: Connecting To Personal Oracle 1018 Hints and Tips: Table Does Not Exist Errors 1019 Create Support Bundles 1019 Toad Advisor 1019 Contact Quest 1021 Contact Quest Support 1021 Contact Quest Software 1021 About Quest Software, Inc 1021 Appendix: Contact Quest 1022 Contact Quest Support 1022 Contact Quest Software 1022 About Quest Software, Inc 1022 Index 1023