My shop uses an open-source Eclipse plugin called SQL Explorer: http://eclipsesql.sourceforge.net/ It has good stuff for examining schemata; it integrates with your source code control system; it works on other database table servers too.
We also use a commercial tool called PL/SQL Developer: http://www.allroundautomations.com/plsqldev.html This tool has a "SQL Beautifier" which can tidy up some of the hairiest queries you can imagine. In tidying them up, it helps the one writing the query find typos. It also has a context menu that will do "EXPLAIN PLAN" on a query that's already running, and a way to stop a running query. Those are incredibly handy tools.
Carpenteri mentioned Oracle Enterprise Manager. That comes with your Oracle thick client. I find it helpful for getting an instance-wide view of what's going on in your server.
发布评论
评论（4）
如果您正在为 Oracle 数据库寻找系统管理工具，值得查看 Oracle 企业管理器
If you are looking for a system management tool for your Oracle database it is worth looking at the Oracle Enterprise Manager
您可以结合使用一些工具，例如 SQL Developer、SQLTools 和 Aqua Data Studio
You could use a combination of some tools like SQL Developer, SQLTools and Aqua Data Studio
最好的免费软件是（排名不分先后）
最佳商业版分别是（排名不分先后）
The best free ones are (in no particular order)
The best commercial ones are (in no particular order)
我的商店使用一个名为 SQL Explorer 的开源 Eclipse 插件： http://eclipsesql.sourceforge.net/ 它有用于检查图式的好东西；它与您的源代码控制系统集成；它也适用于其他数据库表服务器。
我们还使用名为 PL/SQL Developer 的商业工具： http://www.allroundautomations.com/plsqldev.html
这个工具有一个“SQL Beautifier”，它可以整理一些你能想象到的最复杂的查询。在整理它们的过程中，它可以帮助编写查询的人找到拼写错误。它还具有一个上下文菜单，可以对已经运行的查询执行“解释计划”，以及停止正在运行的查询的方法。这些都是非常方便的工具。
Carpenteri 提到了 Oracle Enterprise Manager。它随 Oracle 胖客户端一起提供。我发现它对于获取服务器中发生的情况的实例范围视图很有帮助。
My shop uses an open-source Eclipse plugin called SQL Explorer: http://eclipsesql.sourceforge.net/ It has good stuff for examining schemata; it integrates with your source code control system; it works on other database table servers too.
We also use a commercial tool called PL/SQL Developer: http://www.allroundautomations.com/plsqldev.html
This tool has a "SQL Beautifier" which can tidy up some of the hairiest queries you can imagine. In tidying them up, it helps the one writing the query find typos. It also has a context menu that will do "EXPLAIN PLAN" on a query that's already running, and a way to stop a running query. Those are incredibly handy tools.
Carpenteri mentioned Oracle Enterprise Manager. That comes with your Oracle thick client. I find it helpful for getting an instance-wide view of what's going on in your server.