Wednesday, December 22, 2010

Display Plan for SQL from STS(Manual)

select sql_id from dba_sqlset_statements
where sqlset_name = '&STS_Name'
order by sql_id;

SELECT * FROM table ( DBMS_XPLAN.DISPLAY_SQLSET( '&STS_NAME','&SQL_ID'));

No comments:

Post a Comment