Parameter |
Size |
---|---|
OPEN_CURSORS |
1024 |
SESSION_CACHED_CURSORS |
100 |
MEMORY_TARGET |
If using Automatic Memory Management, specify the MEMORY_TARGET parameter. For a single instance, allocate 40 percent of the total RAM. Afterward, use the Oracle memory advisors to determine the optimal amount of memory for your installation. If excessive paging occurs, reduce the size of this parameter. See Oracle RDBMS installation documentation for more information on the maximum memory sizes for your platform. |
SGA_TARGET |
If using Shared Memory Management, specify the SGA_TARGET parameter. For a single instance, allocate 40 percent of the total RAM. Afterwards, use the Oracle SGA memory advisor to determine the optimal amount of SGA memory for your installation. If excessive paging occurs, reduce the size of this parameter. See Oracle RDBMS installation documentation for more information on the maximum SGA size for your platform. |
PGA_AGGREGATE_TARGET |
If using Shared Memory Management, you may specify the PGA_AGGREGATE_TARGET parameter. Start with a value of 512M. Use the Oracle PGA memory advisor to determine the optimal amount of PGA memory for your installation. If excessive paging occurs, reduce the size of this parameter |
JOB_QUEUE_PROCESSES |
10 |
QUERY_REWRITE_ENABLED |
TRUE |
COMPATIBLE |
19.0, 18.0, 12.2.0, or 12.1.0 depending on the version of the database installed |
NLS_LANG |
LANGUAGE_TERRITORY. Character set See the discussion in the section labeled "Pre-installation considerations" for the appropriate character set. |
REMOTE_DEPENDENCIES_MODE |
SIGNATURE |
RESULT_CACHE_MAX_SIZE |
Should be set to 0 for any edition other than Oracle Enterprise Edition. If using Enterprise Edition, start at 64MB. |