Showing posts with label oracle get sql statistic between dates. Show all posts
Showing posts with label oracle get sql statistic between dates. Show all posts

Tuesday, February 16, 2010

Getting SQL Statistics between given dates

ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY HH24:MI:SS';

EXECUTE DBMS_LOGMNR.START_LOGMNR( STARTTIME => '16-FEB-2010 14:30:00', ENDTIME => '16-FEB-2010 15:00:00',options=> DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG +DBMS_LOGMNR.CONTINUOUS_MINE);

set pause on;

set linesize 2000;

SELECT TIMESTAMP,SQL_REDO,SESSION# FROM V$LOGMNR_CONTENTS WHERE seg_owner='CSVM' and TABLE_NAME = 'UMMESSAGE' and sql_redo like '%1647293%'