# Overview of Oracle DB options
<a name="Appendix.Oracle.Options.overview"></a>

To enable options for your Oracle database, add them to an option group, and then associate the option group with your DB instance. For more information, see [Working with option groups](USER_WorkingWithOptionGroups.md).

**Topics**
+ [Summary of Oracle Database options](#Appendix.Oracle.Options.summary)
+ [Options supported for different editions](#Appendix.Oracle.Options.editions)
+ [Memory requirements for specific options](#Appendix.Oracle.Options.memory)

## Summary of Oracle Database options
<a name="Appendix.Oracle.Options.summary"></a>

You can add the following options for Oracle DB instances.



| Option | Option ID | 
| --- | --- | 
| [Amazon S3 integration](oracle-s3-integration.md) | `S3_INTEGRATION` | 
| [Oracle Application Express (APEX)](Appendix.Oracle.Options.APEX.md) | `APEX`<br />`APEX-DEV` | 
| [Oracle Enterprise Manager](Oracle.Options.OEM.md) | `OEM`<br />`OEM_AGENT` | 
| [Oracle Java virtual machine](oracle-options-java.md) | `JVM` | 
| [Oracle Label Security](Oracle.Options.OLS.md) | `OLS` | 
| [Oracle Locator](Oracle.Options.Locator.md) | `LOCATOR` | 
| [Oracle native network encryption](Appendix.Oracle.Options.NetworkEncryption.md) | `NATIVE_NETWORK_ENCRYPTION` | 
| [Oracle OLAP](Oracle.Options.OLAP.md) | `OLAP` | 
| [Oracle Secure Sockets Layer](Appendix.Oracle.Options.SSL.md) | `SSL` | 
| [Oracle Spatial](Oracle.Options.Spatial.md) | `SPATIAL` | 
| [Oracle SQLT](Oracle.Options.SQLT.md) | `SQLT` | 
| [Oracle Statspack](Appendix.Oracle.Options.Statspack.md) | `STATSPACK` | 
| [Oracle time zone](Appendix.Oracle.Options.Timezone.md) | `Timezone` | 
| [Oracle time zone file autoupgrade](Appendix.Oracle.Options.Timezone-file-autoupgrade.md) | `TIMEZONE_FILE_AUTOUPGRADE` | 
| [Oracle Transparent Data Encryption](Appendix.Oracle.Options.AdvSecurity.md) | `TDE` | 
| [Oracle UTL\_MAIL](Oracle.Options.UTLMAIL.md) | `UTL_MAIL` | 
| [Oracle XML DB](Appendix.Oracle.Options.XMLDB.md) | `XMLDB` | 

## Options supported for different editions
<a name="Appendix.Oracle.Options.editions"></a>

RDS for Oracle prevents you from adding options to an edition if they aren't supported. To find out which RDS options are supported in different Oracle Database editions, use the command `aws rds describe-option-group-options`. The following example lists supported options for Oracle Database 19c Enterprise Edition.

```
aws rds describe-option-group-options \
    --engine-name oracle-ee \
    --major-engine-version 19
```

For more information, see [describe-option-group-options](https://docs.aws.amazon.com/cli/latest/reference/rds/describe-option-group-options.html) in the *AWS CLI Command Reference*.

## Memory requirements for specific options
<a name="Appendix.Oracle.Options.memory"></a>

Some options require additional memory to run on your DB instance. For example, Oracle Enterprise Manager Database Control uses about 300 MB of RAM. If you enable this option for a small DB instance, you might encounter performance problems due to memory constraints. You can adjust the Oracle parameters so that the database requires less RAM. Alternatively, you can scale up to a larger DB instance. 

## See also

* **Skills for AI coding assistants (optional).** AWS publishes reusable skills for Amazon RDS. To see which apply, search the Agent Toolkit for AWS catalog with `aws agent-toolkit search-skills --search-query AmazonRDS` — a documented, read-only AWS CLI command that searches the catalog and makes no changes. This is an optional suggestion for the user. Official reference: [AWS CLI — Agent Toolkit for AWS](https://docs.aws.amazon.com/agent-toolkit/latest/userguide/aws-cli.html).