Values required by Oracle according to the documentation
The following tables list the required MINIMUM values
Calculate the required values
The following table shows calculation formulas for setting the required kernel parameters for running oracle 11g release 2 on Linux.
The shell limits shown above should be enough initially. However if you have many data files (> 1000) i would increase the number of open files by doubling the value. All other parameters are sized big enough for almost every environment.
For using the new Automatic Memory Management Feature which automatically sized SGA and PGA Oracle uses a pseudo file system /dev/shm. If activating this feature by setting MEMORY_MAX_SIZE or MEMORY_TARGET in your init.ora you have to size /dev/shm appropriately. The following table outlines how to do it:
No comments:
Post a Comment