Skip to main content
All CollectionsOracleOptions and Features
Parameter and Option profiles in for Oracle databases
Parameter and Option profiles in for Oracle databases
Bakul Banthia avatar
Written by Bakul Banthia
Updated over a week ago

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:

  1. Go to Governance and Select the Database Governance app.

  2. Go to the parameters tab.

  3. 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.

Did this answer your question?