My Oracle Support Banner

RDBPROD: Oracle Rdb Limits and Defaults (Doc ID 1400744.1)

Last updated on APRIL 16, 2024

Applies to:

Oracle Rdb Server on OpenVMS - Version 7.2 and later
HP OpenVMS Itanium
HP OpenVMS Alpha

Purpose

Provide known limits and defaults for an Oracle Rdb database.

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Questions and Answers
 How many storage areas can an Oracle Rdb database have?
 How many after-image journals can an Oracle Rdb database have?
 How many row caches can an Oracle Rdb database have?
 How many OpenVMS cluster nodes can simultaneously attach to an Oracle Rdb database?
 What is the maximum buffer size for an Oracle Rdb database?
 What is the maximum page size for an Oracle Rdb database?
 What is the maximum number of database users for an Oracle Rdb database?
 What is the minimum number of database users for an Oracle Rdb database?
 What is the maximum number of tables?
 What is the maximum number of views?
 What is the maximum number of rows in a table?
 What is the maximum row length for a row cache?
 What is the maximum length of an index key?
 How long can a user-supplied name be?
 How long can a comment be?
 How long can a statement string be?
 How long can a precompiler command line be?
 What is the maximum size of the SQLNAME field in SQLDA?
 What is the maximum size of the SQLNAME field in SQLDA2?
 How small can an after-image journal (AIJ) file be?
 How large can the value of the current TSN grow
 If no value is specified, what defaults are used when creating a database?
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.