数据库性能（Database performance）.doc

数据库性能（Database performance） Published in 2006-10-23 00:05, see only the author Experience in database physics design Physical distribution design of database Author: CCBZZP Summary Whether we use what kind of database, regardless of how to design the database, I think will follow a principle: data security and performance of the two main aspects, but on the two aspects of the topic is too much, not a statement here, I just from the design of the database physical distribution and simple together discuss. Because the database has a good physical distribution design, it also has a high impact on data security and performance, just as we have to lay the ground before we build the building. In reality, when we use a variety of different databases, tend to ignore the physical layout of the database, only when encountering problems in database performance to consider, but this is not only so The loss outweighs the gain., will lead to the problems associated with the design, but also affect the performance of the adjustment effect, so we create a database in the physical layout before planning database is also very necessary, this is also in line with people often say modaobuwukanchaigong. Here I will take Oracle as an example from the optimization of operating system, disk layout optimization and configuration, database initialization parameter selection, establishment and management of memory, set up and manage CPU, setup and management table space, setting up and managing rollback segment, set up and manage the online redo log, set several disposal and management of archived redo logs, and settings management control file as a statement. I. optimizing the operating system In order to obtain the best performance of the server, the optimization of operating system is very necessary, because the operating system performance problems usually involve process management, memory management, scheduling, so users need to ensure adequate I/O bandwidth and CPU processing capabilit