-- ************************************************************
-- *** 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 STORES ROWS IN V$SQLAREA BEFORE TEST PERIOD. ***
-- ***************************************************************

drop table my_sqlarea;

create table my_sqlarea as select distinct SQL_TEXT ,  EXECUTIONS  
from v$Sqlarea;

create index my_index on my_sqlarea(executions);