9 lines
243 B
Plaintext
9 lines
243 B
Plaintext
|
-- for a cursor in library cache
|
||
|
|
set pages 999 lines 200
|
||
|
|
select * from table(dbms_xplan.display_cursor('&&SQL_ID',null,null));
|
||
|
|
|
||
|
|
-- from AWR
|
||
|
|
set pages 999 lines 200
|
||
|
|
select * from table(dbms_xplan.display_awr('&&SQL_ID',null,null,'ADVANCED'));
|
||
|
|
|