Oracle执行计划 [英] Oracle Execution Plan

问题描述

我正在使用Oracle 11g和Toad for Oracle.如何显示查询的执行计划? 在Sql Server Management Studio中，执行计划可以显示为图形格式.是否在Toad for oracle上有类似的功能/工具?

I am using Oracle 11g and Toad for Oracle. How can I display execution plan for queries? In Sql server management studio execution plan can be displayed as graphical format. Is there any functionality/tool like that on Toad for oracle?

推荐答案

CTRL-E

确保以分号(和上面的查询)结束查询

Make sure you've ended the query with a semi-colon (and the query above)

您需要设置TOAD计划表才能使用.如果您认为它已经在数据库上设置，则可能只需要授予访问权限即可.或者，在我的旧版TOAD中，位于:

You need to set-up the TOAD plan table for use. If you think it's already setup on your DB then you may just need to be granted access. Alternatively in my slightly older version of TOAD it's under:

数据库->管理->服务器端对象向导.在这里，您可以按照您选择的模式创建计划表.

Database --> Administer --> Server Side Objects Wizard. From here you can create the plan table(s) in a schema that you choose.

这篇关于Oracle执行计划的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！