Display the Contents of a SQL Tuning Set
--
-- Display the Tuning Set
--
 
SELECT SQL_ID, 
       PARSING_SCHEMA_NAME, 
       SQL_TEXT, 
       ELAPSED_TIME, 
       BUFFER_GETS
FROM
       TABLE(DBMS_SQLTUNE.SELECT_SQLSET( 'STS_ID'));

Published 1st November 2021

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License