首页 技术 正文
技术 2022年11月10日
0 收藏 855 点赞 3,745 浏览 3512 个字

很早就听说Toad功能很强大,一直没有使用过,因为PLSQL Developer就很好用。前几天看见同事优化Oracle就是用的Toad,有一些很强大的管理功能,于是再一次对Toad产生兴趣,收集了一些资料备忘。

关于Toad版本的介绍

Toad for Oracle — 基础版

It contains different features, from PL/SQL and SQL scripts, PL/SQL and SQL debugging suite to built-in knowledge basics: Knowledge Xpert for PL/SQL and Knowledge Xpert for Oracle Administration. It allows you to visually create queries and execute them, construct
and manage database objects, share project assets such as templates, scripts, and code snippets, with other team members using Project Manager, record workflow steps and play them back later with Action Recall and profile your PL/SQL code to find performance
bottlenecks and check for code coverage. Toad for Oracle also has its own team collaboration utility called Team Coding. Team Coding works with Toad’s editor to control code access.

Toad for Oracle Professional –专业版,包含"Toad for Oracle"版所有功能, 增加CodeXpert功能

This piece of software enables you all features of Toad for Oracle, but it has additional possibilities through CodeXpert, which automates code quality reviews for an objective and consistent review process. CodeXpert contains incorporated rules from experts,
Steven Feuerstein for example. Whit these groups of rules, your code has visual expert who advises you when entering your code. With professional distributions you have possibility to generate quality and performance great code. Toad for Oracle Professional
also includes an Export File Browser including objects and data from an Oracle export file. Finally, this edition of Toad contains Oracle import/export utility wizards, which makes your work more efficient.

Toad for Oracle Xpert –包含"Toad for Oracle Professional"版所有功能, 增加SQL Optimizer功能, 也是DBA最常用的版本

It brings you closer to perfection, since, besides all the features in Toad for Oracle Professional, it contains SQL performance tuning through the SQL Optimizer. The benefits of this module are that it scans PL/SQL and external scripts and files to identify
the SQL statements that may perform poorly in production. It then rewrites the SQL for you and offers alternate implementations to improve performance. These operations can be performed per SQL statement, interactively or in bulk, using a batch process.

Toad Development Suite for Oracle –开发版,适合于数据库开发人员的套件产品, 含多个软件, 可选择安装

Toad Development Suite for Oracle distribution is an easy, automated way to ensure PL/SQL based applications meet the essential requirements of code quality, performance and scalability before production release. Each part of the suite enables the efficient
development, testing, optimization and validation of code.

Toad DBA Suite for Oracle –DBA版,适合于DBA的套件产品, 含多个软件, 可选择安装, 其中"Toad for Oracle Xpert"是它的一个软件之一

The Toad DBA Suite provides an integrated set of tools to ease database administration tasks, quickly diagnose problems and automate SQL tuning and optimization. It is a direct way to manage, synchronize and deploy schema changes,
administer your databases including users, roles, infrastructure and utilities, diagnose and resolve database performance issues in real time, identify problematic SQL statements directly from source code or execution in Oracle, manage database storage, replay
database workload to simulate production environment in development/test databases and so on.

==========================================华丽的分割线===========================================

下载地址:

32-bit

http://us-downloads.quest.com/Repository/support.quest.com/Toad for Oracle/11.6/Software/Toad DBA Suite for Oracle 11.6 Commercial.exe

http://us-downloads.quest.com/Repository/support.quest.com/Toad for Oracle/11.6/Software/Toad for Oracle 11.6.msi

64-bit

http://us-downloads.quest.com/Repository/support.quest.com/Toad for Oracle/11.6/Software/Toad DBA Suite for Oracle 11.6 64-bit Commercial.exe

http://us-downloads.quest.com/Repository/support.quest.com/Toad for Oracle/11.6/Software/Toad for Oracle 11.6 64bit.msi

使用教程:

http://wenku.baidu.com/view/ff3786c4bb4cf7ec4afed001.html?re=view

相关推荐
python开发_常用的python模块及安装方法
adodb:我们领导推荐的数据库连接组件bsddb3:BerkeleyDB的连接组件Cheetah-1.0:我比较喜欢这个版本的cheeta…
日期:2022-11-24 点赞:878 阅读:9,489
Educational Codeforces Round 11 C. Hard Process 二分
C. Hard Process题目连接:http://www.codeforces.com/contest/660/problem/CDes…
日期:2022-11-24 点赞:807 阅读:5,904
下载Ubuntn 17.04 内核源代码
zengkefu@server1:/usr/src$ uname -aLinux server1 4.10.0-19-generic #21…
日期:2022-11-24 点赞:569 阅读:6,737
可用Active Desktop Calendar V7.86 注册码序列号
可用Active Desktop Calendar V7.86 注册码序列号Name: www.greendown.cn Code: &nb…
日期:2022-11-24 点赞:733 阅读:6,489
Android调用系统相机、自定义相机、处理大图片
Android调用系统相机和自定义相机实例本博文主要是介绍了android上使用相机进行拍照并显示的两种方式,并且由于涉及到要把拍到的照片显…
日期:2022-11-24 点赞:512 阅读:8,128
Struts的使用
一、Struts2的获取  Struts的官方网站为:http://struts.apache.org/  下载完Struts2的jar包,…
日期:2022-11-24 点赞:671 阅读:5,290