数据库中普通用户如何调用dbms_xplan.display_cursor查看执行计划

这篇文章主要为大家展示了“数据库中普通用户如何调用dbms_xplan.display_cursor查免费云主机域名看执行计划”，内容简而易懂，条理清晰，希望能够帮助大家解决疑惑，下面让小编带领大家一起研究并学习一下“数据库中普通用户如何调用dbms_xplan.display_cursor查看执行计划”这篇文章吧。
SQL> grant select on v_$session to mims;
SQL> grant select on v_$sql to mims;
SQL> grant select on v_$sql_plan to mims;
SQL> SELECT /*+ gather_plan_statistics */ SECTION ,
2 item
3 FROM eqrecipeitemmonitoring
4 WHERE eqpid = ‘2SOL15’
5 AND unitid = ‘FB01’
6 AND recipeid = ‘480FN01-SC12-G2C8-SR’
7 AND filename =’Lightening.dat’;
SECTION ITEM
————————————————– —————————————————————————————————-
Lightening Data Controller ID 0
Lightening Data Controller ID 1
Lightening Data Controller ID 2
Lightening Data Controller ID 3SQL> select * from table(dbms_xplan.display_cursor(null,null,’ALLSTATS LAST’));
PLAN_TABLE_OUTPUT
———————————————————————————————————————————————————————————
—————————————————————————————————————————
SQL_ID 2mg58m5jxsw9v, child number 1
————————————-
SELECT /*+ gather_plan_statistics */ SECTION , item FROM
eqrecipeitemmonitoring WHERE eqpid = :”SYS_B_0″ AND unitid =
:”SYS_B_1″ AND recipeid = :”SYS_B_2″ AND filename =:”SYS_B_3″
Plan hash value: 2230633342
———————————————————————————————————————
| Id | Operation | Name | Starts | E-Rows | A-Rows | A-Time | Buffers |
———————————————————————————————————————
| 0 | SELECT STATEMENT | | 1 | | 4 |00:00:00.01 | 43 |
|* 1 | TABLE ACCESS BY INDEX ROWID | EQRECIPEITEMMONITORING | 1 | 1 | 4 |00:00:00.01 | 43 |
| 2 | BITMAP CONVERSION TO ROWIDS | | 1 | | 12 |00:00:00.01 | 33 |
| 3 | BITMAP AND | | 1 | | 1 |00:00:00.01 | 33 |
| 4 | BITMAP CONVERSION FROM ROWIDS| | 1 | | 1 |00:00:00.01 | 22 |
|* 5 | INDEX RANGE SCAN | MONITORING_RECIPEID | 1 | 4778 | 4057 |00:00:00.01 | 22 |
| 6 | BITMAP CONVERSION FROM ROWIDS| | 1 | | 1 |00:00:00.01 | 11 |
|* 7 | INDEX RANGE SCAN | MONITORING_FILENAME | 1 | 4778 | 1814 |00:00:00.01 | 11 |
———————————————————————————————————————
Predicate Information (identified by operation id):
—————————————————
1 – filter((“UNITID”=:SYS_B_1 AND “EQPID”=:SYS_B_0))
5 – access(“RECIPEID”=:SYS_B_2)
7 – access(“FILENAME”=:SYS_B_3)以上是“数据库中普通用户如何调用dbms_xplan.display_cursor查看执行计划”这篇文章的所有内容，感谢各位的阅读！相信大家都有了一定的了解，希望分享的内容对大家有所帮助，如果还想学习更多知识，欢迎关注百云行业资讯频道！

相关推荐: Oracle数据用户密码过期处理方法是什么

这篇文章主要讲解了“Oracle数据用户密码过期处理方法是什么”，文中的讲解内容简单清晰，易于学习与理解，下面请大家跟着小编的思路慢慢深入，一起来研究和学习“Oracle数据用户密码过期处理方法是什么”吧！免费云主机域名Oracle数据库如果没有指定配置pro…