Database Parameters
MODS Regular Default Database Parameters
MODS Regular databases are deployed with the following default parameters:
| Parameter | Value |
|---|---|
| audit_file_dest | /u01/app/oracle/admin/{ oracle_db_unique_name }/adump |
| audit_trail | db |
| clonedb | true |
| compatible | 19.0.0 |
| control_files | /u04/oradata/{ oracle_db_unique_name }/control01{ oracle_cdb_name }.ctl,/u05/oradata/{ oracle_db_unique_name }/control02{ oracle_cdb_name }.ctl,/u04/oradata/{ oracle_db_unique_name }/control03{ oracle_cdb_name }.ctl |
| control_management_pack_access | DIAGNOSTIC+TUNING |
| db_block_size | 8k |
| db_create_file_dest | /u02/oradata |
| db_create_online_log_dest_1 | /u04/oradata/{ oracle_db_unique_name } |
| db_create_online_log_dest_2 | /u05/oradata/{ oracle_db_unique_name } |
| db_domain | vmmgmnt.trivadis.com |
| db_files | 1000 |
| db_name | { oracle_cdb_name } |
| db_recovery_file_dest | {/u06/fast_recovery_area } |
| db_recovery_file_dest_size | 100G |
| db_unique_name | { oracle_db_unique_name } |
| diagnostic_dest | /u01/app/oracle |
| dispatchers | (PROTOCOL=TCP) (SERVICE={ oracle_cdb_name }XDB) |
| job_queue_processes | vcpu cores * 2 |
| enable_pluggable_database | true |
| max_pdbs *) | 3 |
| nls_language | AMERICAN |
| nls_territory | AMERICA |
| open_cursors | 500 |
| pga_aggregate_target | 12% of system memory |
| processes | vcpu cores * 250 |
| remote_login_passwordfile | EXCLUSIVE |
| session_cached_cursors | 500 |
| sga_target | 60% of system memory |
| undo_tablespace | UNDOTBS1 |
*) applies for SE2 only; with EE the default value is used.
Note: With Oracle Database 19c, you are allowed to deploy up to three user-created PDBs in a given container database at any time, whithout Oracle Multitenant licence.