SQL Scripts

 
--
-- fsql.sql
--
define V_SQL="&1"
SELECT /* NOT_ME */
        SQL_ID
,       CHILD_NUMBER
,       IS_REOPTIMIZABLE
,       substr(SQL_TEXT,1,40) SQL_TEXT
FROM   V$SQL
WHERE  SQL_TEXT LIKE '%&&V_SQL.%'
  AND  SQL_TEXT NOT LIKE '%NOT_ME%'
/
--
undefine V_SQL
 
--
-- xpl.sql
--
define V_SQL_ID="&1"
--
select * from table(dbms_xplan.display_cursor('&&V_SQL_ID',null,FORMAT=>'ADVANCED, ALLSTATS LAST'));
--
undefine V_SQL_ID