To realize rapid inquiry of the dispensing results in prescription dispensing subsystem. SQL statement tracer was used to determine corresponding SQL statement, and the executive plan was analyzed to find the desired table. Proper indexes were established to enhance the efficiency of the inquiry statement. The optimization of SQL statements made the executive efficiency increased greatly without the need for hardware upgrade. The analysis on the executive plan of the dispensing inquiry statements and the indexes on corresponding tables increases the prescription dispensing inquiry speed while decrease the waiting time of the staff.

The Logminer utility has been provided by the latest Oracle 8i version.It can analyze archived log files and online log files.This paper introduces how to install and use this utility,especially how to make the use of the auditing function on key users and key data tables,as well as recover the hostility operation without the shutdown of database.

Objective To gather laboratory results automatically.Methods An interface software was developed with Mscomm32 control and PowerBuilder.Result The results of laboratory instruments were input into LIS database automatically.Conclusion Hospital engineer can realize the connection of laboratory instruments with Mscomm32 control and PowerBuilder.

It is the foundation of HIS that the database system runs well.Therefore,the database administrator is required to recover it rapidly when the system is broken down.This paper introduces how to backup and recover database by using RMAN which ORACLE corporation recommends.It is more rapid and more reliable than traditional cool backup and online backup.