OCI Database Services Professional study materials
OCI Database Services Professional study resources

OCI Database Services Professional key terms

OCI Database Services Professional · Get comfortable with the vocabulary.

Autonomous Database

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.

Related: Autonomous Database Serverless, Autonomous Database Dedicated, Auto Scaling
Autonomous Database Serverless

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.

Related: Autonomous Database, Auto Scaling, Elastic Resource Pool
Autonomous Database Dedicated

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.

Related: Autonomous Database, Exadata Cloud Infrastructure, Elastic Resource Pool
Auto Scaling

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.

Related: Autonomous Database, Elastic Resource Pool
Elastic Resource Pool

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.

Related: Autonomous Container Database, Autonomous Database Dedicated
Autonomous Container Database

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.

Related: Elastic Resource Pool, Pluggable Database, Autonomous Database Dedicated
Pluggable Database

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.

Related: Autonomous Container Database, Database Home
Database Home

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.

Related: Pluggable Database, DB System
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.

Related: Database Home, Virtual Machine DB System, Bare Metal DB System
Virtual Machine DB System

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.

Related: DB System, Bare Metal DB System, Shape
Bare Metal DB System

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.

Related: DB System, Virtual Machine DB System, Exadata Cloud Service
Exadata Cloud Service

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.

Related: Exadata Cloud Infrastructure, Real Application Clusters, Bare Metal DB System
Exadata Cloud Infrastructure

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.

Related: Exadata Cloud Service, VM Cluster, Autonomous Database Dedicated
VM Cluster

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.

Related: Exadata Cloud Infrastructure, Real Application Clusters
Real Application Clusters

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.

Related: VM Cluster, Exadata Cloud Service
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.

Related: OCPU, DB System, Flexible Shape
OCPU

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.

Related: Shape, Flexible Shape, Auto Scaling
Flexible Shape

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.

Related: Shape, OCPU
Database Edition

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.

Related: Bring Your Own License, DB System
Bring Your Own License

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.

Related: Database Edition, DB System
Data Guard

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.

Related: Standby Database, Fast-Start Failover, Cross-Region Disaster Recovery
Standby Database

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.

Related: Data Guard, Fast-Start Failover
Fast-Start Failover

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.

Related: Data Guard, Standby Database
Cross-Region Disaster Recovery

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.

Related: Data Guard, Availability Domain, Object Storage Backup
Availability Domain

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.

Related: Fault Domain, Cross-Region Disaster Recovery
Fault 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.

Related: Availability Domain
Object Storage Backup

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.

Related: Backup Retention, Cross-Region Disaster Recovery
Backup Retention

The policy that defines how long database backups are kept before automatic deletion. It balances recovery point objectives against storage cost and compliance requirements.

Related: Object Storage Backup, Point-in-Time Recovery
Point-in-Time Recovery

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.

Related: Backup Retention, Flashback
Flashback

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.

Related: Point-in-Time Recovery
Transparent Data Encryption

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.

Related: Key Store, Vault
Key Store

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.

Related: Transparent Data Encryption, Vault
Vault

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.

Related: Key Store, Transparent Data Encryption
Database Connection

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.

Related: Private Endpoint, Wallet
Wallet

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.

Related: Database Connection, Private Endpoint
Private Endpoint

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.

Related: Network Security Group, Service Gateway
Network Security Group

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.

Related: Private Endpoint, Service Gateway
Service Gateway

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.

Related: Private Endpoint, Object Storage Backup
Performance Hub

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.

Related: Automatic Workload Repository
Automatic Workload Repository

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.

Related: Performance Hub