------------------------------  sqlreal/last version: 20170609  ------------------------------
    alter session set CURSOR_SHARING  = force;
    with gu$sql as (
    SELECT
           round(db_time / db_exec / 1000, 2) ela_ms
           ,round(db_cpu / db_exec / 1000, 2) cpu_ms
           ,round((db_time-db_cpu) / db_exec / 1000, 2) wait_ms
           ,round(db_buffer / db_exec, 2) gets
           ,round(db_io / db_exec, 2) reads
           ,round(db_rows/db_exec,0) dbrows
           ,round(elapsed_time/parse_calls/1000,2) parse_ms
           ,case when parse_calls/db_exec>10 then round(db_time / (parse_calls/db_exec) / 1000, 2) else null end ela_exec_ms
           ,round(parse_calls/db_exec,3) parse_exec
           --,round(db_exec/(db_time/1000000),0) exec_sec
           ,db_exec,db_time,db_cpu,db_buffer,db_io,db_rows
           ,sql_text,sql_id,CHILD_NUMBER,command_type
           ,case command_type
                when 2 then 'INSERT'
                when 3 then 'SELECT'
                WHEN 6 then 'UPDATE'
                when 7 THEN 'DELETE'
                when 189 then 'MERGE'
            END COMMMAND_NAME
           ,module,first_load_time2 first_load_time,LAST_ACTIVE_TIME,inst_id
                 ,UPPER(SQL_TEXT) SQL_TEXT_U,parsing_schema_name AS OWNER
                 ,ROW_NUMBER() over (partition by INST_ID,sql_id order by db_exec desc) db_exec_no
    FROM (SELECT   to_date(first_load_time,'yyyy-mm-dd/hh24:mi:ss') first_load_time2,
                   case when t.executions =0 then -1 else t.executions end as db_exec,
                   t.elapsed_time as db_time,
                   t.cpu_time as db_cpu,
                   t.buffer_gets as db_buffer,
                   t.disk_reads as db_io,
                                 t.ROWS_PROCESSED as db_rows
                   ,t.*
              FROM GV$SQL t ) a
    WHERE 1=1
    --and executions =0
    --AND parsing_schema_name LIKE 'FORUM%'
    AND UPPER(SQL_TEXT)  LIKE UPPER('%%US_TICKETINFO_DETAIL%%')
    --and sql_text like '%test%'
    --and sql_text like '%select%a.bookid,a.bookname,a.mcpid,a.mcpname,a.storetime,a.publisher,a.penname,a.bookurl,a.qatimes%from%con_auditbookinfo%'
    --AND (SQL_TEXT)  LIKE '%%JRUN_THREADS%'
    --AND command_type =189 --select
    /*AND command_type = 2 --insert
    AND command_type = 3 --select
    AND command_type = 6 --update
    AND command_type = 7 --delete
    AND command_type = 189 --merge*/
    --AND LAST_ACTIVE_TIME > SYSDATE -1/24
    AND sql_text NOT LIKE '%DBMS_METADATA%'  --exclude sql
    AND sql_text NOT LIKE '%OBJECT_TYPE%'  --exclude sql
    AND sql_text NOT LIKE '%SYS_XMLGEN%'  --exclude sql
    AND sql_text NOT LIKE '%LOCK TABLE%'  --exclude sql
    AND sql_text NOT LIKE '%OPT_DYN_SAMP%'  --exclude sql
    AND UPPER(SQL_TEXT) NOT LIKE '%SQL ANALYZE%'   --exclude sql：统计信息自动收集（DBMS_SCHEDULER）
    AND UPPER(SQL_TEXT) NOT LIKE '%OPT_DYN_SAMP%'  --exclude sql：动态采样:表 module = 'DBMS_SCHEDULER' and action = 'JOB_GATHERTABLESTAT_D'
    AND UPPER(SQL_TEXT) NOT LIKE '%DYNAMIC_SAMPLING%'  --exclude sql：动态采样：索引
    AND UPPER(SQL_TEXT) NOT LIKE '%DBMS_STATS%'  --exclude sql
    and nvl(module,'NO')  not like 'PL/SQL Developer'
    and nvl(module,'NO') not in ('plsqldev.exe','PL/SQL Developer'
        ,'SQL Loader Direct Path Load','Data Pump Worker','ORACLE.EXE')
    --and module='JDBC Thin Client'
    --ORDER BY sql_text
    )
    select sql_id sql_id2,LAST_ACTIVE_TIME LAST_ACTIVE_TIME2,a.*
    from gu$sql a
    where 1=1
    --and sql_id in ('ghhp3rvkvqh8m')
    order by LAST_ACTIVE_TIME  desc nulls last;