数据库性能调优（Database performance tuning）.doc

数据库性能调优（Database performance tuning） I. process Explanation: ora indicates the process sign of Oracle, in which PMON, psp0 and so on represent the process type name, and test represents the instance name Ora_pmon_test process monitoring process Ora_psp0_test Ora_mman_test Ora_dbw0_test data writing process Ora_lgwr_test log writing process Ora_ckpt_test Ora_smon_test SMON monitoring system is a system level view, is a garbage collector for library . The steward of the household chores Ora_reco_test Ora_cjq0_test Ora_mmon_test Ora_mmnl_test Ora_d000_test Ora_s000_test Ora_qmnc_test Ora_q000_test Ora_q001_test The library cache and the dictionary cache together form a shared pool buffer cache = data cache + log buffer, +JAVA pool + pool Shared pool + buffer cache =SGA Contains private and shared activities of SQL and PL/SQL region statistical information database buffer retained in the dynamic performance tables in the data dictionary v$librarycache Select sum Library in the buffer (pins), sum (reloads) from v$librarycache; Pins SQL PL/SQL statements are given, and the total number of blocks accessed object defined by Reloads and SQL are listed; PL/SQL Block Implicit analysis in library or object buffer defined in the heavy load time error. If sum (pins) /sum (reloads) = 0, then the database buffer hit rate; if sum (pins) /sum (reloads) 1, then adjust the shared_pool_size initialization parameter to adjust the amount of memory allocated to the shared pool. Oracle database server is the core of the whole system, and its performance directly affects the performance of the entire system. In order to adjust the performance of Oracle database server, the following aspects should be considered: 1, adjust the operating system for the operating system Oracle database server running the Oracle database server is largely dependent on the operation of the server, if the operating system does not provide the best performance, so in any case adjustment, Oracle database server can