SELECT
h.sample_time,
u.username,
h.program,
h.module,
s.sql_text
FROM
DBA_HIST_ACTIVE_SESS_HISTORY h,
DBA_USERS u,
DBA_HIST_SQLTEXT s
WHERE sample_time >= SYSDATE - 7
AND h.user_id=u.user_id
AND h.sql_id = s.sql_iD
ORDER BY h.sample_time)

پسندها(0)شاکی(0)