Select your cookie preferences

We use essential cookies and similar tools that are necessary to provide our site and services. We use performance cookies to collect anonymous statistics, so we can understand how customers use our site and make improvements. Essential cookies cannot be deactivated, but you can choose “Customize” or “Decline” to decline performance cookies.

If you agree, AWS and approved third parties will also use cookies to provide useful site features, remember your preferences, and display relevant content, including relevant advertising. To accept or decline all non-essential cookies, choose “Accept” or “Decline.” To make more detailed choices, choose “Customize.”

Preferences
Contact Us
Feedback
AWS Documentation
Create an AWS Account

RDS for Oracle parameters

PDF
RSS
Focus mode
RDS for Oracle parameters - Amazon Relational Database Service
DB parameter groupsOracle database initialization parameters

DB parameter groups

In Amazon RDS, you manage parameters using DB parameter groups. For more information, see Parameter groups for Amazon RDS. To view the supported initialization parameters for a specific Oracle Database edition and version, run the AWS CLI command describe-engine-default-parameters.

For example, to view the supported initialization parameters for the Enterprise Edition of Oracle Database 19c, run the following command.

aws rds describe-engine-default-parameters \
    --db-parameter-group-family oracle-ee-19

Oracle database initialization parameters

To find documentation for the initialization parameters, see Initialization Parameters in the Oracle Database documentation. The following initialization parameters have special considerations:

  • ARCHIVE_LAG_TARGET

    This parameter forces a redo log switch after the specified time elapses. In RDS for Oracle, ARCHIVE_LAG_TARGET is set to 300 because the recovery point objective (RPO) is 5 minutes. To honor this objective, RDS for Oracle switches the online redo log every 5 minutes and stores it in an Amazon S3 bucket. If the frequency of the log switch causes a performance issue for your RDS for Oracle database, you can scale your DB instance and storage to one with higher IOPS and throughput. Alternatively, if you use RDS Custom for Oracle or deploy an Oracle database on Amazon EC2, you can adjust the setting of the ARCHIVE_LAG_TARGET initialization parameter.

On this page

Related resources

Amazon RDS API Reference
AWS CLI commands for Amazon RDS
SDKs & Tools 

Related resources

Amazon RDS API Reference
AWS CLI commands for Amazon RDS
SDKs & Tools 
PrivacySite termsCookie preferences
© 2025, Amazon Web Services, Inc. or its affiliates. All rights reserved.