工作記

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%'