查看oracle 真實(shí)執(zhí)行計(jì)劃

發(fā)布時間：2020-06-02 19:20:32 來源：網(wǎng)絡(luò) 閱讀：406 作者：zj0078 欄目：關(guān)系型數(shù)據(jù)庫

一共3個step；

step1:在sql執(zhí)行時，增加hint： /*+gather_plan_statistics*/

step2：查出sql的sql id: select * from v$sql s where s.SQL_TEXT like 'SELECT /*+monitor*/TT.*%'

step3:執(zhí)行下面sql查看真實(shí)執(zhí)行計(jì)劃；

SELECT

sp.last_starts AS "starts",

sp.last_output_rows AS "rows",

round(sp.last_elapsed_time / 1000000, 2) AS TIME,

sp.last_cr_buffer_gets bf,

sp.depth d,

rtrim(lpad(' ', 2 * (depth - 1)) || operation ||
       decode(options, NULL, '', ' ' || options)) "Explain plan",

decode(id,
        0,
        '------------- ',
        substr(decode(substr(object_name, 1, 7),
                      'SYS_LE_',
                      NULL,

                      object_name) || ' ',
               1,
               30)) AS "object",

向AI問一下細(xì)節(jié)

查看oracle 真實(shí)執(zhí)行計(jì)劃

猜你喜歡

最新資訊

相關(guān)推薦

相關(guān)標(biāo)簽