Application of LogMiner in No.1 Military Medical Project / 医疗卫生装备

ABSTRACT

Objective To quickly pinpoint and correct errors in the application level in No.1 Military Medical Project. Methods LogMiner, a powerful tool provided by Oracle was used to mine and analyze the redo log files produced by oracle database in No.1 Military Medical Project. The basic concept, configuration and usage of LogMiner were described through an example of the Register Program in No.1 Military Medical Project. Results The errors made by Register Program was quickly pinpointed and then corrected by SQL statements provided by UNDO_VALUE field. Conclusion The method using LogMiner to pinpoint and correct the errors in the application level in No.1 Military Medical Project is simple, accurate and convenient. It should be a basic technique for maintenance personnel of hospital information system.