In Large-scale ERP System Oracle Table Space Plan
Zhang Xiao · Computer Knowledge and Technology · 2008
In large-scale ERP system, if the database is Oracle, we should make an effective plan, in order to avoid the database’s uncoordinating or lower operating efficiency during the course of working. Establish some big data sheet spaces including the data sheet space, the index table space, returns rolls table space and temporary data space. Simultaneously according to the visiting quantity of ERP system, determine how many returns rolls section to be established. At the same time, dataspace is supposed to be established as far as possible on different physical disk to reduse the I/O competition between users.