HugePages can be a very helpful kernel setting for large Oracle Databases with SGA’s larger than 10gb. Using my own company for example here is what we did. We have a large 2.5tb Oracle Database running on OEL 5.3 Tikanga. Our SGA is currently set to 64gb. HugePages was not set. One day we had […]
SQL> SELECT value$ FROM sys.props$ WHERE name = ‘NLS_CHARACTERSET’; VALUE$ ——————————————————————————– UTF8 From my perspective UTF8 is no longer needed as the default NLS_CHARACTERSET. With HPUX it may be, but now oracle enterprise linux or redhat using AL32UTF8 is a better and more accepted alternative.