Change Database Parameter

A MODS database will be configured "ready-to-use" using a best-practice set of database parameters. The MODS default database parameters are documented in Database Parameters.

In order to configure the PDB according to your requirements, the PDBADMIN user (or any other user with ALTER SYSTEM privilege) can edit database parameters via SQL command. A list of the modifiable database parameters can be retrieved with the following SQL statement:

SELECT name, value
FROM v$system_parameter
WHERE  ispdb_modifiable = 'TRUE'
ORDER BY name;

To modify a parameter, use the ALTER SYSTEM command:

ALTER SYSTEM SET parameter_name=value;

Note: The ALTER SYSTEM SET command is limited by the PDB lockdown profile assigned to the user executing the command. Common user have no restrictions on the ALTER SYSTEM SET statement, while other users may have some limitations (see https://docs.entcloud.swisscom.com/guide/managed-services/managed-oracle-regular/technical-description/security/#common-user-access), and https://docs.entcloud.swisscom.com/guide/managed-services/managed-oracle-regular/technical-description/security/#lockdown-profiles).