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 Autonomous Database Serverless: Manage Resource Availability with Compartment Quotas
- Oracle Autonomous Database on Dedicated Exadata Infrastructure: Manage Resource Availability with Compartment Quotas
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