Databases Reference
In-Depth Information
There's more...
To obtain maximum performance from Oracle database, a better option is to keep all the
required memory structures in the physical memory, if enough memory is available. In order
to do this, it is advisable to keep the SGA limit below the available physical memory. On
Solaris systems, we can use Intimate Shared Memory (ISM), a feature that allows multiple
OS processes accessing the shared memory to use the same Translation Lookaside Buffers,
saving a lot of kernel memory space.
On the Linux Platform, we can use hugepages to obtain a page size of 2 MB instead of the
older 4 KB. The memory space used by hugepages is locked and cannot be paged out.
For more details on using hugepages there is a good
article on Metalink 361323.1.
See also
F
Other optimizations at OS level—regarding I/O—are discussed in
Disk
tuning
and
strategies
to
distribute
Oracle
files
and
Using
Asynchronous
I/O
in
Chapter
10
,
Tuning I/O