Oracle几种工具介绍

1、Oracle SQL Developer----Oracle
Oracle SQL Developer是Oracle公司出品的一个免费的集成开发环境。
Oracle SQL Developer 是一个免费非开源的用以开发数据库应用程序的图形化工具，使用 SQL Developer 可以浏览数据库对象、运行 SQL 语句和脚本、编辑和调试 PL/SQL 语句。另外还可以创建执行和保存报表。该工具可以连接任何 Oracle 9.2.0.1 或者以上版本的 Oracle 数据库，支持 Windows、Linux 和 Mac OS X 系统。
最新版本的Oracle SQL Developer提供了PL / SQL单元测试，集成了数据模型浏览器和Subversion源代码版本控制系统，CVS（并行版本系统）此外，2.1版包括了许多更新功能，如SQL格式化，模式比较，复制、导出向导和迁移支持。
但是现在Oracle SQL Developer的市场份额基本都被PL/SQL Developer所占有。
2、PL/SQL Developer----Embarcadero
加强版的Oracle SQL Developer。
但是Oracle SQL Developer是免费的，而PL/SQL Developer当然是收费的了。
3、TOAD----Dell（Quest）
（1）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.
（2）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.
 （3）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.
（4）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.
（5）Toad DBA Suite for Oracle --适合于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
4、Oracle Golden Gate（Oracle）
Oracle Golden Gate软件是一种基于日志的结构化数据复制备份软件，它通过解析源数据库在线日志或归档日志获得数据的增量变化，再将这些变化应用到目标数据库，从而实现源数据库与目标数据库同步。Oracle Golden Gate可以在异构的IT基础结构（包括几乎所有常用操作系统平台和数据库平台）之间实现大量数据亚秒一级的实时复制,从而在可以在应急系统、在线报表、实时数据仓库供应、交易跟踪、数据同步、集中/分发、容灾、数据库升级和移植、双业务中心等多个场景下应用。同时，Oracle Golden Gate可以实现一对一、广播(一对多)、聚合(多对一)、双向、点对点、级联等多种灵活的拓扑结构
5、DB PowerStudio for Oracle（Allround Automations）
DB PowerStudio 是一款直观且高度可视化的工具集，帮助DBA和开发人员高效地在所有版本的主流数据库平台上开展工作，帮助相关人员以可视化的方式构建和维护关键的数据库应用，使数据库的变更管理过程变得流畅，以及快速定位和解决性能瓶颈。
DB PowerStudio包括如下四个产品：
（1）DBArtisan：数据库管理
（2）RapidSQL：数据库开发
（3）DB Optimizer：数据库调优
（4）ChangeManager：数据库变更管理
针对企业中的不同角色，DB PowerStudio设计有两个版本：DBA版本和Developer版本。
DB PowerStudio根据管理的数据库主要分为：DB PowerStudio for Oracle和DB PowerStudio for SQL Server。