Parent topic: Enterprise Back Office with Oracle MICROS Simphony
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 | |
---|---|---|
Instance Name |
<CustomerName><Environment ID><EnvironmentPurpose P/S/T>MM For example, for customer ABC, environment ID 1, and environment purpose P for production: ABC01PMM |
|
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
CEDB
SAML_INDX
ORCLRNA_BIPLATFORM
ORCLRNA_MDS
TEMP
Oracle Database Configuration for Enterprise Back Office Aggregation Database
Parameter | Recommended Value | |
---|---|---|
Instance Name |
<CustomerName><Environment ID><EnvironmentPurpose P/S/T>AGG For example, for customer ABC, environment ID 1, and environment purpose P for production: ABC01PAGG |
|
db_block_size |
8192 |
|
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. |
|
deferred_segment_creation |
TRUE |
|
_index_partition_large_extents |
FALSE |
|
_partition_large_extents |
FALSE |
Oracle Database Tablespaces for Enterprise Back Office Aggregation Database
AGGREGATE_DB
AGGREGATE_INDX
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