-- ************************************************************
-- *** Feel free to use this SQL-code, but please           ***
-- *** do not remove these copyright lines.                 ***
-- *** (C) Roger Felix - Lund - Sweden                      ***
-- *** [roger_felix@hotmail.com, web_master@work.utfors.se] ***
-- *** URL: http://hem.fyristorg.com/publish/index.html     ***
-- ************************************************************

-- ***************************************************************
-- ** THIS SCRIPT RETRIEVES NEWLY EXECUTED ROWS FROM V$SQLAREA ***
-- ** AFTER TEST PERIOD. ***
-- ***************************************************************

set linesize 1000
set heading off
set trimspool on;
set arraysize 1;

spool output.log

select a.sql_text from v$Sqlarea a 
  where not (a.sql_text, a.EXECUTIONS) in (
    select SQL_TEXT,  EXECUTIONS  
      from my_sqlarea);

spool off;
select 'host notepad output.log' from dual;