Introduction
Database parameters specify how the database is configured. For example, database parameters can specify the amount of resources, such as memory, to allocate to a database.
You manage your database configuration by associating your Oracle database instances and Multi-AZ database clusters with parameter profiles. Tessell provides a recommended parameter profile with default settings specific to each Oracle version. You can also define your parameter profile with customized settings from Tessell’s governance application.
For Oracle database engines options profile is also available to be customized.
Parameter Profile
A database parameter profile acts as a container for engine configuration values applied to one or more database instances.
In a Multi-AZ Tessell database cluster, the settings in the database cluster parameter profile apply to all of the database instances in the cluster. The default Tessell database parameter profile for the Oracle & Oracle version is used for each database instance in the database cluster.
Default & Custom Parameter Profile
If you create an Oracle database instance without specifying a database parameter profile, the database instance uses a default database parameter profile.
Likewise, if you create a Multi-AZ database cluster without specifying a database cluster parameter profile, the database cluster uses a default database cluster parameter profile.
Each default parameter profile contains database engine defaults and Tessell recommended defaults based on the engine, compute class, and allocated storage of the instance.
Tessell Default Parameter Profiles
You can't modify the parameter settings of a default parameter group. Instead, you can create a new profile and apply it to the database instance or cluster.
To create a new parameter profile follow the steps below:
Go to Governance and Select the Database Governance app.
Go to the parameters tab.
Create a New Parameter profile.
4. Set the values for required parameters and create profiles.
Static & Dynamic Parameters
Database instance parameters are either static or dynamic. They differ as follows:
When you change a static parameter and save the database parameter profile, the parameter change takes effect after you manually reboot the associated Tessell database instances. For static parameters, the parameters will be applied on the next reboot and you can plan this accordingly.
Static Parameters
When you change a dynamic parameter, by default the parameter change takes effect immediately, without requiring a reboot. When you use the Tessell Console to change database instance parameter values, it always applies it immediately for dynamic parameters.
Options Profile
Similar to the parameter profile, the options profile for the Oracle database can be customized from the DB governance application in the Tessell console.
The following options can be customized from the Options profile:
Options | Description |
Locator | Oracle Locator provides capabilities that are typically required to support internet and wireless service-based applications and partner-based GIS solutions. |
Native Network Encryption | Oracle Database provides native data network encryption and integrity to ensure that data is secure as it travels across the network. |
TDE | Transparent Data Encryption enables you to encrypt data |
UTL Mail | Utility for managing email which includes commonly used email features, such as attachments, CC, and BCC. |