Parent topic: Enterprise Back Office on Multiple Servers
Oracle MICROS recommends setting the following Oracle Database configurations when creating the database instance and before running an Enterprise Back Office product installer. While some configurations can be changed after the installation, preparing the database instance prior to schema installation can prevent unexpected errors and problems.
Oracle Database Configuration for Enterprise Back Office Database
Parameter | Recommended Value | |
---|---|---|
db_block_size |
16384 |
|
open_cursors |
20000 |
|
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. |
Oracle Database Tablespaces for Enterprise Back Office Database
COREDB
PORTALDB
LOCDB
LOC_INDX
RTA
PENTAHO or SMALLFILE
Not applicable for 9.1 New Tech Stack
CEDB
TEMP
Parent topic: Installing Enterprise Back Office on Oracle Database
Parent topic: Installing Enterprise Back Office on Oracle Database
Related Topics
Parent topic: Installing Enterprise Back Office on Oracle Database