The Database Performance Tuning On Hospital Information System

The database of Hospital Information Sysytem(HIS) is specialized by its large input/output datas , frequency data delete/update/insert and it requires the database to process the datas with efficiency , timely and accuracy. So it is very important to tune the database's performance, i.e. improve the input/output mount of database and decrease the waiting time of system to respond.We only consider the operation system, the applied software on client machine, net and other hardware etc. , When tuning the database performance with traditional way. If we only tune the database's round environment, it just respited the situation, and could not resolve the problem at all. In practice, the informaton system (including database) was well designed and the database's performance is turn up with increasing database.This paper is based on database of Hospital Information System .The paper considers to tune database's performance from system structure, store structure and object structure etc. From ORACLE system structure, the paper organizes and allocates memory with SGA (system global area) and PGA (program global area). The key of performance tuning is to confirm the hit ratio of system. The ORACLE system's store structure includes physicial structure and logical structure. So , it is the basis to decide the size of tablespace, data file and control file. The database object includes index, cluster, views and store procedure etc., the object have important effect on database. Lastly, it contrasts the ways of Based on Cost and Based on Rule and organizes the SQL under SQL/PLUS system environment.