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 laterInformation 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 |