SELECT
SQL_ID ||','|| MODULE ||','|| FIRST_LOAD_TIME
,DBMS_LOB.SUBSTR(t1.SQL_FULLTEXT, 1000, 1) AS C1
,CASE WHEN DBMS_LOB.GETLENGTH(SQL_FULLTEXT) > 1000
THEN DBMS_LOB.SUBSTR (t1.SQL_FULLTEXT,1000, 1001) END AS C2
,CASE WHEN DBMS_LOB.GETLENGTH(SQL_FULLTEXT) > 2000
THEN DBMS_LOB.SUBSTR (t1.SQL_FULLTEXT,1000, 2001) END AS C3
,CASE WHEN DBMS_LOB.GETLENGTH(SQL_FULLTEXT) > 3000
THEN DBMS_LOB.SUBSTR (t1.SQL_FULLTEXT,1000, 3001) END AS C4
,CASE WHEN DBMS_LOB.GETLENGTH(SQL_FULLTEXT) > 4000
THEN DBMS_LOB.SUBSTR (t1.SQL_FULLTEXT,1000, 4001) END AS C5
,CASE WHEN DBMS_LOB.GETLENGTH(SQL_FULLTEXT) > 5000
THEN DBMS_LOB.SUBSTR (t1.SQL_FULLTEXT,1000, 5001) END AS C6
,CASE WHEN DBMS_LOB.GETLENGTH(SQL_FULLTEXT) > 6000
THEN DBMS_LOB.SUBSTR (t1.SQL_FULLTEXT,1000, 6001) END AS C7
from v$sqlarea t1
where
MODULE = 'w3wp.exe'
and FIRST_LOAD_TIME BETWEEN TO_CHAR(SYSDATE - (5 / 24 / 60), 'YYYY-MM-DD/HH24:MI:SS') AND TO_CHAR(SYSDATE, 'YYYY-MM-DD/HH24:MI:SS')
order by FIRST_LOAD_TIME;