Breaking News: Grepper is joining You.com. Read the official announcement!

oracle get plan_hash_value from "explain plan"

VasteMonde answered on February 9, 2022 Popularity 2/10 Helpfulness 3/10

answer oracle get plan_hash_value from "explain plan"

related oracle plan hash value

oracle get plan_hash_value from "explain plan"

Comment

EXPLAIN PLAN SET STATEMENT_ID = 'TEST1' FOR
SELECT * FROM dual CONNECT BY level <= 10;
-- Displays plan
SELECT *
FROM TABLE (dbms_xplan.display);
-- Getting hash_plan_value from explain plan
SELECT extractValue(xmltype(other_xml), 
       '/other_xml/info[@type="plan_hash"]') AS plan_hash
FROM plan_table
WHERE other_xml IS NOT NULL
  AND statement_id = 'TEST1';

Popularity 2/10 Helpfulness 3/10 Language sql

Source: Grepper

Tags: get oracle sql

Link to this answer
Share Copy Link

Contributed on Apr 08 2024

VasteMonde

0 Answers Avg Quality 2/10

Closely Related Answers

oracle plan hash value

Comment

SELECT DISTINCT sql_id, plan_hash_value
FROM dba_hist_sqlstat dhs,
    (
    SELECT /*+ NO_MERGE */ MIN(snap_id) min_snap, MAX(snap_id) max_snap
    FROM dba_hist_snapshot ss
    WHERE ss.begin_interval_time BETWEEN (SYSDATE - 4) AND SYSDATE
    ) s
WHERE dhs.snap_id BETWEEN s.min_snap AND s.max_snap
  AND dhs.sql_id IN ('my_sql_id');

Popularity 4/10 Helpfulness 8/10 Language sql

Source: Grepper

Tags: sql hash oracle

Link to this answer
Share Copy Link

Contributed on Feb 09 2022

VasteMonde

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

oracle get plan_hash_value from "explain plan"

Contents

More Related Answers

oracle get plan_hash_value from "explain plan"

Closely Related Answers

oracle plan hash value

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.