Database Management Settings

Definition

This group includes all the system parameters concerning the back-end database management.

Setting Up System Parameters

You can set up the following system parameters that are available for different instance types in the running SAP CC Core Server system.

Parameters	Summary
ORACLE_COMMIT_WRITE	Commit option used within internal stateful operations performed on the Core Database
ORACLE_RATING_SESSION_COMMIT_WRITE	Commit option used within internal stateful operations performed on the Session Database
RATING_SESSION_SQLHELPER_CONNECTION_COUNT	The total number of connections to open on an instance of the Session Database
RATING_SESSION_SQLHELPER_CONNECTION_HEARTBEAT	The frequency (in seconds) of heartbeat operations sent to the Session Database
RATING_SESSION_SQLHELPER_DB_INSTANCE_COUNT	The number of Session Database instances that can be used by the raters of the SAP CC system
RATING_SESSION_SQLHELPER_DB_TIMEOUT	The frequency (in seconds) of ping operations sent to the Session Database
RATING_SESSION_SQLHELPER_JDBC_PROPERTIES	The properties used to connect to the Session Database
RATING_SESSION_SQLHELPER_JDBC_URI_DBI1	The JDBC URI to connect to the first instance of a multi-instance Session Database system
RATING_SESSION_SQLHELPER_JDBC_URI_DBI10	The JDBC URI to connect to the tenth instance of a multi-instance Session Database system
RATING_SESSION_SQLHELPER_JDBC_URI_DBI11	The JDBC URI to connect to the eleventh instance of a multi-instance Session Database system
RATING_SESSION_SQLHELPER_JDBC_URI_DBI12	The JDBC URI to connect to the twelfth instance of a multi-instance Session Database system
RATING_SESSION_SQLHELPER_JDBC_URI_DBI2	The JDBC URI to connect to the second instance of a multi-instance Session Database system
RATING_SESSION_SQLHELPER_JDBC_URI_DBI3	The JDBC URI to connect to the third instance of a multi-instance Session Database system
RATING_SESSION_SQLHELPER_JDBC_URI_DBI4	The JDBC URI to connect to the fourth instance of a multi-instance Session Database system
RATING_SESSION_SQLHELPER_JDBC_URI_DBI5	The JDBC URI to connect to the fifth instance of a multi-instance Session Database system
RATING_SESSION_SQLHELPER_JDBC_URI_DBI6	The JDBC URI to connect to the sixth instance of a multi-instance Session Database system
RATING_SESSION_SQLHELPER_JDBC_URI_DBI7	The JDBC URI to connect to the seventh instance of a multi-instance Session Database system
RATING_SESSION_SQLHELPER_JDBC_URI_DBI8	The JDBC URI to connect to the eighth instance of a multi-instance Session Database system
RATING_SESSION_SQLHELPER_JDBC_URI_DBI9	The JDBC URI to connect to the ninth instance of a multi-instance Session Database system
RATING_SESSION_SQLHELPER_LOGIN	The login used to connect to the Session Database
RATING_SESSION_SQLHELPER_MAX_REDO	The maximum number of redo attempts when a deadlock occurs on the Session Database
RATING_SESSION_SQLHELPER_PASSWORD	The password used to connect to the Session Database
RATING_SESSION_SQLHELPER_RECONNECT_ATTEMPTS	The maximum number of connection attempts made after a connection to the Session Database has been lost
RATING_SESSION_SQLHELPER_RECONNECT_INTERVAL	The time period in seconds between reconnection attempts after a connection to the Session Database is lost
RATING_SESSION_SQLHELPER_STATEMENT_CACHE_SIZE	The size of the SQL request statement cache for the Session Database
SQLHELPER_CONNECTION_COUNT	The total number of connections to open on an instance of the Core Database
SQLHELPER_CONNECTION_HEARTBEAT	The frequency (in seconds) of heartbeat operations sent to the Core Database
SQLHELPER_DB_INSTANCE_COUNT	The number of Core Database instances that can be used by the raters of the SAP CC system
SQLHELPER_DB_TIMEOUT	The frequency (in seconds) of ping operations sent to the Core Database
SQLHELPER_ID_INTERVAL	The size of the pool of unique identifiers used to identify the objects into the database
SQLHELPER_JDBC_PROPERTIES	The properties used to connect to the Core Database
SQLHELPER_JDBC_URI	The JDBC URI(s) to connect to the database systems
SQLHELPER_JDBC_URI_DBI1	The JDBC URI to connect to the first instance of a multi-instance Core Database system
SQLHELPER_JDBC_URI_DBI10	The JDBC URI to connect to the tenth instance of a multi-instance Core Database system
SQLHELPER_JDBC_URI_DBI11	The JDBC URI to connect to the eleventh instance of a multi-instance Core Database system
SQLHELPER_JDBC_URI_DBI12	The JDBC URI to connect to the twelfth instance of a multi-instance Core Database system
SQLHELPER_JDBC_URI_DBI2	The JDBC URI to connect to the second instance of a multi-instance Core Database system
SQLHELPER_JDBC_URI_DBI3	The JDBC URI to connect to the third instance of a multi-instance Core Database system
SQLHELPER_JDBC_URI_DBI4	The JDBC URI to connect to the fourth instance of a multi-instance Core Database system
SQLHELPER_JDBC_URI_DBI5	The JDBC URI to connect to the fifth instance of a multi-instance Core Database system
SQLHELPER_JDBC_URI_DBI6	The JDBC URI to connect to the sixth instance of a multi-instance Core Database system
SQLHELPER_JDBC_URI_DBI7	The JDBC URI to connect to the seventh instance of a multi-instance Core Database system
SQLHELPER_JDBC_URI_DBI8	The JDBC URI to connect to the eighth instance of a multi-instance Core Database system
SQLHELPER_JDBC_URI_DBI9	The JDBC URI to connect to the ninth instance of a multi-instance Core Database system
SQLHELPER_LOGIN	The login used to connect to the Core Database
SQLHELPER_MAX_REDO	The maximum number of redo attempts when a deadlock occurs on the Core Database
SQLHELPER_PASSWORD	The password used to connect to the Core Database
SQLHELPER_RECONNECT_ATTEMPTS	The maximum number of connection attempts made after a connection to the Core Database has been lost
SQLHELPER_RECONNECT_INTERVAL	The time period in seconds between reconnection attempts after a connection to the Core Database is lost
SQLHELPER_STATEMENT_CACHE_SIZE	The size of the SQL request statement cache for the Core Database