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%'

No comments:

Post a Comment