STS Notes

Display Contents of a STS
=============================
SELECT NAME,OWNER,CREATED,STATEMENT_COUNT FROM DBA_SQLSET where name='test3';


select sql_id, substr(sql_text,1, 15) text from dba_sqlset_statements where sqlset_name = 'test3' order by sql_id;

To Verify the execution Plan of a SQL_ID in the STS for an user sql.
======================================================================

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