Posted on 2014-12-04
I see the following message in the alert log when the database is restarted:
Total System Global Area size is 12 GB. For optimal performance,
prior to the next instance restart:
1. Increase the number of unused large pages by
at least 6145 (page size 2048 KB, total size 12 GB) system wide to
get 100% of the System Global Area allocated with large pages
2. Large pages are automatically locked into physical memory.
Increase the per process memlock (soft) limit to at least 12 GB to lock
100% System Global Area's large pages into physical memory
Multiplying the 6145 by 2048 i get 12584960 . If i have 12G SGA would i not be going over the max if i use the figures given by Oracle in the alert log?
If so, is that of any consequence?