數據庫中普通用戶如何調用dbms

137次閱讀

共計 2629 個字符，預計需要花費 7 分鐘才能閱讀完成。

行業資訊
數據庫
關系型數據庫
數據庫中普通用戶如何調用 dbms_xplan.display_cursor 查看執行計劃

這篇文章主要為大家展示了“數據庫中普通用戶如何調用 dbms_xplan.display_cursor 查看執行計劃”，內容簡而易懂，條理清晰，希望能夠幫助大家解決疑惑，下面讓丸趣 TV 小編帶領大家一起研究并學習一下“數據庫中普通用戶如何調用 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 3

SQL 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 查看執行計劃”這篇文章的所有內容，感謝各位的閱讀！相信大家都有了一定的了解，希望分享的內容對大家有所幫助，如果還想學習更多知識，歡迎關注丸趣 TV 行業資訊頻道！

正文完