RDS for Oracle releases

allow_legacy_reco_protocol

TRUE | FALSE

TRUE

N

Specifies whether the distributed transaction recovery process (RECO) uses the legacy recovery protocol or the upgraded protocol.

allow_weak_crypto

TRUE | FALSE

TRUE

N

Controls whether deprecated or weak algorithms can be used with the DBMS_CRYPTO package.

blockchain_table_retention_threshold

0 to 365000

16

Y

Specifies the maximum idle time (in days) that can be set when creating a blockchain or immutable table without the TABLE RETENTION privilege.

calendar_fiscal_year_start

NONE | DATE[, FORMAT]

NONE

Y

Specifies the start of the fiscal year for use with SQL fiscal functions.

client_prefetch_rows

0 to 4294967295

0

Y

Specifies the number of rows to be prefetched by the Oracle client driver to reduce network roundtrips.

db_recovery_auto_rekey

ON | OFF

ON

Y

Enables or disables automatic tablespace rekey recovery on Data Guard standby instances.

default_credential

credential_name

NONE

Y

Specifies the default credential for the session.

error_message_details

ON | OFF | DISALLOWED

ON

Y

Controls whether the database raises additional stacked error messages with details about data values encountering an error.

group_by_position_enabled

TRUE | FALSE

FALSE

Y

Controls whether a positive integer in a GROUP BY clause is treated as the ordinal position of an expression in the select list.

hybrid_read_only

TRUE | FALSE

FALSE

N

Enables or disables hybrid read-only mode for a PDB, allowing CDB common users to perform patching while local users see read-only mode.

json_behavior

ON_ERROR:ERROR | ON_ERROR:NULL

NONE

Y

Specifies default behaviors at the session level for SQL/JSON functions and conditions.

json_expression_check

ON | OFF

OFF

Y

Enables or disables JSON query statement checking.

lockfree_reservation

ON | OFF

ON

Y

Enables or disables lockfree reservation.

max_columns

STANDARD | EXTENDED

STANDARD

Y

Enables or disables Wide Tables, which increases the maximum column limit to 4096.

max_saga_duration

1 to 2147483647

86400

Y

Specifies the maximum duration for a saga (in seconds).

memoptimize_write_area_size

0 to 2199023255552

0

Y

Specifies the size of the ingest buffer in the large pool of the SGA.

memoptimize_writes

HINT | ON

HINT

Y

Controls whether fast ingest is used automatically for Memoptimized Rowstore tables or only when the MEMOPTIMIZE_WRITE hint is specified.

memory_max_size

0 or 1610612736 to 2199023255552

0

N

Specifies the maximum value to which MEMORY_SIZE can be set.

memory_size

0 or 1610612736 to 2199023255552

0

N

Specifies the size of instance-wide usable memory (combined SGA and PGA).

mle_prog_languages

ALL | JAVASCRIPT | OFF

ALL

Y

Enables or disables the Multilingual Engine (MLE), or selectively enables certain languages.

paranoid_concurrency_mode

TRUE | FALSE

FALSE

N

Enables or disables strictly durable query data gets.

pdb_lockdown_error

RAISE | IGNORE

RAISE

Y

Controls the mode to ignore or raise PDB lockdown errors.

plsql_function_dynamic_stats

PREFERENCE | ON | OFF | CHOOSE

PREFERENCE

Y

Specifies whether dynamic statistics are generated for PL/SQL functions at the session level.

plsql_implicit_conversion_bool

TRUE | FALSE

FALSE

Y

Enables or disables implicit conversions in PL/SQL between numeric, character, and BOOLEAN data types.

priority_txns_high_wait_target

1 to 2147483647

2147483647

Y

Specifies the maximum seconds a HIGH priority transaction waits for a row lock before rolling back the blocker.

priority_txns_medium_wait_target

1 to 2147483647

2147483647

Y

Specifies the maximum seconds a MEDIUM priority transaction waits for a row lock before rolling back the blocker.

priority_txns_mode

ROLLBACK | TRACK

ROLLBACK

Y

Specifies the mode for Priority Transactions (ROLLBACK to enable, TRACK to monitor without enforcement).

read_only

TRUE | FALSE

FALSE

Y

Enables or disables read-only mode for a user session.

result_cache_auto_blocklist

ON | OFF

ON

Y

Enables or disables adaptive result cache object exclusion.

result_cache_integrity

ENFORCED | TRUSTED

TRUSTED

Y

Specifies whether the database enforces result cache integrity for deterministic constructs.

run_addm_for_awr_report

ALL | IMPORT_ONLY | NONE

NONE

Y

Specifies the types of AWR snapshots for which ADDM can be run inside an AWR report.

session_exit_on_package_state_error

TRUE | FALSE

FALSE

Y

Forces a hard session exit when a session's PL/SQL package state has been invalidated if enabled.

soda_behavior

behavior_string

NONE

Y

Controls the behavior for SODA (Simple Oracle Document Access) operations.

sql_error_mitigation

ON | OFF

ON

Y

Enables or disables automatic error mitigation for SQL statements.

sql_history_enabled

TRUE | FALSE

FALSE

Y

Enables or disables SQL history monitoring for user-issued statements in each session.

sql_transpiler

ON | OFF

OFF

Y

Enables or disables the SQL Transpiler, which automatically converts PL/SQL functions into SQL expressions.

standby_parse_limit_seconds

0 to 2147483647

300

Y

Specifies the standby parse time limit (in seconds).

statement_redirect_service

NONE | service_name

NONE

Y

Specifies the statement redirect service.

tablespace_encryption_default_cipher_mode

CFB | XTS

XTS

Y

Specifies the default tablespace encryption block cipher mode.

time_at_dbtimezone

OFF | USER_SQL | DATABASE

OFF

Y

Uses the DB timezone when computing the current time.

tracefile_content_classification

ENABLE | DISABLE | DEFAULT

DEFAULT

Y

Enables or disables output of trace record security label prefix.

transaction_recovery

ENABLED | DISABLED

ENABLED

Y

Specifies whether transaction recovery is enabled or disabled for a PDB.

txn_priority

HIGH | MEDIUM | LOW

HIGH

Y

Specifies the priority for all user transactions in a session.

unified_audit_trail_exclude_columns

NONE | column[, column ] ...

NONE

N

Controls whether columns containing sensitive data are populated in the UNIFIED_AUDIT_TRAIL view.

vector_index_neighbor_graph_reload

RESTART | OFF

RESTART

Y

Specifies whether HNSW reload is enabled.

vector_memory_size

0 to 2199023255552

0

Y

Specifies the size of the Vector Pool in the SGA.

vector_query_capture

ON | OFF

ON

Y

Enables or disables capture of query vectors.

xml_client_side_decoding

TRUE | FALSE

TRUE

Y

Enables or disables XML client-side decoding.

xml_handling_of_invalid_chars

RAISE_ERROR | CONVERT_TO_QUESTION_MARK | CONVERT_TO_REFERENCE_CHAR | CONVERT_TO_NULL

RAISE_ERROR

Y

Handles invalid characters during xmlelement.

xml_params

NONE | parameter=value[, parameter=value ] ...

NONE

Y

Specifies parameters to alter XML behavior.

compatible

23.6.0

blockchain_table_max_no_drop

NONE | 0

NONE

Y

Lets you control the maximum amount of idle time that can be specified when creating a blockchain table.

dbnest_enable

NONE | CDB_RESOURCE_PDB_ALL

NONE

N

Allows you to enable or disable dbNest. DbNest provides operating system resource isolation and management, file system isolation, and secure computing for PDBs.

dbnest_pdb_fs_conf

NONE | pathname

NONE

N

Specifies the dbNest file system configuration file for a PDB.

diagnostics_control

ERROR | WARNING | IGNORE

Y

Allows you to control and monitor the users who perform potentially unsafe database diagnostic operations.

drcp_dedicated_opt

YES | NO

Y

Enables or disables the use of dedicated optimization with Database Resident Connection Pooling (DRCP).

enable_per_pdb_drcp

true | false

true

N

Controls whether Database Resident Connection Pooling (DRCP) configures one connection pool for the entire CDB or one isolated connection pool for each PDB.

inmemory_deep_vectorization

true | false

true

Y

Enables or disables deep vectorization for In-Memory column store scans.

mandatory_user_profile

profile_name

N/A

N

Specifies the mandatory user profile for a CDB or PDB.

optimizer_capture_sql_quarantine

true | false

false

Y

Enables or disables the automatic creation of SQL Quarantine configurations.

optimizer_use_sql_quarantine

true | false

false

Y

Enables or disables the use of SQL Quarantine configurations.

result_cache_execution_threshold

0 to 68719476736

2

Y

Specifies the maximum number of times a PL/SQL function can be executed before its result is stored in the result cache.

result_cache_max_temp_result

0 to 100

5

Y

Specifies the percentage of RESULT_CACHE_MAX_TEMP_SIZE that any single cached query result can consume.

result_cache_max_temp_size

0 to 2199023255552

RESULT_CACHE_SIZE * 10

Y

Specifies the maximum amount of temporary tablespace (in bytes) that can be consumed by the result cache.

sga_min_size

0 to 2199023255552 (maximum value is 50% of sga_target)

0

Y

Indicates a possible minimum value for SGA usage of a pluggable database (PDB).

tablespace_encryption_default_algorithm

GOST256 | SEED128 | ARIA256 | ARIA192 | ARIA128 | 3DES168 | AES256 | AES192 | AES128

Y

Specifies the default algorithm the database uses when encrypting a tablespace.

compatible

21.0.0

lob_signature_enable

TRUE, FALSE (default)

Y

Enables or disables the LOB locator signature feature.

max_datapump_parallel_per_job

1 to 1024, or AUTO

Y

Specifies the maximum number of parallel processes allowed for each Oracle Data Pump job.

compatible

19.0.0