Verifica Usuarios no Tempfile

set linesize 132
set long 5000
col USERNAME for a15
col OSUSER for a15
col MACHINE for a20
col PROGRAM for a15
col MODULE for a22
col ACTION for a15
col sql_text for a132
select a.USERNAME,a.OSUSER,a.MACHINE,a.PROGRAM,a.MODULE,a.ACTION,a.MB_USED,b.SQL_TEXT
from TK_SORT_USAGE_COLLECTION a, TK_SQLTEXT_FULL_COLLECTION b
where trunc(a.timestamp) = trunc(sysdate-1)
and b.SQL_HASH_VALUE = a.SQL_HASH_VALUE
order by a.MB_USED asc;



select a.TIMESTAMP,a.USERNAME,a.OSUSER,a.MACHINE,a.PROGRAM,a.MODULE,a.ACTION,a.MB_USED,TK_RECOVER_SQLTEXT_TK(a.SQL_HASH_VALUE)
from TK_SORT_USAGE_COLLECTION a
where trunc(a.timestamp) >= trunc(sysdate-3)
order by MB_USED asc;