To attain database server maximum performance, it is necessary to configure it correctly. It is necessary to mention that the conditions under which the database server is working change along with the way in which the system is operated. It is mainly the size change of the data files that expand and the number of them increases when operating the system. This fact has an impact on the event that can occur – when the database server was approximately optimally configured and debugged after the system had been installed – after certain operating period this setting may not be optimal any more. From this it results that the database server configuration will change and become adapted to the current situation or the current status of the database in the course of time.
The database server configuration change is an activity for which the Oracle administrator in co-operation with the UNIX administrator and the system users are responsible. It is recommended to focus on the following database server parameters:
1. Location and configuration of database data files
– database data files on file system vs. data files on raw devices
2. Load distribution into more disks
– data files distribution into physically different disks
– distribution into different disk controllers
3. Log files on-line redo configuration for on-line and batch operations
4. Multi threaded vs. dedicated server
– determine the more favorable configuration on the basis of monitoring
5. SGA database server memory structure size
It is necessary that the Oracle and the UNIX administrators monitor the database server activity and the operating system activity while operating the system. On the basis of this tracking it is then necessary to quantify the database server performance requirements. On the basis of these requirements it is possible to adjust the database server configuration parameters and follow the system performance change.
Recent Comments