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

oracle get plan for sql_id

VasteMonde answered on October 15, 2022 Popularity 8/10 Helpfulness 5/10

answer oracle get plan for sql_id

oracle get plan for sql_id

Comment

-- Get sql_id and cursor_child_no from session
SELECT s.SQL_ID, s.SQL_CHILD_NUMBER,
       s.USERNAME, s.SCHEMANAME, s.OSUSER, s.PROGRAM,
       s.SQL_EXEC_START, s.SID
FROM GV$SESSION s
WHERE s.STATUS = 'ACTIVE' AND s.TYPE <> 'BACKGROUND';
-- Get hash plan from SQL_ID and SQL_CHILD_NUMBER
SELECT * FROM TABLE(dbms_xplan.display_cursor(sql_id => 'sql_id',
                                              cursor_child_no => 0));

Popularity 8/10 Helpfulness 5/10 Language sql

Source: Grepper

Tags: execution explain get oracle sql

Link to this answer
Share Copy Link

Contributed on Oct 15 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 for sql_id

Contents

More Related Answers

oracle get plan for sql_id

Grepper

Documentation

Social

Legal

Contact

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