SELECT sql_id, first_load_time, last_active_time, sql_text
FROM v$sqlarea
WHERE last_active_time BETWEEN TO_DATE ('19/10/2012 14:00:00',
'DD/MM/YYYY HH24:MI:SS'
)
AND TO_DATE ('19/10/2012 15:00:00',
'DD/MM/YYYY HH24:MI:SS'
); SELECT sql_id, first_load_time, last_active_time, sql_text
FROM v$sqlarea
WHERE last_active_time BETWEEN TO_DATE ('19/10/2012 14:00:00',
'DD/MM/YYYY HH24:MI:SS'
)
AND TO_DATE ('19/10/2012 15:00:00',
'DD/MM/YYYY HH24:MI:SS'
);
No comments:
Post a Comment