Execution plan

TO GET EXECUTION PLAN OF A QUERY

Replace SQLID at the highlighted place.

SET LINES 180
SET PAGES 10000
CLEAR COLUMNS
COLUMN EXECS FOR 999,999,999
COLUMN AVG_ETIME FOR 999,999.999
COLUMN AVG_LIO FOR 999,999,999.9
COLUMN BEGIN_INTERVAL_TIME FOR A30
COLUMN NODE FOR 99999
COLUMN SQL_TEXT FORMAT A120

SPOOL <SQL_ID>.log

SELECT
    ss.snap_id, ss.instance_number node, ss.begin_interval_time, s.sql_id, s.plan_hash_value,
NVL(s.executions_delta,0) execs,    (s.elapsed_time_delta/DECODE(NVL(s.executions_delta,0),0,1,s.executions_delta))/1000000 avg_etime,    (s.buffer_gets_delta/DECODE(NVL(s.buffer_gets_delta,0),0,1,s.executions_delta)) avg_lio
FROM
    dba_hist_sqlstat s, dba_hist_snapshot ss
WHERE
    ss.snap_id = s.snap_id AND
    ss.instance_number = s.instance_number AND
    s.executions_delta > 0 AND
    s.sql_id = '<SQL_ID>'
ORDER BY 1, 2, 3;

SELECT * FROM TABLE(dbms_xplan.display_cursor('<SQL_ID>'));

SELECT * FROM TABLE(dbms_xplan.display_awr('<SQL_ID>'));

SPOOL OFF