My Oracle Support Banner

Why the Database Parameter Differs Between the Single Database and RAC Database for Agile Database Instance (Doc ID 2746431.1)

Last updated on JANUARY 24, 2024

Applies to:

Oracle Agile PLM Framework - Version 9.3.6.0 and later
Information in this document applies to any platform.

Goal

There are some differences with the database parameters between the Agile PLM database installed in the single database environment and the RAC database environment as following:

 
Database Parameter Single Database RAC Database
_kgl_large_heap_warning_threshold 8388608 N/A
db_cache_size 208M 0
db_files 254 200
fast_start_mttr_target 300 0
hash_area_size 40291456 131072
java_pool_size 144M 0
large_pool_size 32M 0
shared_pool_size 1104M 0
sort_area_size 20145728 65536
streams_pool_size 48M 0

What is the reason of having such differences?
Is there any impact having the differences, and if there is any, what can be done to avoid the problem?
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.