Home > Workload Solutions > Oracle > White Papers > Modernize Your Oracle Database Server Platform and Accelerate Deployments > Oracle database parameters
It is important to size the SGA properly when deploying Oracle databases. If the SGA is too small, excessive physical I/O is unavoidable and could lead to poor database performance. To reduce the time that the database is waiting on I/O, the engineers increased the SGA from 128GB (default) to 256GB during testing and observed a significant increase in performance. To determine the optimal setting for the SGA requires examination of the Oracle AWR report. Changing it arbitrarily would not help the performance but could compromise it. It is important to thoroughly examine this report to assign the proper SGA size for you system because every Oracle workload is unique.
Another database setting to consider adjusting is the Oracle undocumented parameter _high_priority_processes. This parameter allows the LGWR process to have higher CPU priority. When running an Oracle database in a production environment, it is best to consider setting this hidden parameter to “LMS*|VKTM|LGWR” for better database performance. However, since this is an undocumented database parameter, consider consulting Oracle Support before using it. For more information on the database best practices, see Database Best Practices.
This solution architecture for Oracle brings together an optimized database infrastructure that offers flexibility in terms of hardware resources. It has been thoroughly tested by Dell engineers to that ensure all layers, hardware and software, work together. The best practices for each component have been tuned and validated to provide a robust infrastructure for Oracle database OLTP workloads deployments. This work is a time-consuming process due to its complexities and having it validated before procurement saves valuable time for the system administrators.