Monday, May 27, 2013

Oracle Query run between specific time in a database

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