Set Oracle Parameters - Intergraph Smart Engineering Manager - 11 - Installation & Upgrade - Hexagon

Intergraph Smart Engineering Manager Installation and Upgrade

Language
English
Product
Intergraph Smart Engineering Manager
Search by Category
Installation & Upgrade
Smart Engineering Manager Version
11

If you are using an Oracle database, you must modify the following parameters in the initsid name.ora file using Oracle Enterprise Manager before you begin your upgrade. After completing the upgrade process, reset these parameters to their original values.

OPEN_CURSORS

Set to at least 500. You can use a higher number if necessary for other applications. Hexagon PPM software uses open cursors to improve performance and scalability for database inserts, updates, and deletes.

Hash Parameters

Provide extra memory for the Oracle hash procedure by setting the following hash parameters to the values shown below. The upgrade process runs much faster if the hash table fits in RAM, rather than being written to and read from the disk. Therefore, by providing extra memory for this procedure during the upgrade process, you can significantly reduce the time required.

hash_join_enabled=true

True is the default setting. However, you should make sure the setting was not previously changed to False.

hash_area_size=number

This setting determines how much RAM is available for use by the hash tables. The default value for hash_area_size is 131072, and the value you enter for number should be a multiple of this default value. The new value should be as large as possible without interfering with the needs of the operating system. A value of 1310720 (default x 10) would not be unreasonable for a server with a gigabyte or more of memory.