Database Quotas

Database quota details.

Family name: database

Autonomous Database Quotas

For information on setting quotas for Autonomous Databases and releated infrastructure, see the following links:

Oracle Exadata Database Service on Dedicated Infrastructure, Oracle Exadata Database Service on Cloud@Customer, and Oracle Base Database Service

Name

Scope

Description

bm-dense-io1-36-count Availability domain

Number of BM.DenseIO1.36 DB systems

bm-dense-io2-52-count Availability domain Number of BM.DenseIO2.52 DB systems
exadata-base-48-count Availability domain Number of Exadata.Base.48 DB systems
exadata-full1-336-x6-count Availability domain Number of Exadata.Full1.336 - X6 DB systems
exadata-full2-368-x7-count Availability domain

Number of Exadata.Full2.368 - X7 DB systems and Autonomous Exadata Infrastructure

exadata-half1-168-x6-count Availability domain Number of Exadata.Half1.168 - X6 DB systems
exadata-half2-184-x7-count Availability domain

Number of Exadata.Half2.184 - X7 DB systems and Autonomous Exadata Infrastructure

exadata-quarter1-84-x6-count Availability domain Number of Exadata.Quarter1.84 - X6 DB systems
exadata-quarter2-92-x7-count Availability domain

Number of Exadata.Quarter2.92 - X7 DB systems and Autonomous Exadata Infrastructure

vm-block-storage-gb Availability domain Total size of block storage attachments across all virtual machine DB systems, in GB
vm-standard1-ocpu-count Availability domain Number of VM.Standard1.x OCPUs for the Intel X7 processor (fixed shape) based DB systems in the Oracle Base Database Service
vm-standard2-ocpu-count Availability domain Number of VM.Standard2.x OCPUs for the Intel X7 processor (fixed shape) based DB systems in the Oracle Base Database Service
vm-standard3-ocpu-count Availability domain Number of VM.Standard3.Flex OCPUs for the Intel X9 processor (flexible shape) based DB systems in the Oracle Base Database Service
vm-standard-a1-ocpu-count Availability domain Number of VM.Standard.A1.Flex OCPUs for the Arm-based Ampere A1 processor (flexible shape) based DB systems in the Oracle Base Database Service
vm-standard-e4-ocpu-count Availability domain Number of VM.Standard.E4.flex OCPUs for the AMD processor (flexible shape) based DB systems in the Oracle Base Database Service

For information about shapes that aren't listed, including non-metered shapes, contact Oracle Support.

Examples

To limit the number of virtual machine Base Database systems in a compartment, you must set a quota for the number of CPU cores and a separate quota for the block storage:


#Sets a quota for virtual machine Standard Edition OCPUs to 2 in the MyCompartment compartment
set database quota vm-standard1-ocpu-count to 2 in compartment MyCompartment

#Sets the virtual machine DB system block storage quota to 1024 GB in the same compartment
set database quota vm-block-storage-gb to 1024 in compartment MyCompartment

The following example shows how to prevent the usage of all database resources in the tenancy except for two Exadata full rack X7 resources in a specified compartment:

zero database quotas in tenancy
set database quota exadata-full2-368-x7-count to 2 in compartment MyCompartment

This example of nested quotas shows how to distribute limits for a resource type in a compartment among its subcompartments:

#Allows usage of 3 Autonomous Data Warehouse OCPUs in parent compartment Compartment1
set database quota adw-ocpu-count to 3 in compartment Compartment1

#Allows usage of 1 Autonomous Data Warehouse OCPU in child compartment Compartment1.1
set database quota adw-ocpu-count to 1 in compartment Compartment1.1

#Allows usage of 2 Autonomous Data Warehouse OCPUs in child compartment Compartment1.2
set database quota adw-ocpu-count to 2 in compartment Compartment1.2