這篇文章主要為大家展示了“數(shù)據(jù)庫(kù)中普通用戶如何調(diào)用dbms_xplan.display_cursor查看執(zhí)行計(jì)劃”，內(nèi)容簡(jiǎn)而易懂，條理清晰，希望能夠幫助大家解決疑惑，下面讓小編帶領(lǐng)大家一起研究并學(xué)習(xí)一下“數(shù)據(jù)庫(kù)中普通用戶如何調(diào)用dbms_xplan.display_cursor查看執(zhí)行計(jì)劃”這篇文章吧。

創(chuàng)新互聯(lián)公司專業(yè)為企業(yè)提供定州網(wǎng)站建設(shè)、定州做網(wǎng)站、定州網(wǎng)站設(shè)計(jì)、定州網(wǎng)站制作等企業(yè)網(wǎng)站建設(shè)、網(wǎng)頁(yè)設(shè)計(jì)與制作、定州企業(yè)網(wǎng)站模板建站服務(wù)，10余年定州做網(wǎng)站經(jīng)驗(yàn)，不只是建網(wǎng)站，更提供有價(jià)值的思路和整體網(wǎng)絡(luò)服務(wù)。

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 * fromtable(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)

以上是“數(shù)據(jù)庫(kù)中普通用戶如何調(diào)用dbms_xplan.display_cursor查看執(zhí)行計(jì)劃”這篇文章的所有內(nèi)容，感謝各位的閱讀！相信大家都有了一定的了解，希望分享的內(nèi)容對(duì)大家有所幫助，如果還想學(xué)習(xí)更多知識(shí)，歡迎關(guān)注創(chuàng)新互聯(lián)行業(yè)資訊頻道！

本文標(biāo)題：數(shù)據(jù)庫(kù)中普通用戶如何調(diào)用dbms_xplan.display_cursor查看執(zhí)行計(jì)劃
網(wǎng)頁(yè)URL：http://www.rwnh.cn/article36/gopjsg.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供App設(shè)計(jì)、網(wǎng)站收錄、電子商務(wù)、定制網(wǎng)站、網(wǎng)站制作、品牌網(wǎng)站建設(shè)

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來源： 創(chuàng)新互聯(lián)