OCI Database Services Professional key terms
OCI Database Services Professional · Get comfortable with the vocabulary.
- Autonomous Database
- Related: Autonomous Database Serverless, Autonomous Database Dedicated, Auto Scaling
A fully managed Oracle database that automates provisioning, tuning, patching, backups, and scaling. It comes in Serverless and Dedicated deployment options and is tuned for transaction processing, analytics, or both.
- Autonomous Database Serverless
- Related: Autonomous Database, Auto Scaling, Elastic Resource Pool
A deployment where Oracle owns and operates the underlying infrastructure, and compute and storage are billed on consumption. You do not manage hosts, and scaling is largely automatic and elastic.
- Autonomous Database Dedicated
- Related: Autonomous Database, Exadata Cloud Infrastructure, Elastic Resource Pool
A deployment where the database runs in an Exadata infrastructure that is isolated from other tenants. It offers more control over patching schedules, networking, and encryption keys than the serverless option.
- Auto Scaling
- Related: Autonomous Database, Elastic Resource Pool
A feature that automatically increases compute resources for an Autonomous Database when workload demand rises, then returns them when demand falls. It avoids manual resizing while capping the base CPU allocation for billing.
- Elastic Resource Pool
- Related: Autonomous Container Database, Autonomous Database Dedicated
A shared pool of Exadata compute and storage resources in Autonomous Database Dedicated from which autonomous container databases and databases draw capacity. It enables consolidation and pay-for-use allocation across many databases.
- Autonomous Container Database
- Related: Elastic Resource Pool, Pluggable Database, Autonomous Database Dedicated
A container that hosts one or more pluggable databases in the Autonomous Database Dedicated architecture. It sits between the Exadata infrastructure and individual databases and defines the maintenance and resource boundary.
- Pluggable Database
- Related: Autonomous Container Database, Database Home
A self-contained, named database that runs inside a container database and shares its instance and background processes. In OCI it is the unit you connect to and manage for schemas and data.
- Database Home
- Related: Pluggable Database, DB System
A directory that contains the Oracle software installation and its associated configuration for a database. Multiple databases can share one home, and patching is applied at the home level on managed services.
- DB System
- Related: Database Home, Virtual Machine DB System, Bare Metal DB System
A managed compute and storage resource that hosts an Oracle Database on OCI. You choose the shape, edition, and storage, and Oracle handles host provisioning, patching, and backups within the service.
- Virtual Machine DB System
- Related: DB System, Bare Metal DB System, Shape
A DB System built on a flexible or fixed VM shape, offering a balance of cost and performance for many production and non-production workloads. Storage uses block volumes attached to the compute instance.
- Bare Metal DB System
- Related: DB System, Virtual Machine DB System, Exadata Cloud Service
A DB System that runs on a dedicated physical server with no hypervisor layer, giving predictable performance and direct access to local NVMe storage. It suits high-throughput and latency-sensitive database workloads.
- Exadata Cloud Service
- Related: Exadata Cloud Infrastructure, Real Application Clusters, Bare Metal DB System
A managed Exadata offering on OCI that provides scale-out database servers and intelligent storage cells with smart scan and flash acceleration. It supports single-instance and RAC deployments for demanding workloads.
- Exadata Cloud Infrastructure
- Related: Exadata Cloud Service, VM Cluster, Autonomous Database Dedicated
The underlying Exadata hardware and software stack that hosts Exadata Cloud Service and Autonomous Database Dedicated. You provision it as a unit, then create VM clusters or container databases on top.
- VM Cluster
- Related: Exadata Cloud Infrastructure, Real Application Clusters
A group of database VMs created on Exadata Cloud Infrastructure that runs the Oracle Grid Infrastructure and database software. It is the compute layer on which you create databases and define node count and shape.
- Real Application Clusters
- Related: VM Cluster, Exadata Cloud Service
An Oracle architecture where multiple instances on separate nodes share one database, providing high availability and horizontal scaling. On OCI it is available on Exadata deployments, not on single-node DB Systems.
- Shape
- Related: OCPU, DB System, Flexible Shape
A named compute configuration that fixes the number of OCPUs and the amount of memory allocated to a database resource. Choosing a shape determines performance capacity and the base price.
- OCPU
- Related: Shape, Flexible Shape, Auto Scaling
Oracle's unit of compute capacity equal to one physical CPU core, which typically maps to two hardware threads. Billing and sizing for database services are expressed in OCPUs.
- Flexible Shape
- Related: Shape, OCPU
A shape whose OCPU and memory allocation you configure within allowed limits rather than accepting a fixed size. It lets you right-size a DB System or Exadata VM cluster to workload needs.
- Database Edition
- Related: Bring Your Own License, DB System
The Oracle Database license level selected for a DB System, such as Standard Edition or Enterprise Edition. The edition determines which features are available and affects licensing cost.
- Bring Your Own License
- Related: Database Edition, DB System
A licensing model where you apply existing Oracle Database licenses to OCI resources instead of paying the included license price. Eligibility depends on edition, support status, and the service used.
- Data Guard
- Related: Standby Database, Fast-Start Failover, Cross-Region Disaster Recovery
An Oracle feature that maintains a synchronized standby database for disaster recovery and read offload. On OCI it can be configured across availability domains or regions to meet recovery objectives.
- Standby Database
- Related: Data Guard, Fast-Start Failover
A copy of a primary database kept current by redo apply, used for failover or read-only reporting. It can be physical, block-for-block identical, or logical, containing the same data in a different structure.
- Fast-Start Failover
- Related: Data Guard, Standby Database
An Oracle Data Guard capability where an observer automatically promotes the standby if the primary fails. It reduces recovery time without manual intervention when configured with a failover target.
- Cross-Region Disaster Recovery
- Related: Data Guard, Availability Domain, Object Storage Backup
A strategy that places standby or backup copies in a different OCI region so a regional outage does not destroy both copies. It typically combines Data Guard with object storage backups.
- Availability Domain
- Related: Fault Domain, Cross-Region Disaster Recovery
An isolated data center group within an OCI region with independent power and network. Distributing database and standby resources across availability domains protects against a single-site failure.
- Fault Domain
- Related: Availability Domain
A grouping of hardware within an availability domain that shares a common failure risk. Placing resources in different fault domains reduces the chance that one hardware fault affects all of them.
- Object Storage Backup
- Related: Backup Retention, Cross-Region Disaster Recovery
A backup destination where database backups are written to OCI Object Storage buckets rather than local disk. It provides durable, low-cost retention and can be combined with lifecycle policies.
- Backup Retention
- Related: Object Storage Backup, Point-in-Time Recovery
The policy that defines how long database backups are kept before automatic deletion. It balances recovery point objectives against storage cost and compliance requirements.
- Point-in-Time Recovery
- Related: Backup Retention, Flashback
Restoring a database to an exact earlier moment using backups plus archived redo logs. It is used to undo accidental changes such as a dropped table or a bad batch update.
- Flashback
- Related: Point-in-Time Recovery
A set of Oracle features that rewinds a database or table to a prior state without restoring from backup. Flashback Database and Flashback Table are common recovery options for logical errors.
- Transparent Data Encryption
- Related: Key Store, Vault
An Oracle feature that encrypts data at rest in tablespaces and redo logs without changing application code. Keys are managed in a keystore, which on OCI can be an external key management service.
- Key Store
- Related: Transparent Data Encryption, Vault
The secure repository that holds the master encryption keys used by Transparent Data Encryption. On OCI it can be a local wallet or an external key management service integrated with the database.
- Vault
- Related: Key Store, Transparent Data Encryption
An OCI service that creates and manages encryption keys and secrets in hardware security modules. Database services can use it as the external key store for TDE and as a source of credentials.
- Database Connection
- Related: Private Endpoint, Wallet
A named configuration that tells clients and tools how to reach a database, including its service name, host, port, and network access path. It is used by applications, SQL clients, and cloud tooling.
- Wallet
- Related: Database Connection, Private Endpoint
A downloadable credential bundle containing connection strings and certificates that lets a client connect securely to an Autonomous Database. It is required for TLS and mutual authentication connections.
- Private Endpoint
- Related: Network Security Group, Service Gateway
A database access configuration that gives the database an IP address inside a customer VCN instead of a public one. Traffic stays on the private network and access is controlled by security rules.
- Network Security Group
- Related: Private Endpoint, Service Gateway
A virtual firewall applied to a set of VNICs that allows or denies traffic by rule. It is used to restrict which application subnets may reach a database endpoint.
- Service Gateway
- Related: Private Endpoint, Object Storage Backup
A VCN gateway that lets private subnets reach supported OCI services without traversing the internet. It is commonly used so databases can reach Object Storage for backups privately.
- Performance Hub
- Related: Automatic Workload Repository
An OCI console view that consolidates database performance data such as AWR reports, active sessions, and SQL monitoring. It helps diagnose bottlenecks without connecting to the database directly.
- Automatic Workload Repository
- Related: Performance Hub
An Oracle repository that periodically captures performance statistics and active session history for analysis. Its snapshots underpin AWR reports used to compare workload periods and find tuning targets.