9 lines
243 B
Plaintext
Executable File
9 lines
243 B
Plaintext
Executable File
-- 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'));
|
|
|