13
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”
We recommend disabling automatic memory management:
– SGA_TARGET = 0
– MEMORY_TARGET = 0 (Oracle DB 11g)
– MEMORY_MAX_TARGET = 0 (Oracle DB 11g)
Set automatic memory management for the program global area (PGA):
– PGA_AGGREGATE_TARGET and WORK_AREA_POLICY set to AUTO
VMA-series Memory Array storage setup
VMA arrays can be connected directly to existing hardware or can be combined into a hardware refresh or new
opportunities. The following best practices are recommended when using the DL980 and VMA in an Oracle database
environment:
Power on the VMA arrays before powering on the DL980.
(21 Seiten)
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Kommentare zu diesen Handbüchern