Oracle Database

Install one of the supported Oracle Database versions. To prevent future errors, the table below shows the recommended Oracle Database configuration values. Set these values before running the Inventory Management installer.

Parameter Recommended Value

Instance Name

<CustomerName><Environment ID><EnvironmentPurpose P/S/T>INV

For example, for customer ABC, environment ID 1, and environment purpose P for production:

ABC01PINV

db_block_size

8192

open_cursors

1000

db_recovery_file_dest_size

Set as the amount of storage allocated to FRA and DATA.

job_queue_processes

64

aq_tm_processes

1

session_cached_cursors

100

optimizer_mode

first_rows_10

optimizer_index_caching

20

optimizer_index_cost_adj

20

cusrsor_sharing

exact

processes

1024

sga_max_size

Set as 50% of database RAM, to be tuned by the DBA during the life of the environment.

sga_target

Set as the same value as sga_max_size.

pga_target

Set as 25% of sga_target.