14
Enable the Hardware Prefetcher. The Hardware Prefetcher proactively collects data from the
memory to the cache in order to reduce response time. If the application is memory intensive, this
enablement may have a negative impact on the performance.
In the BIOS menu under Power Management Options set the HP Power Profile to Maximum
Performance.
For environments not running Virtual Machines – Disable Virtualization support in the BIOS as well
as INTEL VT-D.
By default Drive Write Cache is Disable and should remain disabled using VMA attached storage.
Do not use slot 1 for any HP VMA PCIe Pass Thru Cards. It is a PCI-x Gen1 slot.
Set HUGE pages for system global area (SGA) to 2MB. The main advantages of creating an SGA
using huge pages has to do with increased performance from improving the translation lookaside
buffer (TLB) hit ratio and reducing the memory footprint required for mapping the SGA.
Oracle database setup
Location of Oracle 11gR2 binaries
The Oracle database software should be installed separately from the storage used for the database
instance itself. The recommended configurations are designed with the intent that the Oracle binaries
be placed on the same drives as the OS. There is no performance benefit to separating the OS and
Oracle binaries on different drives, though some customers will chose to do so to simplify system
backup and maintenance operations.
Oracle databases location
For the HP VMA storage configuration it is recommended that the Oracle database components, such
as data, indexes, undo, temp and redo, should be managed with Oracle Automatic Storage
Management (ASM) to stripe across the storage arrays. ASM should be used in “external
redundancy” mode, since the VMA arrays themselves will provide the RAID level protection for the
databases.
The HP P6300 EVA is used for additional database storage requirements such as database backups,
flash recovery area, storing archive logs, test, QA, training, sandbox and development environments.
There is fibre channel connectivity between the P6300 EVA and the production and test/dev DL980
servers through a pair of fibre channel switches.
Memory allocation for OS
In an Oracle 11gR2 setup it is recommended to use any extra memory available on the system for the
system global area (SGA). This can improve I/O performance. Leave 10% of the memory available
for the operating system and about 4% for buffer cache.
Patching
Make sure the Linux operating system and Oracle database is patched to current patch releases for
best performance and problem resolution. Please refer to the Oracle database installation guide and
release notes for recommended patch, OS, and database parameter recommendations.
Other best practice recommendations you may want to consider:
Enable NUMA mode by setting the Oracle database parameter:
– _enable_NUMA_support = true
– If NUMA is enabled, alert.log will trace it as “NUMA system found and support enabled”
(22 Seiten)
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Kommentare zu diesen Handbüchern