LogMnr Oracle8i

Иногда бывает потребность проанализировать содержимое журналов транзакций oracle8i (ну используется у нас до сих пор это старье). Вот напоминалка.


execute dbms_logmnr_d.build('log_dict.txt','/u01/admin/main/utl_file_dir');

EXECUTE DBMS_LOGMNR.ADD_LOGFILE( -
LOGFILENAME => '/u01/admin/main/utl_file_dir/main192880.rdo', -
OPTIONS => dbms_logmnr.NEW);
EXECUTE DBMS_LOGMNR.ADD_LOGFILE( -
LOGFILENAME => '/u01/admin/main/utl_file_dir/main192881.rdo', -
OPTIONS => dbms_logmnr.ADDFILE);
EXECUTE DBMS_LOGMNR.ADD_LOGFILE( -
LOGFILENAME => '/u01/admin/main/utl_file_dir/main192882.rdo', -
OPTIONS => dbms_logmnr.ADDFILE);
EXECUTE DBMS_LOGMNR.ADD_LOGFILE( -
LOGFILENAME => '/u01/admin/main/utl_file_dir/main192883.rdo', -
OPTIONS => dbms_logmnr.ADDFILE);
EXECUTE DBMS_LOGMNR.ADD_LOGFILE( -
LOGFILENAME => '/u01/admin/main/utl_file_dir/main192884.rdo', -
OPTIONS => dbms_logmnr.ADDFILE);
EXECUTE DBMS_LOGMNR.ADD_LOGFILE( -
LOGFILENAME => '/u01/admin/main/utl_file_dir/main192885.rdo', -
OPTIONS => dbms_logmnr.ADDFILE);
EXECUTE DBMS_LOGMNR.ADD_LOGFILE( -
LOGFILENAME => '/u01/admin/main/utl_file_dir/main192886.rdo', -
OPTIONS => dbms_logmnr.ADDFILE);
EXECUTE DBMS_LOGMNR.ADD_LOGFILE( -
LOGFILENAME => '/u01/admin/main/utl_file_dir/main192887.rdo', -
OPTIONS => dbms_logmnr.ADDFILE);
EXECUTE DBMS_LOGMNR.ADD_LOGFILE( -
LOGFILENAME => '/u01/admin/main/utl_file_dir/main192888.rdo', -
OPTIONS => dbms_logmnr.ADDFILE);
EXECUTE DBMS_LOGMNR.ADD_LOGFILE( -
LOGFILENAME => '/u01/admin/main/utl_file_dir/main192889.rdo', -
OPTIONS => dbms_logmnr.ADDFILE);
EXECUTE DBMS_LOGMNR.ADD_LOGFILE( -
LOGFILENAME => '/u01/admin/main/utl_file_dir/main192890.rdo', -
OPTIONS => dbms_logmnr.ADDFILE);
EXECUTE DBMS_LOGMNR.ADD_LOGFILE( -
LOGFILENAME => '/u01/admin/main/utl_file_dir/main192891.rdo', -
OPTIONS => dbms_logmnr.ADDFILE);
EXECUTE DBMS_LOGMNR.ADD_LOGFILE( -
LOGFILENAME => '/u01/admin/main/utl_file_dir/main192892.rdo', -
OPTIONS => dbms_logmnr.ADDFILE);
EXECUTE DBMS_LOGMNR.ADD_LOGFILE( -
LOGFILENAME => '/u01/admin/main/utl_file_dir/main192893.rdo', -
OPTIONS => dbms_logmnr.ADDFILE);
EXECUTE DBMS_LOGMNR.ADD_LOGFILE( -
LOGFILENAME => '/u01/admin/main/utl_file_dir/main192894.rdo', -
OPTIONS => dbms_logmnr.ADDFILE);
EXECUTE DBMS_LOGMNR.ADD_LOGFILE( -
LOGFILENAME => '/u01/admin/main/utl_file_dir/main192895.rdo', -
OPTIONS => dbms_logmnr.ADDFILE);
EXECUTE DBMS_LOGMNR.ADD_LOGFILE( -
LOGFILENAME => '/u01/admin/main/utl_file_dir/main192896.rdo', -
OPTIONS => dbms_logmnr.ADDFILE);
EXECUTE DBMS_LOGMNR.ADD_LOGFILE( -
LOGFILENAME => '/u01/admin/main/utl_file_dir/main192897.rdo', -
OPTIONS => dbms_logmnr.ADDFILE);
EXECUTE DBMS_LOGMNR.ADD_LOGFILE( -
LOGFILENAME => '/u01/admin/main/utl_file_dir/main192898.rdo', -
OPTIONS => dbms_logmnr.ADDFILE);
EXECUTE DBMS_LOGMNR.ADD_LOGFILE( -
LOGFILENAME => '/u01/admin/main/utl_file_dir/main192899.rdo', -
OPTIONS => dbms_logmnr.ADDFILE);
EXECUTE DBMS_LOGMNR.ADD_LOGFILE( -
LOGFILENAME => '/u01/admin/main/utl_file_dir/main192900.rdo', -
OPTIONS => dbms_logmnr.ADDFILE);
EXECUTE DBMS_LOGMNR.ADD_LOGFILE( -
LOGFILENAME => '/u01/admin/main/utl_file_dir/main192901.rdo', -
OPTIONS => dbms_logmnr.ADDFILE);


execute dbms_logmnr.start_logmnr( -
dictfilename=>'/u01/admin/main/utl_file_dir/log_dict.txt', -
starttime=>to_date('18-03-2011:12:10','DD-MM-YYYY:HH24:MI'), -
endtime=>to_date('18-03-2011:12:20','DD-MM-YYYY:HH24:MI'));