Set Oracle Parameters - Intergraph Smart Electrical - 10 - Installation & Upgrade - Hexagon PPM

Intergraph Smart Electrical Installation and Upgrade

Language
English (United States)
Product
Intergraph Smart Electrical
Search by Category
Installation & Upgrade
SmartPlant Foundation / SDx Version
Smart Electrical Version
10
Smart Instrumentation Version
(none)
Smart P&ID Version
10
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.