select a.SQL_FULLTEXT,
a.SQL_ID,
a.MODULE,
TO_CHAR(a.LAST_ACTIVE_TIME,'yy-mm-dd hh24:mi:ss')
from v$sql a
where TO_CHAR(a.LAST_ACTIVE_TIME,'yy-mm-dd hh24:mi:ss') between '17-06-27 09:30:00' and '17-06-27 20:30:00'
--AND A.MODULE = 'SQL*Plus'
--AND A.SQL_FULLTEXT LIKE '%BETWEEN%'
--AND A.SQL_FULLTEXT LIKE '%A01%'
AND A.SQL_FULLTEXT LIKE '%21_SHUKKA_M A21M%'
--AND A.SQL_FULLTEXT LIKE '%,COUNT(MAIN.SEQ_NO) OVER(PARTITION BY MAIN.JUCHU_ID) AS ROW_SPAN%'
and A.SQL_FULLTEXT LIKE '%油%'
order by a.LAST_ACTIVE_TIME desc
/
conn SYS/pwd AS sysdba
/
SELECT SQL_ID,FIRST_LOAD_TIME,SQL_TEXT
FROM V$SQL
WHERE 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 DESC;
/
SELECT
v.sql_id,
v.elapsed_time,
v.cpu_time,
v.disk_reads,
v.sql_fulltext,
v.child_number,
v.sql_text
FROM
v$sql v
WHERE v.sql_text LIKE '%A21%'
a.SQL_ID,
a.MODULE,
TO_CHAR(a.LAST_ACTIVE_TIME,'yy-mm-dd hh24:mi:ss')
from v$sql a
where TO_CHAR(a.LAST_ACTIVE_TIME,'yy-mm-dd hh24:mi:ss') between '17-06-27 09:30:00' and '17-06-27 20:30:00'
--AND A.MODULE = 'SQL*Plus'
--AND A.SQL_FULLTEXT LIKE '%BETWEEN%'
--AND A.SQL_FULLTEXT LIKE '%A01%'
AND A.SQL_FULLTEXT LIKE '%21_SHUKKA_M A21M%'
--AND A.SQL_FULLTEXT LIKE '%,COUNT(MAIN.SEQ_NO) OVER(PARTITION BY MAIN.JUCHU_ID) AS ROW_SPAN%'
and A.SQL_FULLTEXT LIKE '%油%'
order by a.LAST_ACTIVE_TIME desc
/
conn SYS/pwd AS sysdba
/
SELECT SQL_ID,FIRST_LOAD_TIME,SQL_TEXT
FROM V$SQL
WHERE 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 DESC;
/
SELECT
v.sql_id,
v.elapsed_time,
v.cpu_time,
v.disk_reads,
v.sql_fulltext,
v.child_number,
v.sql_text
FROM
v$sql v
WHERE v.sql_text LIKE '%A21%'